topic row&rec in QlikView

row&rec

satishqlik — Sat, 16 May 2015 18:02:50 GMT

Hello Community,

Where exactly we can use rowno() and recno

what we can make the difference with rowno() and recno()

as am trying below scripts but both are getting same results

temp1:

LOAD Date(Today()+RowNo()) as tempdate1

AutoGenerate 10;

temp2:

LOAD Date(Today()+RecNo()) as tempdate2

AutoGenerate 10;

Below is the attachment for your reference

Kindly look at and suggest !

Thanks in adv!!

Re: row&rec

Peter_Cammaert — Sat, 16 May 2015 18:21:03 GMT

Read the help in QlikView Desktop for each function. It clearly states that one function assigns a number to input rows, and the other to internal table rows (e.g. sort of output rows). Since you do not filter any rows (both tables generate and store exaclty 10 rows in each internal table) you will not notice any difference.

Use a WHERE clause to drop some rows, and you will start to see different results.

Peter

Re: row&rec

Anonymous — Sat, 16 May 2015 18:22:27 GMT

From "help":

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.

Re: row&rec

Agis-Kalogiannis — Mon, 18 May 2015 08:20:56 GMT

The RecNo() refers to your datasource whereas the RowNo() refers to your QlikView dataset.

Re: row&rec

Siva_Sankar — Fri, 03 Jul 2015 01:52:13 GMT

Satish,

Find the attached example with explanations. Where and How to use it.

Re: row&rec

qlikviewwizard — Fri, 03 Jul 2015 02:41:03 GMT

Hi satishqlik ,

Use shankarece advise. It is perfect.

Re: row&rec

Nagaraju_KCS — Fri, 03 Jul 2015 03:54:43 GMT

HI Satish,

Examples:

Raw data:

Tab1
A	B
1	aa
2	cc
3	ee

QVTab:

Load *, RecNo( ), RowNo( ) from Tab1 where A<>2;

The resulting QlikView internal table:

QVTab
A	B	RecNo( )	RowNo( )
1	aa	1	1
3	ee	3	2

Hope it Helps You....

Re: row&rec

jagan — Fri, 03 Jul 2015 04:22:44 GMT

Hi,

You cannot see the difference if you are not doing any filtering or sorting? If you use Sorting/Filtering then you will find the diffference.

Instead of inline try with data from SQL or Excel.

RowNo() - returns the sequence of current loading in a query.

RecNo() - returns the actual row number in the table, even you sort it won't change for the recors..

Regards,

Jagan.

Re: row&rec

prashantbaste — Fri, 03 Jul 2015 04:30:31 GMT

Hi Satish

RecNo() gives results according to input table - i.e. Record Number of particular record in input table.

RowNo() gives results on the basis of output - i.e. Row number of particular record in resulting table.

Hope this will help you to understand difference between both.

Regards,

Prashant P Baste

Re: row&rec

jonathandienst — Fri, 03 Jul 2015 05:16:15 GMT

In a preceding load situation, you cannot use RowNo() in the last load step - it has no result set to reference, so will always return 0. This will not work:

LOAD A + B As C,

rowno,

;

LOAD A, B,

RowNo() As rowno

From ...

And this will:

LOAD A + B As C,

RowNo() As rowno

;

LOAD A, B,

From ....

Re: row&rec

Peter_Cammaert — Fri, 03 Jul 2015 07:41:24 GMT

Talking about chicken and eggs: isn't this the first LOAD step that will produce zeroes?

Re: row&rec

hic — Fri, 03 Jul 2015 07:47:45 GMT

Re: row&rec

satishqlik — Mon, 06 Jul 2015 12:01:42 GMT

Sorry for the delay in reply.Thanks for all ur valuable suggestions.