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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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