I have the following values in a Dimension called Category:
I want to exclude A and B. I tried the expression if(Category<>'A' and 'B',Category) and it did not seem to work.
If(not Match(Category, 'A', 'B'), Category)
and remember to 'Suppress When Value Is Null' on the dimensions tab
Thanks for the above. It works.
Where do you 'Suppress When Value Is Null' on the dimensions tab in QlikSense?
You need to uncheck this -> Show Null value for your dimension
Not a problem my friend
Retrieving data ...