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

total on stack histogram


Good morning I got a histogram where the expressions are stacked

I would need to insert a total value on each bar, I tried to insert a text box with the total formula above each box, but if I apply some filters, some dimensions and columns are not visible, and being text boxes with fixed totals, there is no more matching with the bars.

is there a feature in the graph object to have the total over each bar?

thanks to everyone for the collaboration

Andrew

6 Replies
sunny_talwar

Did you try these two options on the Presentation tab of chart properties?

Capture.PNG

antoniotiman
Master III
Master III

There is only in QV 12.

Andrea, which QV Version are You using ?

warrentk80
Creator
Creator
Author

I use version 11.2 😞

antoniotiman
Master III
Master III

Try like this.

See Attachment.

warrentk80
Creator
Creator
Author

Thank you 1000 and exactly what I wanted, 🙂

a last question, how do you keep the size of the constant total bar?

antoniotiman
Master III
Master III

Dual('TOTALE ='&Chr(10)&(Sum(Value1)+Sum(Value2)),Max(TOTAL Aggr((Sum(Value1)+Sum(Value2)),Dim))/10)

Expression Part in Red

Regards,

Antonio