3 Replies Latest reply: Jan 4, 2017 6:06 PM by Lokesh Patel RSS

    Calculated Title in the Charts - Qlik Sense

    Lokesh Patel



      I have a bar chart that shows total number of Sales by Sales Rep Names


      I want to show total number of sales reps on the title so the users would know exactly how many sales reps are there.

      I am using following expression as the title of that chart


      ='Total Sales by ' &count(Distinct(RepName)) &' Sales Reps'


      What is the best way to write above expression to manage Singular & Plural?


      Example : If there is only 1 Rep selected then the title should say 'Sales Rep' instead of 'Sales Reps'


      Thank you.