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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Can anyone explain IterNo() in Current script?

Tempcalendar:

Load

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

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

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

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi

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

IterNo ‒ QlikView

View solution in original post

4 Replies
lironbaram
Partner - Master III
Partner - Master III

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
Creator III
Creator III

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
Not applicable
Author

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
Partner - Master III
Partner - Master III

hi

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

IterNo ‒ QlikView