date of last year same day - Qlik Community

Anonymous · ‎2016-03-01

Hi all ,

I am calculating MTD for current year month to Date and MTD for last year .

i have calculated MTD for current year and it is working good ,.

But i am facing problem for MTD for last year .

For Eg:

I am calculating mtd for feb 20 ,2016 and it is Saturday.

Now i want to calculate MTD for last year i.e 2015 feb 21 and it is saturday .i want to calculte mtd based on day but not on date .20th feb 2015 is friday ,but i want to calculate mtd based on Day .

Any help is really appreciated .

Thanks

marcus_sommer · ‎2016-03-01

Date - 364 is the same weekday as Date.

- Marcus

Anonymous · ‎2016-03-01

did you check this?

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

Anonymous · ‎2016-03-03

Thanks marcus !

Seems to be working .

waiting for more solutions .