Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
dnagarajan
Partner
Partner

Totals in bar Chart

Hey..

How to attain the average in totals in bar Chart instead of sum .

dnagarajan_1-1603799704294.png

Appreciate any quick help. Thanks

Labels (1)
5 Replies
Kushal_Chawda

@dnagarajan  not clear what you are looking at. Can you please elaborate

dnagarajan
Partner
Partner
Author

Hi @Kushal_Chawda..


this is qlik native bar chart.

Dimension is stacked category & month, Measure is just sum(field1)/sum(field2).

Totals is displayed as Sum of all values (76). instead i want to display Average in totals(~10.8)

 

forte
Partner
Partner

Hi @dnagarajan 

I'm affraid you can't change that issue. Bar chart is always totalizing as a adding values of all segments (try with an avg, it does just de same addition).

You should use two different charts, or may be a combo chart with average as a line (or symbol) on secondary axis.

Hope it helps

Regards

dnagarajan
Partner
Partner
Author

Thanks @forte i also thought of the same combo chart idea. 🤗

Trying to grasp folk's workaround solution for the same. 

Kushal_Chawda

@dnagarajan  as others mentioned, you can't directly do it , as a work around you can use custom tool tips where in you can represent the avg values.