Not applicable
2015-07-11
10:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
5,508 Views
1 Solution
Accepted Solutions
MVP
2015-07-11
10:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try the concatenation operator &
='States (' & count(State) & ' total)'
2 Replies
MVP
2015-07-11
10:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try the concatenation operator &
='States (' & count(State) & ' total)'
Not applicable
2015-07-11
10:55 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Perfect. Thanks
4,022 Views