topic Re: Percentage Calculation in QlikView https://community.qlik.com/t5/QlikView/Percentage-Calculation/m-p/710674#M255998 <HTML><HEAD></HEAD><BODY><P>Expression for Promoter</P><P>=sum({&lt;Name={'Promoter'}&gt;}[Relationship Score])</P><P>/</P><P>sum([Relationship Score])</P><P></P><P>Expression for Detractor</P><P>=sum({&lt;Name={'Detractor'}&gt;}[Relationship Score])</P><P>/</P><P>sum([Relationship Score])</P></BODY></HTML> Fri, 04 Jul 2014 04:32:00 GMT 2014-07-04T04:32:00Z Percentage Calculation https://community.qlik.com/t5/QlikView/Percentage-Calculation/m-p/710673#M255997 <HTML><HEAD></HEAD><BODY><P>Hello Community,</P><P></P><P>I have table like this, which is having two columns named as Name and Relationship Nps Score.</P><P></P><P>I want Percentage Calculation for Promoter and detractor.</P><P></P><P>Percentage Calculation is only Set Analysis.</P><P></P><P>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , Relationship Nps Score</P><P>Promoter&nbsp;&nbsp;&nbsp;&nbsp; , 2 </P><P>Detractor&nbsp;&nbsp;&nbsp;&nbsp; , 3</P><P>Promoter&nbsp;&nbsp;&nbsp;&nbsp; , 4 </P><P>Promoter&nbsp;&nbsp;&nbsp;&nbsp; , 6 </P><P>Detractor&nbsp;&nbsp;&nbsp;&nbsp; , 7</P><P>Promoter&nbsp;&nbsp;&nbsp;&nbsp; , 1 </P><P>Detractor&nbsp;&nbsp;&nbsp;&nbsp; , 9</P><P>Detractor&nbsp;&nbsp;&nbsp;&nbsp; , 10</P><P></P><P>Could you please help me for the same.</P><P></P><P>- Thanks and Regards,</P><P>Villyee</P></BODY></HTML> Fri, 04 Jul 2014 04:18:43 GMT https://community.qlik.com/t5/QlikView/Percentage-Calculation/m-p/710673#M255997 vanderson009 2014-07-04T04:18:43Z Re: Percentage Calculation https://community.qlik.com/t5/QlikView/Percentage-Calculation/m-p/710674#M255998 <HTML><HEAD></HEAD><BODY><P>Expression for Promoter</P><P>=sum({&lt;Name={'Promoter'}&gt;}[Relationship Score])</P><P>/</P><P>sum([Relationship Score])</P><P></P><P>Expression for Detractor</P><P>=sum({&lt;Name={'Detractor'}&gt;}[Relationship Score])</P><P>/</P><P>sum([Relationship Score])</P></BODY></HTML> Fri, 04 Jul 2014 04:32:00 GMT https://community.qlik.com/t5/QlikView/Percentage-Calculation/m-p/710674#M255998 2014-07-04T04:32:00Z