topic Row count in table object in QlikView

Row count in table object

Mon, 02 Apr 2012 13:03:48 GMT

Hello,

I have imported data from excel sheet in a "Table Object" in Qlikview. If I search for a specific "Order Number" from "Order Number" field, I get around 72 rows displayed as my result, which I counted manually.

Is there any tab or any other way to count the display Row Count in QV like we have in Excel?

Thanks in advance!

Mandy

Row count in table object

CELAMBARASAN — Mon, 02 Apr 2012 13:09:35 GMT

Hi,

Check with this
=NoOfRows('TableName')

Row count in table object

kji — Mon, 02 Apr 2012 13:16:02 GMT

The number of Rows x Columns of the currently active object is shown in the status bar all the way to the right.

Row count in table object

Mon, 02 Apr 2012 16:01:06 GMT

@ Johan

Thanks a ton! I could see no. of rows x columns in the status bar...wow! I didnt realiize that earlier Appreciate that!

@ Celambarasan

Thanks for your reply. I really appreciate that. I am very new to QV so do not know where to apply the formula you mentioned.

Mandy