Skip to main content
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