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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-08-20 05:10 PM

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,536 Views
0 Likes
1 Reply
swuehl
MVP
MVP
‎2015-08-20 05:18 PM

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.

769 Views
0 Likes