topic Iterno in QlikView

Iterno

Tue, 08 Apr 2014 17:43:20 GMT

hi can any body explain iterno() function with simple example

Re: Iterno

swuehl — Tue, 08 Apr 2014 17:53:24 GMT

Maybe

LOAD

Iterno() as RowNumber

autogenerate 1 While iterno() <=10;

From the HELP:

IterNo( )

This function is only meaningful if used together with a while clause, see Load. IterNo( ) 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.

You can search the forum for iterno(), there are plenty of threads that use this function.

Re: Iterno

jaimeaguilar — Tue, 08 Apr 2014 17:58:07 GMT

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;

regards