topic Re: Converting if to Set Analysis in QlikView

Converting if to Set Analysis

Sat, 11 Aug 2012 06:51:49 GMT

Dear Champs,

How can I convert the following if statement to set analysis.

Sum(if(DATE>=num(MonthStart('$(Variable)')) and DATE <=num(MonthENd('$(Variable)')) , AMOUNT))

Thanks in Advance

DERIK

Sat, 11 Aug 2012 09:26:39 GMT

Dear,

Derik.

i think it's better if you create two variables

v1=Num(Monthstart(field))

v2=num(MonthEnd(field))

Expression:

SUM( {$<DATE = {">=$(#v1) <=$(#v2)"} >} AMOUNT)

Thanks,

Mukram.

Sat, 11 Aug 2012 10:02:06 GMT

Thanks Mukram,

But I don't want to create a variable. Becoz I have 30expression, creating variable willl be tough.

DERIK

Sat, 11 Aug 2012 13:59:01 GMT

Hi Derik,

Try the below Expression:

Sum ({<DATE = {">=$(=Num(MonthStart(Min(FIELD))))<=$(=Num(MonthStart(Max(FIELD))))"}>}Amount)

Regards,

Desmortes

somenathroy — Sat, 11 Aug 2012 15:09:49 GMT

Try with this:

Sum( {< DATE = {' >= $(=Num(MonthStart("$(Variable)"))) <= $(=Num(MonthEnd("$(Variable)")))'} >} AMOUNT)

MayilVahanan — Sat, 11 Aug 2012 19:32:06 GMT

Try like this

Sum ({<DATE = {">=$(=MonthStart(Min(FIELD)))<=$(=MonthStart(Max(FIELD)))"}>}Amount)

Hope it helps