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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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.