Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shamitshah
Contributor

Exclude certain values from a dimension's field

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Exclude certain values from a dimension's field

Try this:

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

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

5 Replies
MVP
MVP

Re: Exclude certain values from a dimension's field

Try this:

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

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

Highlighted
shamitshah
Contributor

Re: Exclude certain values from a dimension's field

Hi Sunny,

Thanks for the above. It works.

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

Thanks

Shamit

MVP
MVP

Re: Exclude certain values from a dimension's field

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

Capture.PNG

shamitshah
Contributor

Re: Exclude certain values from a dimension's field

Thanks Sunny!

MVP
MVP

Re: Exclude certain values from a dimension's field

Not a problem my friend