topic Re: Percent in column in QlikView https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479320#M550675 <HTML><HEAD></HEAD><BODY><P>see attached...</P><P>i actually don´t know what your dimension sort was doing??</P></BODY></HTML> Thu, 12 Dec 2013 14:17:25 GMT michael_maeuser 2013-12-12T14:17:25Z Percent in column https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479318#M550673 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>in a table chart there are two columns, sum and percent. How can i get percent in column per?</P><P></P><P>sum&nbsp;&nbsp;&nbsp; per</P><P>961&nbsp;&nbsp;&nbsp;&nbsp; 100% </P><P>125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13% </P><P>532&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 55 % </P><P></P><P>Regards</P><P>Stefan</P></BODY></HTML> Thu, 12 Dec 2013 14:05:33 GMT https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479318#M550673 Anonymous 2013-12-12T14:05:33Z Re: Percent in column https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479319#M550674 <HTML><HEAD></HEAD><BODY><P>PFA </P><P></P><P>sum(cost_eur) / sum(total cost_eur)</P><P></P><P>Hope this helps.</P></BODY></HTML> Thu, 12 Dec 2013 14:12:48 GMT https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479319#M550674 salto 2013-12-12T14:12:48Z Re: Percent in column https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479320#M550675 <HTML><HEAD></HEAD><BODY><P>see attached...</P><P>i actually don´t know what your dimension sort was doing??</P></BODY></HTML> Thu, 12 Dec 2013 14:17:25 GMT https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479320#M550675 michael_maeuser 2013-12-12T14:17:25Z Re: Percent in column https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479321#M550676 <HTML><HEAD></HEAD><BODY><P>Oops, my percentages&nbsp; are not correct <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P><P>Sorry!</P></BODY></HTML> Thu, 12 Dec 2013 14:21:33 GMT https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479321#M550676 salto 2013-12-12T14:21:33Z Re: Percent in column https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479322#M550677 <HTML><HEAD></HEAD><BODY><P><BR />That's fine, it works in my test-file, but in my original file there is something wrong. Please ckeck on attached file, thanks.</P></BODY></HTML> Thu, 12 Dec 2013 14:42:50 GMT https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479322#M550677 Anonymous 2013-12-12T14:42:50Z Re: Percent in column https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479323#M550678 <HTML><HEAD></HEAD><BODY><P>Cannot find attached file...</P></BODY></HTML> Thu, 12 Dec 2013 14:45:49 GMT https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479323#M550678 salto 2013-12-12T14:45:49Z Re: Percent in column https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479324#M550679 <HTML><HEAD></HEAD><BODY><P>Can i send you this file directly?</P></BODY></HTML> Thu, 12 Dec 2013 14:48:06 GMT https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479324#M550679 Anonymous 2013-12-12T14:48:06Z Re: Percent in column https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479325#M550680 <HTML><HEAD></HEAD><BODY><P>No problem, but if you upload it more people will be able to help you. Is is a problem for you to upload it?</P></BODY></HTML> Thu, 12 Dec 2013 14:51:04 GMT https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479325#M550680 salto 2013-12-12T14:51:04Z Re: Percent in column https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479326#M550681 <HTML><HEAD></HEAD><BODY><P>this?</P><P>per = Sum(cost_eur)/MAX(total aggr(sum(cost_eur),structure_name))</P></BODY></HTML> Thu, 12 Dec 2013 14:53:25 GMT https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479326#M550681 2013-12-12T14:53:25Z Re: Percent in column https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479327#M550682 <HTML><HEAD></HEAD><BODY><P>how can i upload?</P></BODY></HTML> Thu, 12 Dec 2013 14:53:42 GMT https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479327#M550682 Anonymous 2013-12-12T14:53:42Z Re: Percent in column https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479328#M550683 <HTML><HEAD></HEAD><BODY><P>When you answer, click on the "use the advanced editor" link in the right part. It will let you upload a document.</P></BODY></HTML> Thu, 12 Dec 2013 14:56:10 GMT https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479328#M550683 salto 2013-12-12T14:56:10Z Re: Re: Percent in column https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479329#M550684 <HTML><HEAD></HEAD><BODY><P>It's uploaded.</P></BODY></HTML> Thu, 12 Dec 2013 15:00:34 GMT https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479329#M550684 Anonymous 2013-12-12T15:00:34Z Re: Percent in column https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479330#M550685 <HTML><HEAD></HEAD><BODY><P>Label: Sum</P><P>Exp: Sum(cost_eur)/Sum({1} TOTAL cost_eur)</P><P></P><P>Go to number -&gt; check Fixed to and Show percent %.</P><P></P><P>But it is not matching according to your requirement. What is the logic you want to follow here.</P></BODY></HTML> Thu, 12 Dec 2013 15:08:08 GMT https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479330#M550685 jagannalla 2013-12-12T15:08:08Z Re: Re: Percent in column https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479331#M550686 <HTML><HEAD></HEAD><BODY><P><BR />Column A have sum overall columns below. B and C are proprtionatly.</P></BODY></HTML> Thu, 12 Dec 2013 15:19:29 GMT https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479331#M550686 Anonymous 2013-12-12T15:19:29Z Re: Re: Percent in column https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479332#M550687 <HTML><HEAD></HEAD><BODY><P><BR />That's the right answer. Many thanks for your help.</P><P></P><P>Stefan</P></BODY></HTML> Thu, 12 Dec 2013 15:48:14 GMT https://community.qlik.com/t5/QlikView/Percent-in-column/m-p/479332#M550687 Anonymous 2013-12-12T15:48:14Z