Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.