Link Master Calendar to Month

Sat, 20 Jul 2013 15:32:41 GMT

I have a small table, with and aggreagated data loaded from an excel.

I have a month column and the in the format MM.YYYY ( 11.2012) format.

I would like to laod a master calender and link this month field to the master calender. i dont have any dates.

How can i get this?

I tried to copy some master calendar codes in my script. and it is not working.

help me with an example.

------

The code in the scipt is as below:

LOAD FieldA,

[Created Month],

[Field B],

FieldC,

[Field D],

[Count 1],

Count2

FROM

[C:File path.. \Filename.xls}

(ooxml, embedded labels);

---------

Re: Link Master Calendar to Month

Gysbert_Wassenaar — Sat, 20 Jul 2013 16:48:02 GMT

Make a date from the Created Month field:

date(date#([Created Month],'MM.YYYY'),'MM.YYYY') as [Created Month]

Now Created Month will contain dates (the first day of each month) and will still be displayed as MM.YYYY. You can now create a master calendar using Created Month as date field. It's easiest to do this with the Qlikview Components library. See this discussion for more information.

topic Re: Link Master Calendar to Month in QlikView

Link Master Calendar to Month

Re: Link Master Calendar to Month