Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.


Exclude null


I am trying to exclude null values in a flat table by unticking the 'Include null values' checkbox, but this does not remove the rows.

Can I remove nulls values or restrict the data using an expression?

I have a column called 'Type' and I only want to return values 'XQH', 'XQC' AND 'ZBC'. Any other values I would like removed from my table.

I would have added this in the data load editor but I need to exclude this data on the front end, as the script is being used to create other tables.

Thanks in advance.


Tags (1)
1 Reply

Re: Exclude null

May be use set analysis within your expression

Sum({<Type = {'XQH', 'XQC' AND 'ZBC'}>}Measure)

Community Browser