Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Number of Rows In Title

Hello,

How can i display the number of rows affected by the query in the title of a table?

Thx!@

3 Replies
tresesco
MVP
MVP

If you have field that identifies rows uniquely, you can simply use =Count(RecIdentifierField). And if you don't have such a field in db itself, you can create one during load like:

Load

          *,

          RowNo() as RecIdentifierField

From <>;

Not applicable
Author

Thx, but now i want to concatenate text and the count in the titlefield.

E.g.

Total amount of numbers: 9

Anonymous
Not applicable
Author

The title is an expression so following on from tresescomaybe something like this for the expression :

= 'Total amount of numbers: ' & Count(RecIdentifierField)