topic Re: Same week last year in QlikView

Same week last year

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I've got two variables in a load script

Let vWeekStart = WeekStart(today())

Let vWeekEnd = WeekEnd(today())

What I would like to do is create the same variables for the same week last year

Can this be done?

Thanks
Mel

Re: Same week last year

tomasz_tru — Wed, 02 Aug 2017 14:01:47 GMT

Week numer can be tricky, first you have to decide what kind of week number you want - to make sure you have everything under control: Redefining the Week Numbers

Tomasz

Re: Same week last year

jmvilaplanap — Wed, 02 Aug 2017 14:06:16 GMT

Hi,

Could you try:

LET vWeekStartPrevYear = weekstart(addyears(today(), -1)

LET vWeekEndPrevYear = weekend(addyears(today(), -1)

Regards