Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist
Specialist

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
Highlighted
Creator III
Creator III

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

Highlighted
Creator II
Creator II

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

Highlighted
Specialist
Specialist

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

Highlighted
Champion III
Champion III

May be try this in your expr like

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

Highlighted
Creator II
Creator II

Very very very thanks @chrismarlow, you are genius.

Highlighted
Specialist
Specialist

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