Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

rowno() and recno()

Hi,

Please explain...

rowno() and recno()


1 Solution

Accepted Solutions
chauhans85
Esteemed Contributor

Re: rowno() and recno()

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 Replies
chauhans85
Esteemed Contributor

Re: rowno() and recno()

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

Not applicable

Re: rowno() and recno()

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
Contributor

Re: rowno() and recno()

HI ,

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

RowNo( )  returns current row no of value

Community Browser