topic Re: Table Box Row Count in Text Box in QlikView

Table Box Row Count in Text Box

Thu, 19 Jun 2014 17:22:59 GMT

Howdy -

Done some searching already and I can't seem to find a straight answer to this question. How can I display the number of rows returned within a table box (Object ID: TB04 in my sheet)? I'd like to put this number in a text box so that in my UI I can show "Number of Rows in your Selection: _________." Essentially, I'd like exactly the same number that is shown in the status bar. Thanks!

Re: Table Box Row Count in Text Box

joshabbott — Thu, 19 Jun 2014 17:26:09 GMT

Do you have a unique key in your table data? If so, this should be something like:

=count(Distinct UniqueColumnName)

Re: Table Box Row Count in Text Box

Thu, 19 Jun 2014 17:28:11 GMT

As of right now, no - no Unique ID.

Re: Table Box Row Count in Text Box

joshabbott — Thu, 19 Jun 2014 17:30:33 GMT

You could then concatenate the fields in your table box together is one way I could think:

=Count(Distinct col1 & '|' & col2 & '|' & col3) ...etc

Re: Table Box Row Count in Text Box

Thu, 19 Jun 2014 17:58:24 GMT

That seems to have worked! Thanks!