topic Can anyone explain IterNo() in Current script? in QlikView

Can anyone explain IterNo() in Current script?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Tempcalendar:

Load

$(Vmindate)+Iterno()-1 as Num,

Date($(VminDate)+Iterno()-1) as TempDate

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

lironbaram — Sun, 08 Jan 2017 06:19:03 GMT

the script creates a list of dates between the

two variables Vmindate and vMaxDate

iterno() is the number of the current iteration starting from 1

this function is used together with while statement

satheshreddy — Sun, 08 Jan 2017 11:02:00 GMT

Hi Pandu,

Iterno() as like rwono() its provide a no for rows.

the above script its crate a number and adding to date.

Regards

Sathish

Anonymous — Thu, 12 Jan 2017 06:21:31 GMT

Thank you Liron,

for ex: Date+iterno() as date means it takes mm:dd:yy format to number formate right?

As you said it returns the serial number or date in numbers?

How does it work in real time, which scenario we use?

Regards

Pavan

lironbaram — Thu, 12 Jan 2017 06:41:56 GMT

iterno() is giving back the current iteration number

in a do while loop ;

so you can use it to create a sequence of values between to values

see help on function