topic Re: formula problem in graph in QlikView https://community.qlik.com/t5/QlikView/formula-problem-in-graph/m-p/703415#M253720 <HTML><HEAD></HEAD><BODY><P>thanks for your help. i didn't know the 'total' command. this was very easy <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 18 Jul 2014 09:24:05 GMT 2014-07-18T09:24:05Z formula problem in graph https://community.qlik.com/t5/QlikView/formula-problem-in-graph/m-p/703411#M253716 <HTML><HEAD></HEAD><BODY><P>hi</P><P>i have a pie chart that is splitted up in ariclegroups and shows the income. the formula is sum(income). </P><P>I want that the pie chart shows the percantage of sales per articlegroup. basically i have to get a formula that divides the partial income per articlegroup by the total income, right? but i can't figure out the correct formula for that. please help me.</P></BODY></HTML> Fri, 18 Jul 2014 09:10:03 GMT https://community.qlik.com/t5/QlikView/formula-problem-in-graph/m-p/703411#M253716 2014-07-18T09:10:03Z Re: formula problem in graph https://community.qlik.com/t5/QlikView/formula-problem-in-graph/m-p/703412#M253717 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P>=sum(income)/Sum( <STRONG>Total</STRONG> income)</P><P></P><P>And&nbsp; in the number tab check 'Show in Percent (%)'</P></BODY></HTML> Fri, 18 Jul 2014 09:11:46 GMT https://community.qlik.com/t5/QlikView/formula-problem-in-graph/m-p/703412#M253717 tresB 2014-07-18T09:11:46Z Re: formula problem in graph https://community.qlik.com/t5/QlikView/formula-problem-in-graph/m-p/703413#M253718 <HTML><HEAD></HEAD><BODY><P>can you please post your sample qvw?</P><P>have you tried using Relative option in the chart expression tab?</P></BODY></HTML> Fri, 18 Jul 2014 09:14:04 GMT https://community.qlik.com/t5/QlikView/formula-problem-in-graph/m-p/703413#M253718 sudeepkm 2014-07-18T09:14:04Z Re: formula problem in graph https://community.qlik.com/t5/QlikView/formula-problem-in-graph/m-p/703414#M253719 <HTML><HEAD></HEAD><BODY><P>Try tresesco's formular and put the articlegroup as dimension. Don't forget to check the relative-box in your pie-chart.</P><P></P><P>That should do the trick....</P></BODY></HTML> Fri, 18 Jul 2014 09:14:10 GMT https://community.qlik.com/t5/QlikView/formula-problem-in-graph/m-p/703414#M253719 2014-07-18T09:14:10Z Re: formula problem in graph https://community.qlik.com/t5/QlikView/formula-problem-in-graph/m-p/703415#M253720 <HTML><HEAD></HEAD><BODY><P>thanks for your help. i didn't know the 'total' command. this was very easy <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 18 Jul 2014 09:24:05 GMT https://community.qlik.com/t5/QlikView/formula-problem-in-graph/m-p/703415#M253720 2014-07-18T09:24:05Z