topic interno() in QlikView

interno()

Wed, 30 Oct 2013 13:58:08 GMT

I am working on a script that has the following:

Autogenerate 1

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

What is the Iterno() doing?

Re: interno()

Wed, 30 Oct 2013 14:03:12 GMT

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

Re: interno()

swuehl — Wed, 30 Oct 2013 14:03:16 GMT

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.

Re: interno()

james_butler — Wed, 14 Nov 2018 09:37:56 GMT

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/CounterFunctions/IterNo.htm

Regards

James