Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Number of Rows In Title


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


3 Replies

Re: Number of Rows In Title

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:



          RowNo() as RecIdentifierField

From <>;

Not applicable

Re: Number of Rows In Title

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


Total amount of numbers: 9

Re: Number of Rows In Title

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

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

Community Browser