IterNo(),RecNo(),RowNo()

[#1]

HI,

when we use IterNo()..?

Diff for Recno(), RowNo()...i hope both r same...wts d diff?

@Sub2u

[maxgro]

here

RecNo or RowNo?

if you try the search function, upper right, ......

[robert_mika]

From Qlikview 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.

[hic · Accepted solution]

RecNo() is the record number of the input to the Load statement.

RowNo() is the record number of the output of the Load statement.

See more on Counters in the Load

On IterNo(): Just as Robert says - it is only meaningful together with a While clause. See the example on Creating Reference Dates for Intervals

HIC

[#5]

-  RecNo() function returns an integer for the position of the current row in the resulting qlikview table.

- RowNo() function counts the record in the row data table. It doesn't count the records that are included by where clauses and it isn't reset when a row data table is concatenate to another.The first row is number 1.

Let's see example below:

     I have two table, table_A and table_B.

          Table_A                                                Table_B

Num           Letter                                    Num          Letter

1                    bb                                        4               Bee

2                    lyk                                        5               Ah

3                    honi                                     6               Berry

Script:

     Load * , RecNo(), RowNo()  from  table_A where Num <>3;

     Load * , RecNo(), RowNo()  from table_B where Num <>5;

Result:

Num          Letter         RecNo()          RowNo()

1                    bb               1                    1

2                    lyk               2                    2

4                    Bee            4                    3

6                    Berry          6                    4