Discussion board where members can get started with QlikView.
I would like to use something that do the same thing as dateadd(sql) but in the load
dateadd() as help,
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.
i use something like this:
for week =1 to 54
how would be?
Date(week(Today()) + 1 ) AS Date?
It should be very similar to my example above
Weeks:LOAD Date(WeekStart(Today()) + (7 * RecNo())) AS WeekAUTOGENERATE 54;
LOAD Date(WeekStart(Today()) + (7 * RecNo())) AS Week
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.