Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Function Addweeks() ???

Hi,

I need to get the corresponding day 52 weeks ago, so if I have a Tuesday I need to get the corresponding Tuesday 52 weeks ago ...

Since there is no method addweeks(DATE, -52), how is the best way to solve this issue?

Best regards
& thanks in advance

Stefan WALTHER

3 Replies
Not applicable

Hi Stefan,

Try this :

Date(YourDate - (52*7)) as SameDayLastYear

mov
Champion III
Champion III

Obviously there is no need for AddWeek function because a week is always exactly 7 days...

Not applicable

you can also add Day# in Year to your master calendar, obviously this will vary on leap years but works great.  I also add Business Day# in Year and you can even exclude business holidays