Announcements
[WEBINAR] Accenture & Qlik: Accelerating BI Migration to SaaS with Qlik on Dec 13th: REGISTER
cancel
Showing results for
Did you mean:
Not applicable

## IterNo(),RecNo(),RowNo()

HI,

when we use IterNo()..?

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

@Sub2u

1 Solution

Accepted Solutions
Former Employee

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

4 Replies
MVP

here

RecNo or RowNo?

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

Master III

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.

Former Employee

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

Not applicable
Author

-  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

Community Browser