Discussion Board for collaboration on QlikView Scripting.
How can I create a universal calendar for 100 years in Qlik view document?
Go to Solution.
Sorry, my mistake. Try the corrected (added num()) one below.
Let vStart=Num( MakeDate(Year(Today())-100, 1,1));
Let vEnd=Num( MakeDate(Year(Today()), 12,1));
Load Date, Month(Date) as Month, Year(Date) as Year;
Load Date($(vStart) + RecNo()) as Date autogenerate $(vEnd) - $(vStart) ;
here is the link for creating calendar
set yourself the start date and end date for 100 years in the variable, like below
LET Start = num(makedate(2000,1,1));
LET End = num(makedate(2100,12,1));
Let vStart= MakeDate(Year(Today())-100, 1,1);
Let vEnd= MakeDate(Year(Today()), 12,1);
The code that you have shared is not working properly for me. It just creates a calendar of 1905 from March to July.
The code that you have shared makes a calendar for the year 2005-2007 Sept, though I have made the end date as 01/12/2100.