Parameter | Description |
Figure | Is equal to Is not equal to Is less than Is less than or equal to Is greater than Is greater than or equal to Is empty Is not empty |
Text | Is equal to Is not equal to Starts with Ends with Contains Does not contain Is empty Is not empty |
Date | Before After In Before or on On or after Is empty Is not empty |
) Operator condition icon to view the settings. The settings are also displayed in the tool tip.
For filter conditions using the comparison operators is equal to, starts with, ends with, contains, and on the predefined applied list values are set to ANY.For filter conditions using the comparison operators is not equal to, does not contain, is less than, is greater than, and after the predefined applied list values are set to ALL.The setting of the applied filter values can be changed for all comparison operators except is equal to, is not equal to, and on. Click the () Operator condition icon and select the settings required.Data type | Basic set | Comparison operator | Applied filter values (bold=default) | Filter set (Filter list) | Result set | Description (tool tip) |
DATE | 2010, 2013, 2017, 2020, 2022, 2025 | On (fix) | ANY | 2013, 2016, 2017 | 2013, 2017 | Is on the dates of the filter list. |
DATE | 2010, 2013, 2017, 2020, 2022, 2025 | Before (default) | ALL | 2013, 2016, 2017 | 2010 | Is before all dates of the filter list. |
DATE | 2010, 2013, 2017, 2020, 2022, 2025 | Before (switchable) | ANY | 2013, 2016, 2017 | 2010, 2013 | Is before the last date of the filter list. |
DATE | 2010, 2013, 2017, 2020, 2022, 2025 | Before or on (default) | ALL | 2013, 2016, 2017 | 2010, 2013 | Is before or on the first date of the filter list. |
DATE | 2010, 2013, 2017, 2020, 2022, 2025 | Before or on (switchable) | ANY | 2013, 2016, 2017 | 2013, 2016, 2017 | Is before or on the last date of the filter list. |
DATE | 2010, 2013, 2017, 2020, 2022, 2025 | After (default) | ALL | 2013, 2016, 2017 | 2020, 2022, 2025 | Is after all dates of the filter list. |
DATE | 2010, 2013, 2017, 2020, 2022, 2025 | After (switchable) | ANY | 2013, 2016, 2017 | 2017, 2020, 2022, 2025 | Is after the first date of the filter list. |
DATE | 2010, 2013, 2017, 2020, 2022, 2025 | On or after (default) | ALL | 2013, 2016, 2017 | 2017, 2020, 2022, 2025 | Is on or after the last date of the filter list. |
DATE | 2010, 2013, 2017, 2020, 2022, 2025 | On or after (switchable) | ANY | 2013, 2016, 2017 | 2013, 2017, 2020, 2022, 2025 | Is on or after the first date of the filter list. |
NUMBER | 3, 12, 25, 30, 55, 92 | is equal to (fix) | ANY | 12, 15, 25 | 12, 25 | Is equal to any number of the filter list. |
NUMBER | 3, 12, 25, 30, 55, 92 | is not equal to (fix) | ALL | 12, 15, 25 | 3, 30, 55, 92 | Is not equal to all numbers of the filter list. |
NUMBER | 3, 12, 25, 30, 55, 92 | is less than (default) | ALL | 12, 15, 25 | 3 | Is less than the lowest number of the filter list. |
NUMBER | 3, 12, 25, 30, 55, 92 | is less than (switchable) | ANY | 12, 15, 25 | 3, 12 | Is less than the highest number of the filter list. |
NUMBER | 3, 12, 25, 30, 55, 92 | is less than or equal to (default) | ALL | 12, 15, 25 | 3, 12 | Is less than or equal to the lowest number of the filter list. |
NUMBER | 3, 12, 25, 30, 55, 92 | is less than or equal to (switchable) | ANY | 12, 15, 25 | 3, 12, 25 | Is less than or equal to the highest number of the filter list. |
NUMBER | 3, 12, 25, 30, 55, 92 | is greater than (default) | ALL | 12, 15, 25 | 30, 55, 92 | Is greater than the largest number of the filter list. |
NUMBER | 3, 12, 25, 30, 55, 92 | is greater than (switchable) | ANY | 12, 15, 25 | 25, 30, 55, 92 | Is greater than the smallest number of the filter list. |
NUMBER | 3, 12, 25, 30, 55, 92 | is greater than or equal to (default) | ALL | 12, 15, 25 | 25, 30, 55, 92 | Is greater than or equal to the largest number of the filter list. |
NUMBER | 3, 12, 25, 30, 55, 92 | is greater than or equal to (switchable) | ANY | 12, 15, 25 | 12, 25, 30, 55, 92 | Is greater than or equal to the smallest number of the filter list. |
TEXT | Berlin, Paris, Boston, Tokyo, Bangalore, Sofia | is equal to (fix) | ANY | Berlin, Paris | Berlin, Paris | Is equal to any value of the filter list. |
TEXT | Berlin, Paris, Boston, Tokyo, Bangalore, Sofia | is not equal to (fix) | ALL | Berlin, Paris | Boston, Tokyo, Bangalore, Sofia | Is not equal to all values of the filter list. |
TEXT | Berlin, Paris, Boston, Tokyo, Bangalore, Sofia | starts with (default) | ANY | B, P | Berlin, Paris, Boston, Bangalore | Starts with any value of the filter list. |
TEXT | Berlin, Paris, Boston, Tokyo, Bangalore, Sofia | starts with (switchable) | ALL | B, BE, BER | Berlin, Bernau | Starts with all values of the filter list. |
TEXT | Berlin, Paris, Boston, Tokyo, Bangalore, Sofia | ends with (default) | ANY | N, E | Berlin, Boston, Bangalore | Ends with any value of the filter list. |
TEXT | Berlin, Paris, Boston, Tokyo, Bangalore, Sofia | ends with (switchable) | ANY | S, IS | Paris, Memphis | Ends with all values of the filter list. |
TEXT | Berlin, Paris, Boston, Tokyo, Bangalore, Sofia | contains (default) | ANY | I, P | Berlin, Paris, Sofia | Contains any value of the filter list. |
TEXT | Berlin, Paris, Boston, Tokyo, Bangalore, Sofia | contains (switchable) | ALL | I, P | Paris | Contains all values of the filter list. |
TEXT | Berlin, Paris, Boston, Tokyo, Bangalore, Sofia | does not contain (default) | ALL | I, P | Boston, Tokyo, Bangalore | Does not contain all values of the filter list. |
TEXT | Berlin, Paris, Boston, Tokyo, Bangalore, Sofia | does not contain (switchable) | ANY | I, P | Berlin, Boston, Tokyo, Bangalore, Sofia | Does not contain any value of the filter list. |