Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.