IF Statement within Set Analysis

Thu, 17 Nov 2011 16:36:13 GMT

I have this expression:

num(sum({<Year={$(=Only(Year))}, Qtr_Num={2}, [Budget/Actual]={Actual}>} GWP/1000), '#,##0'),

I have that for different columns for the different quarters. I'd like it to include an if statement where is says IF the Qtr_Num above is less than or equal to the Qtr-Num selected [Budget/Actual]={Actual}, else [Budget/Actual]={Budget}.

Any help would be appreciated.

IF Statement within Set Analysis

Thu, 17 Nov 2011 17:04:18 GMT

Hi, the easiest way would be to have the IF outside the Set Analysis and have two num() statements. Alternatively you could have the {Actual} / {Budget} replaced with a variable which contains an Dollar-sign expansions which could be you IF statement resulting in either the text of 'Budget' or 'Actual'. Hope that makes sense

topic IF Statement within Set Analysis in QlikView

IF Statement within Set Analysis

IF Statement within Set Analysis