Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The number of Rows x Columns of the currently active object is shown in the status bar all the way to the right.
Hi,
Check with this
=NoOfRows('TableName')
The number of Rows x Columns of the currently active object is shown in the status bar all the way to the right.
@ 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