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

    Calculated Title in the Charts - Qlik Sense

    Lokesh Patel

      Hi,

       

      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.