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: 
sweens78
Creator
Creator

Placing % on top of stacked charts with totals on x axis

Hi Guys in the below chart I want to put the percentage on top of each stack column instead of the total, it works when I tick the Relative box in expression but I then want to show the the total on the x axis instead on the bottom of the of each stack but when I do it gives me each individual amount rather than the Total see below also any ideas.?  It has also misaligned my heading on x axis

ORIGINAL CHART

CHART WITH PERCENTAGE ON TOP

1 Reply
sergio0592
Specialist III
Specialist III

Hi,

In your expression, you have to use dual() function with :

dual(num(sum(Attendances) / sum(TOTAL Attendances),'# ##0,0%'), sum(Attendances))