Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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!