topic Re: rowno() and recno() in QlikView

rowno() and recno()

Sat, 23 Feb 2013 14:39:53 GMT

Hi,

Please explain...

rowno() and recno()

Re: rowno() and recno()

SunilChauhan — Sat, 23 Feb 2013 14:51:13 GMT

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

Re: rowno() and recno()

Sat, 23 Feb 2013 14:52:39 GMT

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.

Re: rowno() and recno()

yadav_anil782 — Fri, 11 Sep 2015 11:01:28 GMT

HI ,

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

RowNo( ) returns current row no of value

Re: rowno() and recno()

ebahadur — Tue, 02 Apr 2019 22:12:37 GMT

thank you for the simplest answer.