Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

IterNo(),RecNo(),RowNo()

HI,

when we use IterNo()..?

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

@Sub2u

Tags (3)
1 Solution

Accepted Solutions

Re: IterNo(),RecNo(),RowNo()

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

View solution in original post

4 Replies
MVP
MVP

Re: IterNo(),RecNo(),RowNo()

here

RecNo or RowNo?

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

Re: IterNo(),RecNo(),RowNo()

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.

Re: IterNo(),RecNo(),RowNo()

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

View solution in original post

Not applicable

Re: IterNo(),RecNo(),RowNo()

-  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