Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Number of threads are opened related this same question, Just gone thru those and ask
ok i will check.
You can learn this from the Qlik Community
Some are here
Best explain by HIC
Regards
Anand