Put a condition on an expression

ali_hijazi — Mon, 18 Jun 2012 07:47:52 GMT

Dear

I got a pivot table with seven expressions; the chart response is slow

I'm wondering if I put a condition on expressions so as they are not calculated at once; i.e. I put a button to enable / disable expressions

So suppose I put if($(condition) =1,1,0) does qlikview calculates this expression in the background

Re: Put a condition on an expression

Mon, 18 Jun 2012 07:53:34 GMT

When you have Qlikview 11 this is possible. Per expression you'll find the checkbox 'conditional' where you can enter your desired condition.

You could connect this to a button or to a listbox or whatever you like...

One example could be that in your loadscript you have a few options

load inline

ShowID whatToShow

1 show everything

2 show only expression 1

3 show only expression 2

etcetera

and that your conditional expression is like ShowID=1 or 2 or 3

then depending on what you select in your listbox, will be visible