topic Re: Convert IF to Set analysis in QlikView

Convert IF to Set analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

How to convert the below IF expression in to Set analysis

sum(if(Periods=GetFieldSelections(Period1) and Flag1=3,[Gross Value Local Currency]))

devarasu07 — Thu, 19 Oct 2017 07:17:09 GMT

Hi,

like this

sum({$<Periods={'$(=GetFieldSelections(Period1))'},Flag1={3}>}[Gross Value Local Currency])

sum({$<Periods={'$(=GetFieldSelections(Periods1))'}>+<Flag1={3}>}[Gross Value Local Currency])

Thanks,Deva

Aurelien_Martinez — Thu, 19 Oct 2017 08:29:58 GMT

Hi,

Sum({<Periods=P(Period1), Flag1={3}>} [Gross Value Local Currency])

Aurélien

Anil_Babu_Samineni — Thu, 19 Oct 2017 08:52:20 GMT

sum({$<Periods={$(=Concat(Chr(39) & Period1 & Chr(39), ','))},Flag1={3}>}[Gross Value Local Currency])

Note - Second one won't work, Because + Consider in analysis as OR not AND.

its_anandrjs — Thu, 19 Oct 2017 09:09:46 GMT

Try this

Sum({<Periods ={"$(=GetFieldSelections(Period1))"},Flag1={3} >} [Gross Value Local Currency])

Sum({<Periods ={"$(=GetFieldSelections(Period1))"},Flag1={'3'} >} [Gross Value Local Currency])

pradosh_thakur — Thu, 19 Oct 2017 10:58:00 GMT

Hi Anand

what if more than one selections are there? will it work there too? i guess we need to modify the expression for that.

regards

Pradosh