topic Re: need to create master calender from current date in QlikView

need to create master calender from current date

Karim_Khan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I am planning to create the master calendar from today's date which will show me 100 years data.past 50 years and future 50 years.

Can we achieve the same through single data suppose today's date is 02-06-2016.

Now I want to show the data from 1950 to 2049 and in this I will show the least granularity values of date?

Regards,

kush141087‌shubham.kumar‌sureshqv‌ashfaq_haseeb‌@manish kacchia

Re: need to create master calender from current date

Kushal_Chawda — Thu, 02 Jun 2016 11:36:22 GMT

Do you need all the Dates for 100 Years of Data?

Re: need to create master calender from current date

MindaugasBacius — Thu, 02 Jun 2016 11:39:04 GMT

Try using this script:

varMinDate = addyears(Today(), -50) ;
varMaxDate = addyears(Today(), 50);

tmp:
LOAD
  DATE($(varMinDate) + ROWNO() - 1) AS Date
AUTOGENERATE ($(varMaxDate)-$(varMinDate) + 1);

Calendar:
LOAD
  Date
RESIDENT tmp;

DROP TABLE tmp;

Re: need to create master calender from current date

Karim_Khan — Thu, 02 Jun 2016 11:43:39 GMT

Re: need to create master calender from current date

avinashelite — Thu, 02 Jun 2016 11:48:36 GMT

change the min and max date and follow the below post

Creating A Master Calendar