topic Re: Rownum,Rowid in QlikView

Rownum,Rowid

qlikview979 — Wed, 22 Apr 2015 15:07:19 GMT

Hi experts,

What is the difference between rownum & rowid ?

Re: Rownum,Rowid

awhitfield — Wed, 22 Apr 2015 15:14:23 GMT

Do you mean RowNo() and RecNo()?

RecNo( )

Returns an integer for the number of the currently read row of the source data 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 concatenated to another. The first

row is number 1.

Andy

Re: Rownum,Rowid

MK_QSL — Wed, 22 Apr 2015 15:14:59 GMT

Is there any function RowID() in QlikView?

Re: Rownum,Rowid

marcus_malinow — Wed, 22 Apr 2015 15:23:02 GMT

RecNo or RowNo?‌

Re: Rownum,Rowid

Anonymous — Wed, 22 Apr 2015 15:35:04 GMT

RowNo( ),Returns an integer for the position of the current row in the resulting QlikView internal table. RecNo () , which counts the records in the table of pure data, RowNo () function does not count records excluded by clause where and is not reset when a pure table Concatenation with another.

Re: Rownum,Rowid

anbu1984 — Wed, 22 Apr 2015 16:16:42 GMT

Rownum and Rowid are present in Oracle

http://www.dba-oracle.com/t_rownum_rowid_difference.htm/