Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

master cal explination?

TempCalendar:

Load

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

Autogenerate

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




pls explain me above four lines how it works?

1 Reply
avinashelite

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