topic Re: Expression for Ratio in QlikView https://community.qlik.com/t5/QlikView/Expression-for-Ratio/m-p/53338#M8872 <HTML><HEAD></HEAD><BODY><P>iT is difficult to share sample data</P></BODY></HTML> Wed, 18 Apr 2018 06:12:48 GMT upaliwije 2018-04-18T06:12:48Z Expression for Ratio https://community.qlik.com/t5/QlikView/Expression-for-Ratio/m-p/53336#M8870 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>I have follwing pivot tbale in my QV doc</P><P></P><P><IMG alt="Screenshot_1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/199978_Screenshot_1.png" style="height: auto;" /></P><P>and I want to show Ratio of each item under DES coloum against Gross Premium. I have written the follwing&nbsp; expression. but It does not show expected valures in Ratio column. Kindly help me to correct my expression.</P><P></P><P>=fabs(Sum(PL)/sum({&lt;DES={'GROSS_PREMIUM'}&gt;}PL))*100</P></BODY></HTML> Wed, 18 Apr 2018 05:44:58 GMT https://community.qlik.com/t5/QlikView/Expression-for-Ratio/m-p/53336#M8870 upaliwije 2018-04-18T05:44:58Z Re: Expression for Ratio https://community.qlik.com/t5/QlikView/Expression-for-Ratio/m-p/53337#M8871 <HTML><HEAD></HEAD><BODY><P>can you attach the sample app. then it will easy to reach the requirement.</P></BODY></HTML> Wed, 18 Apr 2018 05:59:05 GMT https://community.qlik.com/t5/QlikView/Expression-for-Ratio/m-p/53337#M8871 chinnuchinni 2018-04-18T05:59:05Z Re: Expression for Ratio https://community.qlik.com/t5/QlikView/Expression-for-Ratio/m-p/53338#M8872 <HTML><HEAD></HEAD><BODY><P>iT is difficult to share sample data</P></BODY></HTML> Wed, 18 Apr 2018 06:12:48 GMT https://community.qlik.com/t5/QlikView/Expression-for-Ratio/m-p/53338#M8872 upaliwije 2018-04-18T06:12:48Z Re: Expression for Ratio https://community.qlik.com/t5/QlikView/Expression-for-Ratio/m-p/53339#M8873 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>=fabs(Sum(PL)/sum(<SPAN style="color: #ff0000;">TOTAL &lt;FROM_YEAR&gt;</SPAN> {&lt;DES={'GROSS_PREMIUM'}&gt;}PL))*100</STRONG></P></BODY></HTML> Wed, 18 Apr 2018 09:09:08 GMT https://community.qlik.com/t5/QlikView/Expression-for-Ratio/m-p/53339#M8873 sunny_talwar 2018-04-18T09:09:08Z Re: Expression for Ratio https://community.qlik.com/t5/QlikView/Expression-for-Ratio/m-p/53340#M8874 <HTML><HEAD></HEAD><BODY><P>what is your expected output??</P><P>also explain your formula in simple word.</P><P></P><P>Regards</P></BODY></HTML> Wed, 18 Apr 2018 09:17:38 GMT https://community.qlik.com/t5/QlikView/Expression-for-Ratio/m-p/53340#M8874 PrashantSangle 2018-04-18T09:17:38Z Re: Expression for Ratio https://community.qlik.com/t5/QlikView/Expression-for-Ratio/m-p/53341#M8875 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny!</P><P></P><P>That is exactly what I wanted. You are precise as usual</P></BODY></HTML> Wed, 18 Apr 2018 09:24:31 GMT https://community.qlik.com/t5/QlikView/Expression-for-Ratio/m-p/53341#M8875 upaliwije 2018-04-18T09:24:31Z