rowno() and recno()

[#1]

Hi,

Please explain...

rowno() and recno()

[SunilChauhan · Accepted solution]

Pasted from help

RecNo( )

Returns an integer for the number of the currently read row of the internal table. The first record is number 1.

RowNo( )

Returns an integer for the position of the current row in the resulting QlikView internal table. In contrast to RecNo( ), which counts the records in the raw data table, the RowNo( ) function does not count records that are excluded by where clauses and is not reset when a raw data table is Concatenation to another. The first row is number 1.

Examples:

Raw data tables:

Tab1.csv
A	B
1	aa
2	cc
3	ee

Tab2.csv
A	B
5	xx
4	yy
6	zz

QVTab:

Load *, RecNo( ), RowNo( ) from Tab1.csv where A<>2;

Load *, RecNo( ), RowNo( ) from Tab2.csv where A<>5;

The resulting QlikView internal table:

QVTab
A	B	RecNo( )	RowNo( )
1	aa	1	1
3	ee	3	2
4	yy	2	3
6	zz	3	4

hope this helps

[#3]

When used in your load script, when loading a table, RecNo() predictably returns the integer sequential row number of the input table... your source table of the load.  This counter gets reset every time you do a Load.  In contrast, RowNo() returns the position of the row in the table after the load.  So RowNo() is a sequential counter number for the rows in the table after it is loaded, 1, 2, 3, ...n.

RowNo() is also a Chart function, so you can use it in an expression to return the sequential row number (starts at 1) for the current veritical dimension.  Or use RowNo(total) to get the overall sequential number.

[yadav_anil782]

HI ,

simply RecNo( ) shows actual  row no  of value in records

RowNo( )  returns current row no of value

[ebahadur]

thank you for the simplest answer.