Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be use set analysis within your expression
Sum({<Type = {'XQH', 'XQC' AND 'ZBC'}>}Measure)