Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Chinnu3
Contributor III
Contributor III

I want to show the Sum as well as percentage on same bar chart

Hi All,

Chinnu3_0-1637674955676.png

I want to show the data total Sum of Dept = 'A','B', 'C' and percentages as well as in same Bar chart.

3 Replies
Or
MVP
MVP

Sum(Sales) and Sum(Sales) / Sum(Total Sales) assuming you mean the percentage of each department from the global total. Since the Sum(Sales) will be a large value and the percentage will be a small value, you'll need a split axis to do this in a bar chart.

Chinnu3
Contributor III
Contributor III
Author

Could you please elaborate? 

Or
MVP
MVP

I don't think there's anything to elaborate on regarding the formulas.

Your issue in a bar chart will be that the scale of each value is not similar, so the percentage bar will be tiny compared to the sales bar. I don't remember offhand if the native Qlik bar chart has an option to have two separate Y axis (left and right) or not since I use a third-party extension for bar charts. If it doesn't, you'll want to switch to a combo chart with a secondary axis.