topic Re: bar chart in QlikView https://community.qlik.com/t5/QlikView/bar-chart/m-p/15730#M2586 <HTML><HEAD></HEAD><BODY><P>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").</P><P></P><P>Something like this,</P><P>=Sum({&lt;mode={'NORMAL'}&gt;} breakup)/Sum({&lt;mode={'NORMAL'}&gt;} Total breakup)</P><P>Do this for both modes.&nbsp; The stacked columns should total 100% of their mode.</P></BODY></HTML> Tue, 13 Mar 2018 11:09:43 GMT jwjackso 2018-03-13T11:09:43Z bar chart https://community.qlik.com/t5/QlikView/bar-chart/m-p/15729#M2585 <HTML><HEAD></HEAD><BODY><P>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 </P><P></P><P><IMG alt="Screenshot_1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196121_Screenshot_1.png" style="height: 353px; width: 620px;" /></P></BODY></HTML> Tue, 13 Mar 2018 06:48:51 GMT https://community.qlik.com/t5/QlikView/bar-chart/m-p/15729#M2585 upaliwije 2018-03-13T06:48:51Z Re: bar chart https://community.qlik.com/t5/QlikView/bar-chart/m-p/15730#M2586 <HTML><HEAD></HEAD><BODY><P>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").</P><P></P><P>Something like this,</P><P>=Sum({&lt;mode={'NORMAL'}&gt;} breakup)/Sum({&lt;mode={'NORMAL'}&gt;} Total breakup)</P><P>Do this for both modes.&nbsp; The stacked columns should total 100% of their mode.</P></BODY></HTML> Tue, 13 Mar 2018 11:09:43 GMT https://community.qlik.com/t5/QlikView/bar-chart/m-p/15730#M2586 jwjackso 2018-03-13T11:09:43Z