master cal explination?

Mon, 07 Jul 2014 09:55:27 GMT

TempCalendar:

Load

date($(varMinDate) + rowno() – 1) As TempDate

Autogenerate

$(varMaxDate) – $(varMinDate) + 1;

pls explain me above four lines how it works?

Re: master cal explination?

avinashelite — Mon, 07 Jul 2014 10:33:18 GMT

Hi Manoj,

Please find the explanation below:

date($(varMinDate) + rowno() – 1) As TempDate> varMindate is a variable which defines the start date of your master calender. rowno() is used to create unique number in order to create unique date.

2.Autogenerate > is a function use to generate records, you can define the step or size on this.

3.$(varMaxDate) – $(varMinDate) + 1> this line specif the number of records need to be created using autogenerate function here eg varMaxdate=7/7/2014 ans varMindate=1/7/2014

$(varMaxDate) – $(varMinDate) + 1= 7 which will create 7 records.

Hope this helps you!!!

Regards,

@vi

topic master cal explination? in QlikView

master cal explination?

Re: master cal explination?