Filtering data from data connectors
You enter a data filter expression by selecting Filter data in the Select data to load step. Selecting Filter data opens a text box where you enter a filter expression. For example:
Sales >= 40000
Filter data selects from individual fields, such as Sales. It operates as an
- =
- >
- >=
- <
- <=
- IN
- BETWEEN
- LIKE
- IS NULL
- IS NOT NULL
Qlik Sense builds a
The
Sales <= 30000 AND RegionID = 45
The OR operator can be used to filter data that matches either condition. For example:
Name = 'Smith' OR Name = 'Jones'
You can get the same results from the IN operator. The IN operator is a shorthand method for using multiple OR conditions. For example:
Name IN ('Smith', 'Jones')
For information about adding data, see: