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

Announcements
Register by January 31 for $300 off your Qlik Connect pass: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

interno()

I am working on a script that has the following:

Autogenerate 1

while Date($(vStartDate) + (Iterno - 1)) < = Date($(vStartDate))

What is the Iterno() doing?

3 Replies
Not applicable
Author

It is doing a loop: 1, 2, 3 .....

So you can "multiply" your line being read or added to the table

here, you will add as many lines as the days between start and end : but here it is quite strange because start and end are the same

Fabrice

swuehl
Champion III
Champion III

From the Help:


IterNo( )

This function is only meaningful if used together with a while clause, see Load.

IterNo( ) returns an integer indicating for which time one single record is evaluated in a load statement with a while clause. The first iteration has number 1.

james_butler
Contributor III
Contributor III

Hi

 

IterNo() is adding on to your start date.

I think of it as creating the dates in between a start and end date.

See this example 

https://help.qlik.com/enS/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Coun...

Regards

James