Exclude null

[Anonymous]

Hi,

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.

stalwar1‌

[sunny_talwar]

May be use set analysis within your expression

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