Master calendar

[vireshkolagimat]

Hi All,

Can somebody please help to understand the below script.

LOAD DISTINCT

Date($(vStartDate) + IterNo() - 1)   as StockDate

AUTOGENERATE (1)

WHILE $(vStartDate) + IterNo() - 1 <= $(vEndDate);

What is the use of IterNo() and AUTOGENERATE (1). I also read that IterNo() can be used with only while loop, if so why?

Can i give some other number in autogenerate function? If not, why?

thank you.

Regards,

Viresh

[Anil_Babu_Samineni]

Number of threads are opened related this same question, Just gone thru those and ask

[vireshkolagimat]

ok i will check.

[its_anandrjs]

You can learn this from the Qlik Community

Some are here

Iterno() working with while‌

Best explain by HIC

Calendars

Regards

Anand