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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
surajap123
Creator III
Creator III

Autogenerate with/without while

Hi,

I have difficulty understanding the below 2 different piece of code. Could anyone help me to understand it.

When I should use each one of them?

What the 'while' and 'iterNo' does in the second statement?

1)  AUTOGENERATE  $(vMaxDate) - $(vMinDate) + 1;

2)  AutoGenerate 1 While $(vMinDate) + IterNo() -1 <= $(vMaxDate);

Regards,

Suraj

1 Reply
Not applicable

while is a clause used for stating whether a record should be repeatedly read. The same record is read as long as criterion is true. In order to be useful, a while clause must typically include the IterNo( ) function.

criterion is a logical expression.