Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
erenk
Contributor
Contributor

Making Calculations with "Bar Labels"

Hello to all,

I have a stacked bar graph with four measures, and I want to take their average and show as a reference line for each year (one average line for each year). However, the processing time takes lots of time since my measures include many calculations.

So, I wonder that, can I use directly the values that above the bars? Since they are calculated already, I guess using them saves lots of time to me. 

 

Example:

I want to directly reach and sum values inside the circles and take their average. Then, add an line to the graph.

avg(2.77, 3.01, 4.26, 7.85, 5.42, 2.61, 3.47) Is this possible?

Untitled.png

I am waiting your help.

Thank you.

0 Replies