Set Analysis expression

imhappiee — Mon, 04 May 2015 06:05:44 GMT

Guys,

Can somebody help me out converting this if condition to a set analysis expression

=if(sum(DISTINCT{$<Flag={'S'},FiscalYear={$(=vMaxYear-1)},FiscalQuarter={'Q1'}>}SVPL_amount)>0 and sum(DISTINCT{$<Flag={'H'},FiscalYear={$(=vMaxYear-1)},FiscalQuarter={'Q1'}>}HWPL_amount)<=0,

0.01,if(sum(DISTINCT{$<Flag={'S'},FiscalYear={$(=vMaxYear-1)},FiscalQuarter={'Q1'}>}SVPL_amount)<=0 and sum(DISTINCT{$<Flag={'H'},FiscalYear={$(=vMaxYear-1)},FiscalQuarter={'Q1'}>}HWPL_amount)<=0,0,

(sum(DISTINCT{$<Flag={'S'},FiscalYear={$(=vMaxYear-1)},FiscalQuarter={'Q1'}>}SVPL_amount)/sum(DISTINCT{$<Flag={'H'},FiscalYear={$(=vMaxYear-1)},FiscalQuarter={'Q1'}>}HWPL_amount)/100)))

Thanks In Advance

Kind Regards,

Happy

Re: Set Analysis expression

Gysbert_Wassenaar — Mon, 04 May 2015 08:30:58 GMT

That's not possible. A set analysis expression cannot branch like an if statement.

topic Re: Set Analysis expression in QlikView

Set Analysis expression

Re: Set Analysis expression