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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional Hide Expression based on Dimension Value

I have not found a thread on this topic, so I'm hoping someone can help now.  I have a pivot table with 2 expressions.  I want Expression1 to show with all dimensions, but I want Expression2 to only show when dimension value = 'A' or 'B', not for 'C' or 'D'.

I know i can exclude the values with an if statement embedded in the expression, but then I have expression columns that are always blank and just taking up space... and the user is requesting they be suppressed for those dimension values. 

I have tried using the Conditional Show feature on the expression with If(Match(Brand,'A','B'),1,0) but that hides the expression for every dimension.

1 Reply
swuehl
MVP
MVP

Yes, the condition for the expression will be evaluated once per chart, not per dimension value.

And no, I believe you can't hide an expression column completely only for certain dimension values using QV table charts.