Create filter

Qalyptus allows you to apply filters on Objects, Reports before generating your reports. Filters can be static values or calculated values using Qlik Sense expressions and bookmarks. The expression must use Qlik Sense syntax and return a unique value.

note

Filters are evaluated in the following order: report -> object.

Example: If the filter used in the report is “City = Paris, Munich” and the filter used in an object is “City = London”, the filter that will be applied is “City = London”.

info

A filter can overwrite the current selections if the values to be selected are not among the possible values.

With Qalyptus, you can create three types of filters:

• Filter with fields
• Filter with variables
• Filter with bookmarks

To create a filter, go to the Filters and click the Create button. Your screen will look something like this:

1. Give a name to your filter.
2. Add a description if you wish (optional).
3. Select a project
4. Click Save.

You will be redirected to the filter Overview tab. Navigate to the Values tab to configure the filter.

info

Your filter may consist of field values, variables, and bookmarks. The order is important; add the filter items in the order in which you want Qalyptus to apply them.

Filter with fields

Choose a field and the values to select. You can select multiple values.

To select a static value, enter it without quotes or double quotes. To select a dynamic value, enter a Qlik Sense expression or variable beginning with the symbol equal (Example 1: =Max(Year) | Example2: =vLastYear).

note

The operator used to select the values is OR.

Let's, for example, create a filter using the Region field and select European countries.

• The Region field contains the following values: Germany, Japan, Nordic, Spain, and the USA
• Our filter will be: Region = Germany, Nordic, Spain

To create the filter, click the Select field values button.

1. Select an app in the app list.
2. Choose the Region field in the fields list.
3. Click the Add button and enter the value to select: Germany (without quotes).
4. Do the same for Nordic and Spain.
5. Note that you can use a Qlik expression starting with the symbol equal (=).
6. Click the Save.

Filter with variables

Choose the variable and the value to set.

To set a static value, enter it without quotes or double quotes. To set a dynamic value, enter a Qlik Sense expression or variable beginning with the symbol equal (Example 1: =Max(Year) | Example2: =vLastYear).

To create a filter using a variable, click the Set variable value button.

1. Select an app in the app list.
2. Select a variable to which you will assign a value.
3. Enter a static or dynamic value in the Value field. Example: 2022 or =Max(Year).
4. Click the Save.

Filter with bookmarks

To create a filter using a bookmark, click the Apply bookmark button.

1. Select an app in the app list.
2. Select the bookmark to apply.
3. Click OK.

Order filter values

The filter values are added in the creation order. You can order the items using the arrow buttons.

Use a filter

Filters can be used to filter an Object, or a task report. Visit the following to learn more:

• Add a filter to an object
• Add a filter to a task report