topic Re: Totals in bar graphs by dimension data in QlikView

Totals in bar graphs by dimension data

fabio182 — Mon, 06 Aug 2018 22:38:27 GMT

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.

Re: Totals in bar graphs by dimension data

Anonymous — Mon, 06 Aug 2018 23:21:00 GMT

Hi,

Is this an extension object ?

Re: Totals in bar graphs by dimension data

jothimala — Tue, 07 Aug 2018 10:27:21 GMT

Hi!!

Try this out!!

Right click on the chart object
Click chart properties -> Presentation tab -> check Still show totals on top check box

Hope this works!!

Re: Totals in bar graphs by dimension data

fabio182 — Tue, 07 Aug 2018 14:32:56 GMT

Hi Chritopher,

It is not an extension object

Re: Totals in bar graphs by dimension data

fabio182 — Tue, 07 Aug 2018 14:37:51 GMT

Hello Jothimala,

I did what you told me but it's not what I need. I get the percentage values but I need to leave the values as quantity, similar to the first image I shared.

I do not need this:

I need this:

Re: Totals in bar graphs by dimension data

vishsaggi — Tue, 07 Aug 2018 15:24:39 GMT

Not sure if this is possible as it is not straight forward option to display as the axis has %ges but you want the totals to be in the graph. May be check if below work around works for you? If yes check attached.

Re: Totals in bar graphs by dimension data

fabio182 — Tue, 07 Aug 2018 15:33:54 GMT

Hi Vishwarath,

On the axes if it is possible to do that, if you knew the solution but the need is to put it on top. Apparently the graphic does not allow you to put it on top. Any idea please

Re: Totals in bar graphs by dimension data

vishsaggi — Tue, 07 Aug 2018 15:44:13 GMT

I have no other idea other than showing it in the text axis. Sorry.

Re: Totals in bar graphs by dimension data

fabio182 — Tue, 07 Aug 2018 15:45:50 GMT

Thanks friend for the support, I hope there is some other solution but no way

Re: Totals in bar graphs by dimension data

vishsaggi — Tue, 07 Aug 2018 15:50:14 GMT

May be lets here from rwunderlich‌ stalwar1‌ marcowedel‌ if any ideas.

Re: Totals in bar graphs by dimension data

neelamsaroha157 — Tue, 07 Aug 2018 16:05:52 GMT

Is this what you are looking for -

Re: Totals in bar graphs by dimension data

vishsaggi — Tue, 07 Aug 2018 16:10:02 GMT

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

Re: Totals in bar graphs by dimension data

sunny_talwar — Tue, 07 Aug 2018 16:10:39 GMT

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

Re: Totals in bar graphs by dimension data

fabio182 — Tue, 07 Aug 2018 16:11:51 GMT

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

Re: Totals in bar graphs by dimension data

fabio182 — Tue, 07 Aug 2018 16:12:49 GMT

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

Re: Totals in bar graphs by dimension data

vishsaggi — Tue, 07 Aug 2018 16:20:04 GMT

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?

Re: Totals in bar graphs by dimension data

rwunderlich — Tue, 07 Aug 2018 17:17:28 GMT

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

http://www.easyqlik.com

Re: Totals in bar graphs by dimension data

fabio182 — Tue, 07 Aug 2018 17:21:49 GMT

Thanks Rob. You are a genious

Re: Totals in bar graphs by dimension data

vishsaggi — Tue, 07 Aug 2018 17:45:03 GMT

Awesome Rob.