Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to find out how many rows available in a table box(Including the blank fields if any)

Hi Can any body help in this?

regards,

rajesh

1 Solution

Accepted Solutions
manideep78
Partner - Specialist
Partner - Specialist

Add one more column with RowNo() as RecCount

Hope this helps

View solution in original post

9 Replies
manideep78
Partner - Specialist
Partner - Specialist

Add one more column with RowNo() as RecCount

Hope this helps

ngulliver
Partner - Specialist III
Partner - Specialist III

You can always add a count into your load script e.g.

1 as RowCount

and then display the count in the Title of the table e.g

='Details (' & num(sum(RowCount), '#,##0') & ' rows)'

By doing this in the load script you can use the same display in many objects in your document.

Regards,

Neil

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Use a macro to set a variable whenever selections change. You can use this variable anywhere you want. An example of a macro like this can be found in the start of discussion http://community.qlik.com/message/415137#415137. Trigger the macro by attaching it to a document trigger.  See Settings-Document properties-Triggers.

Best,

Peter

Peter_Cammaert
Partner - Champion III
Partner - Champion III

BTW the macro trick also works with objects that eliminate doubles, like a table box.

Peter

Not applicable
Author

hi

try this fuction.

NoOfRows(['TableName ' ])

Returns the number of rows (records) in a previously loaded table. If the function is used within a load statement, it must not reference the table currently being loaded.

Examples:

LET a = NoOfRows('tab1');

Load * from abc.csv where NoOfRows( )<30;

Not applicable
Author

Hi

find the image 6052*2 means 6052 rows and 2 columns

hope it will helps you

Untitled.png

Not applicable
Author

Hi Manideep,

Thanks, it is working.

regards,

rajesh

Not applicable
Author

Hi all,

Thanks for replies.

regards,

rajesh

manideep78
Partner - Specialist
Partner - Specialist

Close this by marking it as correct if you got the correct ans. so that others wont try on the same question