Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
fabio182
Creator II
Creator II

Totals in bar graphs

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


yyyy.png

1 Solution

Accepted Solutions
chrismarlow
Specialist II
Specialist II

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);

316496_1.png

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;

316496_2.png

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.

View solution in original post

6 Replies
jayanttibhe
Creator III
Creator III

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

fabio182
Creator II
Creator II
Author

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

chrismarlow
Specialist II
Specialist II

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);

316496_1.png

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;

316496_2.png

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.

vishsaggi
Champion III
Champion III

May be try this in your expr like

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

fabio182
Creator II
Creator II
Author

Very very very thanks @chrismarlow, you are genius.

chrismarlow
Specialist II
Specialist II

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