Hi can anyone tell me how to create master calendar

[#1]

i need a master calendar so that all the dates can be captured in single calendar...

i am new to qlikview need clear code for it

[jagan · Accepted solution]

Hi,

Please find script below

Sales:

LOAD

     Date,

     Sales

FROM Sales;

//Get Minimum date

TempSales:

LOAD

    Min(Date) AS MinDate

RESIDENT Sales;

//Get and store Minimum date

LET vDateMin = FieldValue('MinDate', 1);

LET vTodayNum = Num(Today());

DROP TABLE TempSales;

SalesDates:

LOAD

    ($(vDateMin) + (RecNo()) - 1)  AS Date,

    RecNo() AS DateRecNo   

AUTOGENERATE ($(vTodayNum) - $(vDateMin) + 1);

Hope this helps you.

Regards,

Jagan.