Totals in bar graphs by dimension data

[fabio182]

Hello everyone, please support for the next need. It is possible to put the totals for each center at the top of the bar. As it is displayed in the image. Attachment qvw file.

[neelamsaroha157]

Is this what you are looking for -

[vishsaggi]

Amazing Neelam. Did not strike me of using Dual(). Very smart. Thanks for that.

[sunny_talwar]

But the size of the bar doesn't add up to 100%... I am not sure if that is going to be an issue or not

[fabio182]

That's right, the bar is not 100%, there is some way that does not get lost

[fabio182]

Thanks, but there is some way that you do not miss the 100% bar

[vishsaggi]

True as mentioned may be because we are showing %ge in axis or sum Total in axis. Not sure if both can be shown with different axis calculations?

[rwunderlich · Accepted solution]

Just use the Dual() in the last (total) expression. See attached.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

http://www.easyqlik.com

[fabio182]

Thanks Rob. You are a genious

[vishsaggi]

Awesome Rob.