Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alextomlins
Contributor III
Contributor III

Expression Help! Percentage of subtotal against Total

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

1 Solution

Accepted Solutions
Digvijay_Singh

If your Dimension is Merchants then, may be -

Count(CSContacts)/Count(Total CSContacts)

View solution in original post

4 Replies
isingh30
Specialist
Specialist

Please share your data or app.

Thank you!

Digvijay_Singh

If your Dimension is Merchants then, may be -

Count(CSContacts)/Count(Total CSContacts)

alextomlins
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

Thank you That's perfect