topic Re: SQL DATEADD Equivalent in Load Qlikview in QlikView

SQL DATEADD Equivalent in Load Qlikview

Fri, 20 Nov 2020 18:02:30 GMT

Hello,

I would like to use something that do the same thing as dateadd(sql) but in the load

Load

dateadd() as help,

...

Thanks

Re: SQL DATEADD Equivalent in Load Qlikview

Miguel_Angel_Baeyens — Wed, 12 Sep 2012 13:44:33 GMT

Hi Alejandro,

You can use the AddMonths() or AddYears() function in QlikView, and you can also use the Date() function with an expression as parameter:

Date(Today() - 7 * $(vWeekOffset)) AS Date

Hope that helps.

Miguel

Re: SQL DATEADD Equivalent in Load Qlikview

Wed, 12 Sep 2012 14:33:54 GMT

i use something like this:

for week =1 to 54

DATEADD(week,1,'2010/01/01')

DATEADD(week,2,'2010/01/01')

DATEADD(week,3,'2010/01/01')

'2010/01/01'=Year'/01/01'

how would be?

Date(week(Today()) + 1 ) AS Date?

Re: SQL DATEADD Equivalent in Load Qlikview

Miguel_Angel_Baeyens — Wed, 12 Sep 2012 14:57:29 GMT

Hi Alejandro,

It should be very similar to my example above

Weeks:
LOAD Date(WeekStart(Today()) + (7 * RecNo())) AS Week
AUTOGENERATE 54;

Search the QlikCommunity for "Master Calendar", there are lots of good examples, more simple and more complex. Check this app that builds a master calendar and uses it in expressions.

Hope that helps.

Miguel