Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Toggle to hide/show rows based on values

Hi, I am new to Qlikview and would appreciate any assistance anyone can provide. I have a calculated expression column with numbers ranging from 1 to 5. I want to create a button that will filter out or hide all the rows with 5's in the calculated expression column in that table. Thank you.

1 Reply
swuehl
MVP
MVP

One solution would be to 'zero' all expression values and enable 'suppress zero values' on presentation tab.

For example, if you have two expression, your '1-5' expression and another one ( Sum(Value) ), try something like this:

Create a button that set a variable vVar to 0 , if you want to hide the values, and to 1 if you want to show the values.

Then alter all your current expressions:

"Exp1":

=If ( "1-5" = 5 and vVar, 0, Sum(Value) )

"1-5":

=If( YourCurrent1To5Exp = 5 and vVar, 0, YourCurrent1To5Exp)

Replace Sum(Value) and YourCurrent1To5Exp with your appropriate expressions.