Skip to main content

IterNo - script function

This script function returns an integer indicating the current iteration within a while clause. The first iteration has number 1. The IterNo function is only meaningful if used together with a while clause.

Syntax:  

IterNo( )

Examples and results:  

LOAD

   IterNo() as Day,

   Date( StartDate + IterNo() - 1 ) as Date

   While StartDate + IterNo() - 1 <= EndDate;

 

LOAD * INLINE

[StartDate, EndDate

2014-01-22, 2014-01-26

];

 

This LOAD statement will generate one record per date within the range defined by StartDate and EndDate.

In this example, the resulting table will look like this:

Results table

Day

Date
1 2014-01-22
2 2014-01-23
3 2014-01-24
4 2014-01-25
5 2014-01-26

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com