Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

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??

Tags (1)
1 Reply

Re: The number of rows in a particular column of Qlikview

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

Community Browser