Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Master Calendar Help.

Hi all,

For the master calendar, I am taking the minimum and maximum date date from my data and creating it. But now I want that irrespective of data, all the months and dates should be shown and there is no data then it should be grayed out.

For Example :

I have data from Jan 2015 to July 2015. Then all the months i.e. Jan to Dec should be shown with Aug, Sep, Oct, Nov and Dec greyed out like below:

Month Calendar.PNG

instead of

Month_July.PNG

1 Solution

Accepted Solutions
MarcoWedel

don't use

Min(Date) and Max(Date)

but something like

YearStart(Min(Date)) and YearEnd(Max(Date))

as limits in your calendar script.

regards

Marco

View solution in original post

2 Replies
MarcoWedel

don't use

Min(Date) and Max(Date)

but something like

YearStart(Min(Date)) and YearEnd(Max(Date))

as limits in your calendar script.

regards

Marco

MarcoWedel

or additionally load all months in a subsequent load like

LOAD Month(Date#(RecNo(),'M')) as Month

Autogenerate 12;

hope this helps

regards

Marco