topic Re: What is IterNo() function and when would you use it in real life scenarios? in QlikView

What is IterNo() function and when would you use it in real life scenarios?

jblomqvist — Mon, 15 Aug 2016 13:51:35 GMT

Hi all,

What is IterNo() function and when would you use it in real life scenarios?

I have seen it being used but always wondered what it does. How is it different to RowNo() or something like that?

Re: What is IterNo() function and when would you use it in real life scenarios?

maheshkuttappa — Mon, 15 Aug 2016 13:55:03 GMT

Check this link

IterNo(),RecNo(),RowNo()

Re: What is IterNo() function and when would you use it in real life scenarios?

sunny_talwar — Mon, 15 Aug 2016 13:58:50 GMT

This thread provides one example:

Loops in the Script‌

Re: What is IterNo() function and when would you use it in real life scenarios?

Siva_Sankar — Tue, 16 Aug 2016 02:17:29 GMT

John,

Iterno() only makes sense if used together with while. You can autogenerate rows, for example for creating a calendar, or creating records from another table. A real example would be having a table with mortgages contracts containing only the initial payment. With iterno() / while and some business rules you can generate the complete amortization tables,

an easy example would be:

Example:

Load iterno() as Counter

AutoGenerate 1

While iterno() < 10;

Rowno:

RowNo( )

Returns an integer for the position of the current row in the resulting QlikView internal table. In contrast toRecNo( ), which counts the records in the raw data table, the RowNo( ) function does not count records that are excluded by where clauses and is not reset when a raw data table is Concatenation to another. The first row is number 1.

Examples:

Raw data tables:

Tab1.csv
A	B
1	aa
2	cc
3	ee

Tab2.csv
A	B
5	xx
4	yy
6	zz

QVTab:

Load *, RecNo( ), RowNo( ) from Tab1.csv where A<>2;

Load *, RecNo( ), RowNo( ) from Tab2.csv where A<>5;

The resulting QlikView internal table:

QVTab
A	B	RecNo( )	RowNo( )
1	aa	1	1
3	ee	3	2
4	yy	2	3
6	zz	3	4

Hope it clarifies your doubt.

-Siva