Filtering a dataset

You can add a filter to a dataset to reduce the set of data values in Landing data tasks that land data through Qlik Data Gateway - Data Movement, Storage, and Transform data tasks.

1. Click Datasets.

2. Click Filter.

   The expression builder is opened.

3. Build an expression to define the filter. The filter should evaluate to a true value for the data rows to keep.

   You can use columns in the dataset, functions, and operators.

   Click to move an item to the expression.

   You can also use all functions supported by the cloud data platform.

   Information noteIf you use Azure Synapse Analytics as data platform, $RTRIM and $LTRIM will only trim space characters regardless of which character you specify to trim.

4. Click Extract parameters.

   You can now add a test value to Value to test for all parameters.

5. Click Test expression.

   You should now see the result of the filter expression, using the test values.

6. When you are ready, click OK.

The filter is now added, based on the expression you used. You can see the filter expression by hovering on the Filter button.