2 Replies Latest reply: Jul 11, 2015 10:55 AM by Minnow Noir RSS

    Title expression: Concatenate string and aggregate function result together?

    Minnow Noir

      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?