topic Re: total on stack histogram in QlikView

total on stack histogram

warrentk80 — Wed, 06 Sep 2017 14:53:28 GMT

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

Re: total on stack histogram

sunny_talwar — Wed, 06 Sep 2017 15:08:35 GMT

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

Re: total on stack histogram

antoniotiman — Wed, 06 Sep 2017 15:32:24 GMT

There is only in QV 12.

Andrea, which QV Version are You using ?

Re: total on stack histogram

warrentk80 — Thu, 07 Sep 2017 09:02:55 GMT

I use version 11.2 😞

Re: total on stack histogram

antoniotiman — Thu, 07 Sep 2017 09:14:30 GMT

Try like this.

See Attachment.

Re: total on stack histogram

warrentk80 — Thu, 07 Sep 2017 09:41:58 GMT

Thank you 1000 and exactly what I wanted, 🙂

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

Re: total on stack histogram

antoniotiman — Thu, 07 Sep 2017 09:54:22 GMT

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

Expression Part in Red

Regards,

Antonio