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

[#1]

Hi Can any body help in this?

regards,

rajesh

[manideep78 · Accepted solution]

Add one more column with RowNo() as RecCount

Hope this helps

[ngulliver]

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]

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]

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

Peter

[#6]

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;

[#7]

Hi

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

hope it will helps you

[#8]

Hi Manideep,

Thanks, it is working.

regards,

rajesh

[#9]

Hi all,

Thanks for replies.

regards,

rajesh

[manideep78]

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