topic Re: difference between recno() and rowno() ? in QlikView

difference between recno() and rowno() ?

Anonymous — Fri, 23 Jan 2015 12:55:36 GMT

Both gives same output like

recno():

rowno():

then what is the use with when i have to use these fun?

Re: difference between recno() and rowno() ?

alexandros17 — Fri, 23 Jan 2015 12:58:12 GMT

These functions do not have any parameters. The parentheses are however still required.

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.

The main difference is :

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.

that in your case do not apply ... so the result is the same

Re: difference between recno() and rowno() ?

hic — Fri, 23 Jan 2015 13:00:21 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

HIC

Re: difference between recno() and rowno() ?

Anonymous — Fri, 23 Jan 2015 13:11:22 GMT

Hi,

Go thru below links:

http://community.qlik.com/docs/DOC-7063

http://community.qlik.com/blogs/qlikviewdesignblog/2014/08/29/recno-or-rowno

Regards

Neetha