topic Re: Master Calendar Help. in QlikView

Master Calendar Help.

Wed, 02 Sep 2015 08:57:34 GMT

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:

instead of

Re: Master Calendar Help.

MarcoWedel — Wed, 02 Sep 2015 22:28:51 GMT

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

Re: Master Calendar Help.

MarcoWedel — Wed, 02 Sep 2015 22:31:56 GMT

or additionally load all months in a subsequent load like

LOAD Month(Date#(RecNo(),'M')) as Month
Autogenerate 12;

hope this helps

regards

Marco