topic Re: Universal Calendar in QlikView

Universal Calendar

ankit777 — Fri, 03 Jan 2014 09:27:39 GMT

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

Siva_Sankar — Fri, 03 Jan 2014 09:34:30 GMT

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

Regards.

Siva

tresB — Fri, 03 Jan 2014 09:35:15 GMT

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 — Fri, 03 Jan 2014 09:43:09 GMT

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 — Fri, 03 Jan 2014 09:45:24 GMT

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.

tresB — Fri, 03 Jan 2014 09:45:56 GMT

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 — Fri, 03 Jan 2014 09:55:22 GMT

Fine. Thankyou.