Link Master Calendar to Month

[#1]

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);

---------

[Gysbert_Wassenaar]

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.