Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Title expression: Concatenate string and aggregate function result together?

I have a bar chart where I'd like to set the title to a string expression that concatenates a string with the number of rows that have a certain field; e.g., "States (50 total)" assuming I have a table with 50 rows that each have a "State" field.

I have tried a number of variations of the following, to no avail:

     concat('States (', count(State), ') total')

The expression syntax checker says OK, but nothing appears in the title when I close the expression editor.

How do I handle this simple concatenation in Qlik Sense?

Thanks

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try the concatenation operator &

='States (' & count(State) & ' total)'

View solution in original post

2 Replies
swuehl
MVP
MVP

Try the concatenation operator &

='States (' & count(State) & ' total)'

Not applicable
Author

Perfect. Thanks