topic Re: Percent Calculation Function in QlikView https://community.qlik.com/t5/QlikView/Percent-Calculation-Function/m-p/1084236#M522476 <HTML><HEAD></HEAD><BODY><P>Thanks Mr. Kumar!!</P></BODY></HTML> Fri, 22 Apr 2016 09:11:08 GMT 2016-04-22T09:11:08Z Percent Calculation Function https://community.qlik.com/t5/QlikView/Percent-Calculation-Function/m-p/1084232#M522472 <HTML><HEAD></HEAD><BODY><P>Is there a function in QV to calculate the % contribution automatically.</P><P></P><P>I have data by type like </P><P>Type&nbsp;&nbsp;&nbsp;&nbsp; Transactions</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</P><P></P><P>I am able to present it via chart however I was trying to present percent contribution instead of actual count</P></BODY></HTML> Fri, 22 Apr 2016 08:57:51 GMT https://community.qlik.com/t5/QlikView/Percent-Calculation-Function/m-p/1084232#M522472 2016-04-22T08:57:51Z Re: Percent Calculation Function https://community.qlik.com/t5/QlikView/Percent-Calculation-Function/m-p/1084233#M522473 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P>Dimension: <STRONG>Type</STRONG></P><P>Expression: <STRONG>Count(Transactions)/Count(TOTAL Transactions)</STRONG></P></BODY></HTML> Fri, 22 Apr 2016 09:06:57 GMT https://community.qlik.com/t5/QlikView/Percent-Calculation-Function/m-p/1084233#M522473 sunny_talwar 2016-04-22T09:06:57Z Re: Percent Calculation Function https://community.qlik.com/t5/QlikView/Percent-Calculation-Function/m-p/1084234#M522474 <HTML><HEAD></HEAD><BODY><P>OR you can check <STRONG>relative</STRONG> option to your expression Count(Transactions) in expression tab</P></BODY></HTML> Fri, 22 Apr 2016 09:08:58 GMT https://community.qlik.com/t5/QlikView/Percent-Calculation-Function/m-p/1084234#M522474 kkkumar82 2016-04-22T09:08:58Z Re: Percent Calculation Function https://community.qlik.com/t5/QlikView/Percent-Calculation-Function/m-p/1084235#M522475 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny</P></BODY></HTML> Fri, 22 Apr 2016 09:10:47 GMT https://community.qlik.com/t5/QlikView/Percent-Calculation-Function/m-p/1084235#M522475 2016-04-22T09:10:47Z Re: Percent Calculation Function https://community.qlik.com/t5/QlikView/Percent-Calculation-Function/m-p/1084236#M522476 <HTML><HEAD></HEAD><BODY><P>Thanks Mr. Kumar!!</P></BODY></HTML> Fri, 22 Apr 2016 09:11:08 GMT https://community.qlik.com/t5/QlikView/Percent-Calculation-Function/m-p/1084236#M522476 2016-04-22T09:11:08Z