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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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.