Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

The number of rows in a particular column of Qlikview

What is  The number of rows in a particular column of Qlikview and How does it work??

1 Reply
its_anandrjs

Hi,

As i am understand your question Row of particular column means how many rows loaded in the current field that is by function we get also Rowno(). If you use this in any load statement as well as. Let assume this example

LOAD *,RowNo() as Rid;

LOAD * Inline

[

Field1,Field2,Field3

A,8562,983

B,,258

B,267,523

C,462,

D,369,136

];

And if you plot this fields in any table box

Rid.png

And if you use the system fields in the qlikview and plot that fields in any table box

sysfields.png

Hope this helps

Regards

Anand