Toggle to hide/show rows based on values

Thu, 21 Jan 2016 18:56:25 GMT

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.

Re: Toggle to hide/show rows based on values

swuehl — Thu, 21 Jan 2016 21:57:04 GMT

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.

topic Re: Toggle to hide/show rows based on values in QlikView

Toggle to hide/show rows based on values

Re: Toggle to hide/show rows based on values