Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alextomlins
New Contributor II

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

Re: Expression Help! Percentage of subtotal against Total

If your Dimension is Merchants then, may be -

Count(CSContacts)/Count(Total CSContacts)

4 Replies
isingh30
Contributor III

Re: Expression Help! Percentage of subtotal against Total

Please share your data or app.

Thank you!

Digvijay_Singh
Honored Contributor III

Re: Expression Help! Percentage of subtotal against Total

If your Dimension is Merchants then, may be -

Count(CSContacts)/Count(Total CSContacts)

alextomlins
New Contributor II

Re: Expression Help! Percentage of subtotal against Total

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
New Contributor II

Re: Expression Help! Percentage of subtotal against Total

Thank you That's perfect