Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I create a universal calendar for 100 years in Qlik view document?
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
http://community.qlik.com/docs/DOC-1310
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));
Regards.
Siva
Something like:
Let vStart= MakeDate(Year(Today())-100, 1,1);
Let vEnd= MakeDate(Year(Today()), 12,1);
Load Date, Month(Date) as Month, Year(Date) as Year;
Load Date($(vStart) + RecNo()) as Date autogenerate $(vEnd) - $(vStart) ;
Hey Tresco,
The code that you have shared is not working properly for me. It just creates a calendar of 1905 from March to July.
Hi Siva,
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.
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) ;
Fine. Thankyou.