topic Re: converting if to set analysis in QlikView

converting if to set analysis

Wed, 27 Mar 2013 11:22:27 GMT

sum(if(len([Actual FOUR Date])>0 and [Actual FOUR Date] >= date(MakeDate(2012,(vselectMonth),01)) and [Actual FOUR Date] <= date(MakeDate(2012,(vselectMonth),(vlastdate)))
and State='ANDHRA PRADESH'
,Order_In_MW))

Please help me out... change the above if condition to set analysis...

Re: converting if to set analysis

manideep78 — Wed, 27 Mar 2013 11:31:01 GMT

Try this,

Sum({<[Actual FOUR Date]={">=$(=date(MakeDate(2012,(vselectMonth),01)))<=$(=date(MakeDate(2012,(vselectMonth),(vlastdate))))"},

State={'ANDHRA PRADESH'}>}Order_In_MW)

Re: converting if to set analysis

Wed, 27 Mar 2013 11:56:42 GMT

Try this

if(Len([Actual FOUR Date])>0,

Sum({<[Actual FOUR Date]={">=$(=MakeDate(2012,(vselectMonth),01))<=$(=MakeDate(2012,(vselectMonth),(vlastdate)))"},State={'ANDHRA PRADESH'}>}Order_In_MW),'')

Best of luck

Re: converting if to set analysis

CELAMBARASAN — Wed, 27 Mar 2013 12:07:43 GMT

No need to check the lenght of datefield here.

sum(if(len([Actual FOUR Date])>0 and [Actual FOUR Date] >= date(MakeDate(2012,(vselectMonth),01)) and [Actual FOUR Date] <= date(MakeDate(2012,(vselectMonth),(vlastdate)))

and State='ANDHRA PRADESH'

,Order_In_MW))

Simply use it as

Sum({<[Actual FOUR Date]={">=$(=date(MakeDate(2012,(vselectMonth),01)))<=$(=date(MakeDate(2012,(vselectMonth),(vlastdate))))"},State={'ANDHRA PRADESH'}>} Order_In_MW)

Hope it helps

Celambarasan