topic Re: how to calculate the % in bar chart in QlikView https://community.qlik.com/t5/QlikView/how-to-calculate-the-in-bar-chart/m-p/1132204#M892007 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>expression: [rent cost]*100/[non-rent cost]</P><P>for your example: 2000*100/200 = 1000 %</P></BODY></HTML> Thu, 18 Aug 2016 13:31:10 GMT t_chetirbok 2016-08-18T13:31:10Z how to calculate the % in bar chart https://community.qlik.com/t5/QlikView/how-to-calculate-the-in-bar-chart/m-p/1132203#M892006 <HTML><HEAD></HEAD><BODY><P>Hi ...</P><P></P><P>for ex I have 2000 as rent cost and 200 as non-rent cost.I want to calculate the Rent cost as % of non-rent cost.</P><P></P><P>How can I put the logic here ?Thanks much.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-calculate-the-in-bar-chart/m-p/1132203#M892006 2020-11-25T16:16:04Z Re: how to calculate the % in bar chart https://community.qlik.com/t5/QlikView/how-to-calculate-the-in-bar-chart/m-p/1132204#M892007 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>expression: [rent cost]*100/[non-rent cost]</P><P>for your example: 2000*100/200 = 1000 %</P></BODY></HTML> Thu, 18 Aug 2016 13:31:10 GMT https://community.qlik.com/t5/QlikView/how-to-calculate-the-in-bar-chart/m-p/1132204#M892007 t_chetirbok 2016-08-18T13:31:10Z Re: how to calculate the % in bar chart https://community.qlik.com/t5/QlikView/how-to-calculate-the-in-bar-chart/m-p/1132205#M892008 <HTML><HEAD></HEAD><BODY><P>May be add Type of cost as your second dimension and use an expression like this:</P><P></P><P><STRONG>Sum(Cost)/Sum(TOTAL &lt;Dimesion1&gt; Cost)</STRONG></P></BODY></HTML> Thu, 18 Aug 2016 13:31:51 GMT https://community.qlik.com/t5/QlikView/how-to-calculate-the-in-bar-chart/m-p/1132205#M892008 sunny_talwar 2016-08-18T13:31:51Z