Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table Box Row Count in Text Box

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!

1 Solution

Accepted Solutions
joshabbott
Creator III
Creator III

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

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

View solution in original post

4 Replies
joshabbott
Creator III
Creator III

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

=count(Distinct UniqueColumnName)

Not applicable
Author

As of right now, no - no Unique ID.

joshabbott
Creator III
Creator III

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

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

View solution in original post

Not applicable
Author

That seems to have worked!  Thanks!