Skip to main content

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”.

important

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.

important

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

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 Add field 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 =
  6. Click the Save

Qalyptus Filter Fields Values

Filter with variables

To create a filter using a variable, click the Add variable 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 Add 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.

Qalyptus Filter Values

Use a filter

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