topic Previous week last year in QlikView

Previous week last year

NewQlikUser — Wed, 20 Feb 2019 00:31:43 GMT

Hi, Within the master calendar we have created the following expressions: LET vCurWeek = div(WeekEnd(vToday)-YearStart(vToday,0,10),7); LET vPrevWeek = vCurWeek - 1; LET vCurWeekPrevFinYr = div(WeekEnd(AddYears(vToday,-1))-YearStart(AddYears(vToday,-1),0,10),7); vCurWeek & vPrevWeek works fine but the vCurWeekPrevFinYr is giving me the data from last year -1 week(current week start 11/2/19). Instead of giving me the week starting 12/2/18 is giving me data from week 5/2/18 Any ideas of how to fix this issue?

Re: Previous week last year

Shubham_Deshmukh — Wed, 20 Feb 2019 07:05:06 GMT

Please edit your question, it becomes so confusing and time consuming for all to read it and come up with solution. Put it properly,
LET vCurWeek=
LET vPrevWeek=
---
---

Re: Previous week last year

pradosh_thakur — Wed, 20 Feb 2019 09:09:09 GMT

Week starts on monday.

Check the callender 12/2/2018 and 5/2/2018 are mondays. So it's giving correct answer as per your logic.

Re: Previous week last year

Shubham_Deshmukh — Wed, 20 Feb 2019 12:30:26 GMT

Try this,
=date(WeekStart(Week(AddYears(today(),-1)-YearStart(today(),-1,4))),'DD-MM')&'-'&(year(today())-1)