Expression Help! Percentage of subtotal against Total

[alextomlins]

HI Guys,

I've always struggled on how to get a percentage of something that is already split as a dimension  in Qlik Sense.

for example i have cs contacts split by different merchants as my dimension but would like to see the Percentage of the merchant split contacts out of the total contacts. So far i have;

Count(CSContacts) / Count({<[MerchantName]=>}CSContacts)

I very much feel like i am miles off here and that the answer is really simple. I'm sure someone has asked this but i couldn't find it.

Please help

Thanks,

Alex

[isingh30]

Please share your data or app.

Thank you!

[Digvijay_Singh · Accepted solution]

If your Dimension is Merchants then, may be -

Count(CSContacts)/Count(Total CSContacts)

[alextomlins]

I can't share the data i'm afraid sorry as it has personal information in every row. What is the normal procedure and i will try to follow that ?

The data is split by CS Contact time, Merchant Name, Phone number. Every row is a call into our CS call center. It is a very simple app as i have only started development on it. It is linked with a master calendar but this shouldn't come into play for this expression?

Thanks,

Alex

[alextomlins]

Thank you That's perfect