Re: Convert IF to Set analysis - Qlik Community

Anonymous · ‎2017-10-19

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 · ‎2017-10-19

Hi,

like this

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

or

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

Thanks,Deva

Aurelien_Martinez · ‎2017-10-19

Hi,

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

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!

Anil_Babu_Samineni · ‎2017-10-19

Or

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.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

its_anandrjs · ‎2017-10-19

Try this

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

Or

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

pradosh_thakur · ‎2017-10-19

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

Learning never stops.