Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with match condition

I have created a pivot table that has a dimension for specific products.

The field has 5 different values and I want the dimension to only display information for three of the values.

I'm using a =if(Match(PRODUCTS,'ABC','DEF','GHI'),PRODUCTS)

My problem is that the pivot table is showing a blank field for anything other than the matched values.  I don't want this to display at all.  Is there a way to get it not to show this extra row?????

1 Reply
Not applicable
Author

Just check the box "Suppress when value is null" under the Dimensions tab.