topic Calculate margin percentage in QlikView https://community.qlik.com/t5/QlikView/Calculate-margin-percentage/m-p/283593#M1201743 <HTML><HEAD></HEAD><BODY><P>Hello, I am new to qlikview and have a very basic tool question that can't seem to figure out.</P><P>The question is, how do I add "margin percentage" in my bar chart? I have the margin by total amount but I can't seem to add the percentage.</P><P>I tried the following expression : "sum ((total sales/cost) * 100) but it doesnt work. Please help!!</P><P></P><P></P></BODY></HTML> Sun, 24 Oct 2010 03:06:03 GMT 2010-10-24T03:06:03Z Calculate margin percentage https://community.qlik.com/t5/QlikView/Calculate-margin-percentage/m-p/283593#M1201743 <HTML><HEAD></HEAD><BODY><P>Hello, I am new to qlikview and have a very basic tool question that can't seem to figure out.</P><P>The question is, how do I add "margin percentage" in my bar chart? I have the margin by total amount but I can't seem to add the percentage.</P><P>I tried the following expression : "sum ((total sales/cost) * 100) but it doesnt work. Please help!!</P><P></P><P></P></BODY></HTML> Sun, 24 Oct 2010 03:06:03 GMT https://community.qlik.com/t5/QlikView/Calculate-margin-percentage/m-p/283593#M1201743 2010-10-24T03:06:03Z Calculate margin percentage https://community.qlik.com/t5/QlikView/Calculate-margin-percentage/m-p/283594#M1201744 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>try <I>sum(total sales) / sum(costs)</I>. Take a look at the checkbox 'Show in Percent' on the numbers tab.</P></BODY></HTML> Sun, 24 Oct 2010 06:02:15 GMT https://community.qlik.com/t5/QlikView/Calculate-margin-percentage/m-p/283594#M1201744 2010-10-24T06:02:15Z Calculate margin percentage https://community.qlik.com/t5/QlikView/Calculate-margin-percentage/m-p/283595#M1201745 <HTML><HEAD></HEAD><BODY><P>Thank you so much! It worked!</P></BODY></HTML> Sun, 24 Oct 2010 07:04:47 GMT https://community.qlik.com/t5/QlikView/Calculate-margin-percentage/m-p/283595#M1201745 2010-10-24T07:04:47Z Calculate margin percentage https://community.qlik.com/t5/QlikView/Calculate-margin-percentage/m-p/283596#M1201746 <HTML><HEAD></HEAD><BODY><P>Hi KaliPres,</P><P>would you mark this thread as solved. Thanks, Roland</P></BODY></HTML> Mon, 25 Oct 2010 13:14:07 GMT https://community.qlik.com/t5/QlikView/Calculate-margin-percentage/m-p/283596#M1201746 2010-10-25T13:14:07Z