Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

bar chart

I have fllowing bar chart with two dimension. Namely Yera and Mode where there are two columns representing them . I want to show show both coloum with break up for 100%. Kindly help me this

Screenshot_1.png

1 Reply
jwjackso
Specialist III
Specialist III

If you want the columns to total 100%, you need to calculate the breakup as a ratio of the mode (assuming mode is either normal or "on the spot").

Something like this,

=Sum({<mode={'NORMAL'}>} breakup)/Sum({<mode={'NORMAL'}>} Total breakup)

Do this for both modes.  The stacked columns should total 100% of their mode.