topic Re: Master calendar in QlikView

Master calendar

vireshkolagimat — Tue, 22 Aug 2017 07:02:52 GMT

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 — Tue, 22 Aug 2017 07:04:39 GMT

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

vireshkolagimat — Tue, 22 Aug 2017 07:07:39 GMT

ok i will check.

its_anandrjs — Tue, 22 Aug 2017 07:11:46 GMT

You can learn this from the Qlik Community

Some are here

Best explain by HIC

Regards

Anand