Exclude certain values from a dimension's field

[shamitshah]

Hi,

I have the following values in a Dimension called Category:

A

B

C

D

I want to exclude A and B. I tried the expression if(Category<>'A' and 'B',Category) and it did not seem to work.

Any ideas?

Thanks

Shamit

[sunny_talwar · Accepted solution]

Try this:

If(not Match(Category, 'A', 'B'), Category)

and remember to 'Suppress When Value Is Null' on the dimensions tab

[shamitshah]

Hi Sunny,

Thanks for the above. It works.

Where do you 'Suppress When Value Is Null' on the dimensions tab in QlikSense?

Thanks

Shamit

[sunny_talwar]

You need to uncheck this -> Show Null value for your dimension

[shamitshah]

Thanks Sunny!

[sunny_talwar]

Not a problem my friend

[wttaryde]

Hi Sunny,

I am able to use the expression to control my dimension if I know what I want to exclude.  I would like to put modify the expression to exclude values based upon a filtered group.  My Measure expression ignores filters, so I need this to be in the dimension.  Using this example:    If(not Match(Category, 'A', 'B'), Category)

I'd like to change      (Category, 'A', 'B')    to  (Category,GetFieldSelections(Category))   or Category,GetCurrentSelections(Category))

or something like that but haven't found an expression that works.