topic Master Calender issue.... in QlikView

Master Calender issue....

Sat, 21 Dec 2013 05:24:26 GMT

Hi guys,

Please explain me the following code written for creating master calender...

Load

RecNo()-1+Floor(MakeDate(2012)) As TempDate

AutoGenerate(730);

nilesh_gangurde — Sat, 21 Dec 2013 05:35:10 GMT

Hi,

The Record number Function will generate the value like 1,2,3,4,5,6,.........730

now, for 1st Record generation:

((1-1) + 1 jan 2012 ) as TempDate

means your first record will have 1 jan 2012 as TempDate.

then for 2nd record:

((2-1) + 1 jan 2012) as TempDate

here your second record will have 2 jan 2012 as TempDate.

and this is upto 730 records because in autogenerate function you kept the limit for 730.

-Nilesh

Sat, 21 Dec 2013 06:00:54 GMT

Thanks Nilesh....

Regards,

Sachin