This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
How to attain the average in totals in bar Chart instead of sum .
Appreciate any quick help. Thanks
@dnagarajan not clear what you are looking at. Can you please elaborate
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)
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
Thanks @forte i also thought of the same combo chart idea. 🤗
Trying to grasp folk's workaround solution for the same.
@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.