Create and Manage Filters

Introduction

For the new major release 2022 we have made a complete redesign of filters with focus on faster input, combination of multiple filters and improved visibility. We hope that you will like the new feature!

See also

To learn how to use the table ribbon menu, please refer to Create a Table Output.

In case you want to learn how to use the Export to XLSX or CSV, then please refer to Export Results to Excel.

Please accept marketing cookies to watch this video.

Syntax

Relational Operators

Symbol	Operator
==	equal (default if nothing is specified)
!=	not equal
>	greater than
<	less than
>=	greater than or equal
<=	less than or equal

Logical NOT

Symbol	Operator
!	The logical NOT (!) operator (logical complement, negation) takes truth to falsity and vice versa.

! at beginning inverts other filter conditions, e.g.

• ![1;2] is the negation of [1;2] or

• !<=3 is the negation of <=3 or

• … etc.

Wildcard

Symbol	Operator
*	Any number of characters
?	Any one character

The wildcard ? and * can be used on columns that contain text and integer values.

Range Filter

Syntax	Short description
[FROM;TO]	Range filter between FROM and TO, include both values
[FROM;TO[	Range filter between FROM and TO, include FROM, but exclude TO
]FROM;TO]	Range filter between FROM and TO, include TO, but exclude FROM
]FROM;TO[	Range filter between FROM and TO, exclude both values

Examples:

• [1;5] = range between 1 and 5, including 1 and 5

• ]1;5[ = range between 1 and 5, excluding 1 and 5

• ]1;5] = range between 1 and 5, excluding 1, but including 5

• [1;5[ = range between 1 and 5, excluding 5, but including 1

Loop filter

Syntax	Short description
(FROM;TO;INCREMENT)	Filter all values by using a loop with an increment.

Example:

• (1;5;1) = will filter 1,2,3,4,5

• (1;5;2) = will filter 1,3,5

• (1;5;3) = will filter 1,4

Please note that the “Loop filter” works only on columns that contains integer values.

Special filter

Extreme values

Hint

The documentation regarding “extreme values” filter is still under development. A video is coming soon…