Calculated Title in the Charts - Qlik Sense

[#1]

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.

[sunny_talwar]

May be like this:

='Total Sales by ' &count(Distinct(RepName)) & If(Count(DISTINCT RepName) = 1, ' Sales Rep', ' Sales Reps')

or just this may be

='Total Sales by ' &count(Distinct(RepName)) &' Sales Rep/s'

[sunny_talwar · Accepted solution]

Or even this

='Total Sales by ' & count(Distinct(RepName)) & 'Sales Rep' & If(Count(DISTINCT RepName) = 1, '' , 's')

[#4]

Thank you once again