Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: Master Calendar Help.

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

2 Replies
MarcoWedel
Not applicable

Re: Master Calendar Help.

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
Not applicable

Re: Master Calendar Help.

or additionally load all months in a subsequent load like

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

Autogenerate 12;

hope this helps

regards

Marco