topic Re: IterNo(),RecNo(),RowNo() in QlikView

IterNo(),RecNo(),RowNo()

Sun, 25 Jan 2015 19:01:11 GMT

HI,

when we use IterNo()..?

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

@Sub2u

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

maxgro — Sun, 25 Jan 2015 19:09:37 GMT

here

RecNo or RowNo?

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

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

robert_mika — Sun, 25 Jan 2015 19:40:52 GMT

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()

hic — Sun, 25 Jan 2015 20:32:22 GMT

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

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

Sun, 17 May 2015 10:55:00 GMT

- 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