topic Re: Totals in bar graphs in QlikView

Totals in bar graphs

fabio182 — Wed, 10 Oct 2018 16:54:57 GMT

hello friends of the community, I turn to your help for the next problem. It is possible to put the totals only of some values in the bar chart, as well as the image. Thank you

Re: Totals in bar graphs

jayanttibhe — Wed, 10 Oct 2018 17:19:16 GMT

Check the presentation Tab of the bar chart and tick these options

Re: Totals in bar graphs

fabio182 — Wed, 10 Oct 2018 17:28:00 GMT

when I do that I get 100%, it's not the solution.

Re: Totals in bar graphs

chrismarlow — Wed, 10 Oct 2018 18:16:57 GMT

The attached is a horrible hack, but might work. I've only got personal edition, so you may struggle to open it, let me know.

It relies on first having 4 expressions - the 4th being the sum for the right hand side & making that invisible (but still showing value);

Then cheating by setting the scale to 0 to 1.1, which forces the 4th value to the left hand side of the (invisible) bar;

If this will work with your 2 dimensions on the axis I don't know & it would be great to see a more elegant solution.

Regards,

Chris.

Re: Totals in bar graphs

vishsaggi — Wed, 10 Oct 2018 18:47:15 GMT

May be try this in your expr like

Sum(Aggr(Sum(YourmeasureField), Dim1))

Re: Totals in bar graphs

fabio182 — Wed, 10 Oct 2018 19:47:53 GMT

Very very very thanks @chrismarlow, you are genius.

Re: Totals in bar graphs

chrismarlow — Thu, 11 Oct 2018 13:40:55 GMT

You are too kind. I can assure you that was 99% perspiration and 1% luck.