# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Tags (3)
1 Solution

Accepted Solutions
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
Contributor III

## Re: Expression Help! Percentage of subtotal against Total

Please share your data or app.

Thank you!

Honored Contributor III

## Re: Expression Help! Percentage of subtotal against Total

If your Dimension is Merchants then, may be -

Count(CSContacts)/Count(Total CSContacts)

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

New Contributor II

## Re: Expression Help! Percentage of subtotal against Total

Thank you That's perfect