topic Re: Number of Rows In Title in QlikView

Number of Rows In Title

Mon, 26 Jan 2026 18:19:17 GMT

Hello,

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

Thx!@

Re: Number of Rows In Title

tresB — Wed, 07 Oct 2015 11:30:10 GMT

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

Re: Number of Rows In Title

Wed, 07 Oct 2015 11:53:18 GMT

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

E.g.

Total amount of numbers: 9

Re: Number of Rows In Title

Anonymous — Wed, 07 Oct 2015 11:56:34 GMT

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

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