Universal Calendar

[ankit777]

How can I create a universal calendar for 100 years in Qlik view document?

[Siva_Sankar]

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

[tresesco]

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) ;

[ankit777]

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.

[ankit777]

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.

[tresesco · Accepted 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) ;

[ankit777]

Fine. Thankyou.