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: 
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?

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