Fast Filter
Fast Filter offers you an convenient way to limit the data you want to display in the pivot sheet to improve your overview. This functionality lets you sift through the data using the filters from a specific Dataset or Favorite View with the purpose of displaying specific data. The filters are easily selected from combo boxes, offering you the opportunity to filter the data before you display it.
Once you have defined the filter(s), load the data using .
Fast Filter options are restricted to the filters you included in your Dataset or Favorite View. The name of the combo boxes corresponds to the included filters.
Fast Filter is a default option. You can clear this option in . You can also specify if a Fast Filter can be selected or set to required in some key columns. Select the check box in .
This table shows the available functions for fast filter:
| Name | Description |
|---|---|
| Reload | This button is used to refresh the data that is based on the
selected fast filter. The Reload button will not change the view layout. |
| Clear | This button is used to restart the fast filter selection. |
| Combo boxes | The combo boxes are used to specify the fast filters. |
Using Fast Filter
If a user clicks on a Fast Filter, the list is populated with items from the database query for distinctive values. The items are based on the filter conditions that are set in Favorite View and user rights. You can specify or select a value on a fast filter list.
An additional filter is created depending on the key selected from another fast filter list. If a value is changed from a fast filter list, all items from other fast filter lists are cleared. The lists are replaced by new items based on the new filter selected.
Fast Filter also supports unicode to work with Central European languages.
You can also specify texts as fast filters. This table shows the texts that you can use as a fast filter:
| Fast Filter | Result |
|---|---|
| 05 | Displays all elements that start with 05 |
| *05* | Displays all elements that contain 05 |
| *05 | Displays all elements that end with 05 |
| [ ] square brackets | Used as filter for an explicit value with inner brackets for alternative values |