topic Re: Count each table rows in QlikView

Count each table rows

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

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

how can i do this?

Thanks

Sony

Re: Count each table rows

sunny_talwar — Thu, 02 Aug 2018 18:19:31 GMT

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...

Re: Count each table rows

soniasweety — Thu, 02 Aug 2018 18:23:00 GMT

but what is =Numofrows function gives?

and how to use that?

Re: Count each table rows

sunny_talwar — Thu, 02 Aug 2018 18:24:59 GMT

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/InterRecordFunctions/noofrows.htm

Re: Count each table rows

soniasweety — Thu, 02 Aug 2018 18:30:22 GMT

im thinking about this

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/TableFunctions/NoOfRows.htm

Re: Count each table rows

sunny_talwar — Thu, 02 Aug 2018 18:32:27 GMT

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

Re: Count each table rows

soniasweety — Thu, 02 Aug 2018 18:35:10 GMT

Okay thanks sunny

can i use this in text object like this?

=$(NoOfrows) ? is this correct?

Re: Count each table rows

sunny_talwar — Thu, 02 Aug 2018 18:37:16 GMT

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

Re: Count each table rows

soniasweety — Thu, 02 Aug 2018 18:39:02 GMT

thanks worked