topic Re: YTD LYTD in QlikView

YTD LYTD

rajni_batra — Thu, 19 Apr 2012 09:27:43 GMT

i have a query need to show YTD IN ONE COLOUMN N IN OTHER COLOUMN NEED TO SHOW DATA OF LAST MONTH OF PREVIOUS YEAR.

HOW CAN I GET THIS?????

Thu, 19 Apr 2012 09:47:07 GMT

Hi Rajni,

you can use Sum({$<year={$(=only(year))}>}sales)

this will give u ytd

for last month try this one

Sum({$<year={$(=only(year)-1)},month={$(=max(month)>}sales)... this will work if you click on any year in list box

perumal_41 — Thu, 19 Apr 2012 11:06:02 GMT

Sum({$<year={$(=max(year))}>}sales)

Sum({$<year={$(=max(year)-1)},month={$(=max(month)>}sales)

i thing useful for u .

Regards

Perumal A