Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

rowno() and recno()

Hi,

Please explain...

rowno() and recno()


1 Solution

Accepted Solutions
TigerisBack
Champion
Champion

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

View solution in original post

4 Replies
TigerisBack
Champion
Champion

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

View solution in original post

Not applicable
Author

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
Creator II
Creator II

HI ,

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

RowNo( )  returns current row no of value

ebahadur
Contributor II
Contributor II

thank you for the simplest answer.