Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
warrentk80
New Contributor III

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

Re: total on stack histogram

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

Capture.PNG

antoniotiman
Honored Contributor III

Re: total on stack histogram

There is only in QV 12.

Andrea, which QV Version are You using ?

warrentk80
New Contributor III

Re: total on stack histogram

I use version 11.2 :-(

antoniotiman
Honored Contributor III

Re: total on stack histogram

Try like this.

See Attachment.

warrentk80
New Contributor III

Re: total on stack histogram

Thank you 1000 and exactly what I wanted, :-)

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

antoniotiman
Honored Contributor III

Re: total on stack histogram

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

Expression Part in Red

Regards,

Antonio

Community Browser