how to find out the number of rows as per the table

[Anonymous]

I have 3 tables that I am loading and I have concatenating these three tables but I need to find out the number of rows in each table separately. Is there a way to find out the number of rows based on the selection of these tables?

[vinieme12]

Settings >> Document Properties >> Tables Tab

[Anonymous]

I need to display the number of rows based on the filter box of the table name

[vinieme12]

See the scrip at the end of this thread

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/TableFunctions/table-f...

//Iterate through the loaded tables For t = 0 to NoOfTables() - 1 //Iterate through the fields of table For f = 1 to NoOfFields(TableName($(t))) Tables: Load TableName($(t)) as Table, TableNumber(TableName($(t))) as TableNo, NoOfRows(TableName($(t))) as TableRows, FieldName($(f),TableName($(t))) as Field, FieldNumber(FieldName($(f),TableName($(t))),TableName($(t))) as FieldNo Autogenerate 1; Next f Next t;

[Anonymous · Accepted solution]

Hi,

Use Rowno() or Recno() function in the table as field and use this field to count no of rows in your table.

Thanks

Paridhi

[Anonymous]

Thanks.. your suggestion worked