Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
soniasweety
Valued Contributor III

Count each table rows

Hi all,

i want to know  the  each table distinct  count of rows   in text object  

how can i do this?

Thanks

Sony

Tags (2)
1 Solution

Accepted Solutions

Re: Count each table rows

This is a script function which can be used to create a variable to store the row count of each table and then displayed in the text box object on the front end

LET vNoOfRowsTable1 = NoOfRows('Table1');

and then display this in the text box object

View solution in original post

8 Replies

Re: Count each table rows

May be do a distinct count of the unique identifier from each table... make sure that this field is not a key field which connects two tables...

soniasweety
Valued Contributor III

Re: Count each table rows

but  what is  =Numofrows  function gives?

and how to use that?

Re: Count each table rows

I believe it gives the number of rows in a particular chart when used on the front end... read here

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/InterRecordFuncti...

soniasweety
Valued Contributor III

Re: Count each table rows

Re: Count each table rows

This is a script function which can be used to create a variable to store the row count of each table and then displayed in the text box object on the front end

LET vNoOfRowsTable1 = NoOfRows('Table1');

and then display this in the text box object

View solution in original post

soniasweety
Valued Contributor III

Re: Count each table rows

Okay thanks sunny

can  i use this in text object like this?

=$(NoOfrows)    ?  is this correct?

Re: Count each table rows

Well depending on your variable... you can do this vNoOfRowsTable1 or $(vNoOfRowsTable1)... one of the two should work....

soniasweety
Valued Contributor III

Re: Count each table rows

thanks worked