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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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.

Labels (1)
1 Reply
swuehl
Champion III
Champion III

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.