Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
schmidtkm37
Contributor III
Contributor III

Bar Chart % of Total

Hello,

I am trying to get a bar chart that shows each sub category as a % of the sales of the entire category. For example, if we have subcategory A, B and C and they have sales of $2, $3 and $5 (total of $10), I would want a bar chart with A, B and C showing values 20%, 30% and 50%. 

So I need a calculation that allows me to do sum(sales) / sum(sales for entire category)

Anybody know if this is possible? Your help is greatly appreciated.

Thank you,

Kevin

1 Solution

Accepted Solutions
krishna_2644
Specialist III
Specialist III

Try (Sum(Sales)/Sum(TOTAL Sales))

1572974.PNG

View solution in original post

2 Replies
krishna_2644
Specialist III
Specialist III

Try (Sum(Sales)/Sum(TOTAL Sales))

1572974.PNG

schmidtkm37
Contributor III
Contributor III
Author

Thanks!