topic Re: date of last year same day in QlikView

date of last year same day

Anonymous — Tue, 01 Mar 2016 12:30:16 GMT

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

Re: date of last year same day

marcus_sommer — Tue, 01 Mar 2016 12:35:20 GMT

Date - 364 is the same weekday as Date.

- Marcus

Re: date of last year same day

Anonymous — Tue, 01 Mar 2016 13:08:29 GMT

did you check this?

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

Re: date of last year same day

Anonymous — Thu, 03 Mar 2016 09:50:42 GMT

Thanks marcus !

Seems to be working .

waiting for more solutions .