topic Need help in set analysis expression!! in QlikView

Need help in set analysis expression!!

Fri, 04 May 2012 10:37:54 GMT

i need to write an expression like ver i need to select all the measures in the last day of previous three months

if current selection is month=dec and year= 2011

then the measures should be from the date '31-Nov-2011', '31-Oct-2011' and '31-Sep-2011'

i knid of came up with an expression but never worked.

SUM({< DATE = {"=$(=MonthEnd(Addmonths(DATE,-1)),=MonthEnd(Addmonths(DATE,-2)),=MonthEnd(Addmonths(DATE,-3))"} >} Measure)

plz help me with the correct expression

Need help in set analysis expression!!

chematos — Fri, 04 May 2012 20:35:59 GMT

Try this and tell me if it works

SUM({<DATE={"=$(=MonthEnd(Addmonths(DATE,-1))"},DATE={"=$(=MonthEnd(Addmonths(DATE,-2))"},DATE={"=$(=MonthEnd(Addmonths(DATE,-3))"} >} Measure)

Hope this helps.

Regards,

Chema

Need help in set analysis expression!!

CELAMBARASAN — Fri, 04 May 2012 20:49:51 GMT

Hi,

Check with it,you have to enter it as comma separated without equal sign

SUM({< DATE = {'$(=MonthEnd(Addmonths(DATE,-1))','MonthEnd(Addmonths(DATE,-2))','MonthEnd(Addmonths(DATE,-3))'} >} Measure)

Note: Check whether your date field is in the format returned by the monthend(which will be as MM/DD/YYYY) function .If it is not in that format for ex it is in DD/MM/YYYY format then use $(=Date(MonthEnd(Addmonths(DATE,-1),'DD/MM/YYYY')

Celambarasan