topic Function Addweeks() ??? in QlikView

Function Addweeks() ???

Mon, 25 May 2009 13:10:32 GMT

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

Function Addweeks() ???

Mon, 25 May 2009 15:33:41 GMT

Hi Stefan,

Try this :

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

Function Addweeks() ???

Anonymous — Mon, 25 May 2009 21:46:05 GMT

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

Re: Function Addweeks() ???

Sun, 16 Mar 2014 17:10:41 GMT

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

Re: Function Addweeks() ???

DeanoC — Thu, 03 Aug 2023 08:27:59 GMT

Hi There.

The solution is to employ the 'AddMonths' Function(AddMonths(startdate, n , [ , mode])) in your specific case.

I.e. You are trying this... >> addweeks(DATE, -52)

Rather try this... >> AddMonths(DATE, -12)

Kind regards.