Early Access: The content on this website is provided for informational purposes only in connection with pre-General Availability Qlik Products. All content is subject to change and is provided without warranty.
This script function 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. The IterNo function is only meaningful if used together with a while clause.
Syntax:
IterNo( )
Example:
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!
