Using the Quick Filter
This functionality is only available if you have sufficient privileges. Your privileges are maintained by your system administrator in the IT Management Console.
Quick filters are predefined filter options that can be used in a List or when drilling down from a Chart or a Pivot. The available quick filters depend on the field type. Depending on your authorization, you may not be able to add a quick filter if a Jump is already defined.
If you remove the quick filter again, the Display is updated immediately.
To use a quick filter
Execute the Angle that contains the Display (see Executing an Angle or Template ). The Angle results page opens.
Find the Display in the Displays pane . If there are many Displays, the Display tab of the Display might not be immediately visible. In that case, click
to see the list of available Displays and find your Display there.
If you are working with a Chart or a Pivot, drill down to the field that you want to filter.
Right-click on a cell in the column that you want to filter on.
Select Quick Filter. The available filters for the field are shown. See Quick filter reference for more information.
Select the filter that you want to apply. The filter is added to the Display details. The filter is not saved yet, which is indicated by
next to the filter name and the Display tab.
-
In the Action bar , click
to save the Display .
You can also save the entire Angle and all the Displays it contains in one go. Click the caret of the Save Display button (
) and select Save all .
Quick Filter Reference
Quick filters are predefined filter options that can be used in a List. The available quick filters depend on the field type.
If the item is not a number, the following filters are available:
- Is equal to
- Is not equal to
- Is empty
- Is not empty
If the item is a number, the following filters are available:
- Is between
- Is not between
- Is empty
- Is not empty
- Is greater than
- Is smaller than
You need to select a range for some options because numbers are sometimes shown rounded in the Display. In that case, they are not exactly the same values as the corresponding values in the database, and a match cannot be found. To prevent this situation, ranges have been added.
The range of the numbers used for the filter depends on your decimal settings (see Specifying the data formats). It is determined as follows:
To determine the lower bound, subtract 1 from the last visible digit and add a 5 after it.
To determine the upper bound, add a 5 after the last visible original digit.
Examples:
-
1.23k:
Lower bound: Subtract 1 from the last digit: 1.22k. Add a 5: 1.225k
Upper bound: Add a 5: 1.235k
The range is 1.225k-1.235k (1225-1235).
-
1230:
Lower bound: Subtract 1 from the last digit: 1229. Now add a 5 after it (don't forget the decimal point): 1229.5
Upper bound: add a 5. Don't forget the decimal point: 1230.5
The range is 1229.5-1230.5.
1.2m: the range is between 1.15m and 1.25m (1150000-1250000)
1k: the range is between 0.5k and 1.5k (500-1500).