Skip to main content

Filtering data from data connectors

Information noteFilter data is not available for all 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 SQL WHERE clause. Most operators and keywords used in WHERE clauses can be used with Filter data. Valid operators include:

  • =
  • >
  • >=
  • <
  • <=
  • IN
  • BETWEEN
  • LIKE
  • IS NULL
  • IS NOT NULL

Qlik Sense builds a WHERE clause in the data load script from the expression entered in Filter data.

The AND operator can be used to combine operators, such as when you want to filter across more than one field. For example:

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:

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!