topic Calculation of Weightage Average in App Development https://community.qlik.com/t5/App-Development/Calculation-of-Weightage-Average/m-p/1823296#M67539 <P>Hi,</P><P>I've to Calculate weightage on the basis of different keys. So, I wrote&nbsp;the expression for it as mentioned below but it's not working.</P><P>Aggr(Sum(Book Value)/Sum(total Book Value),Key1)</P><P>Below are the inputs.</P><TABLE><TBODY><TR><TD>KEY1</TD><TD>KEY2</TD><TD>BookValue</TD><TD>Weigtage1 (On the basis Of Key 1)</TD><TD>Weigtage2 (On the basis Of Key 2)</TD></TR><TR><TD>A</TD><TD>Z</TD><TD>100</TD><TD>0.333333333</TD><TD>1</TD></TR><TR><TD>A</TD><TD>Y</TD><TD>200</TD><TD>0.666666667</TD><TD>1</TD></TR><TR><TD>B</TD><TD>X</TD><TD>300</TD><TD>1</TD><TD>0.25</TD></TR><TR><TD>C</TD><TD>X</TD><TD>400</TD><TD>1</TD><TD>0.333333333</TD></TR><TR><TD>D</TD><TD>X</TD><TD>500</TD><TD>1</TD><TD>0.416666667</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Could anyone help me. How I can achieve it ?</P><P>Thanks in advance.</P><P>Chetan C</P> Tue, 20 Jul 2021 12:28:44 GMT C_ChetanChaudhari 2021-07-20T12:28:44Z Calculation of Weightage Average https://community.qlik.com/t5/App-Development/Calculation-of-Weightage-Average/m-p/1823296#M67539 <P>Hi,</P><P>I've to Calculate weightage on the basis of different keys. So, I wrote&nbsp;the expression for it as mentioned below but it's not working.</P><P>Aggr(Sum(Book Value)/Sum(total Book Value),Key1)</P><P>Below are the inputs.</P><TABLE><TBODY><TR><TD>KEY1</TD><TD>KEY2</TD><TD>BookValue</TD><TD>Weigtage1 (On the basis Of Key 1)</TD><TD>Weigtage2 (On the basis Of Key 2)</TD></TR><TR><TD>A</TD><TD>Z</TD><TD>100</TD><TD>0.333333333</TD><TD>1</TD></TR><TR><TD>A</TD><TD>Y</TD><TD>200</TD><TD>0.666666667</TD><TD>1</TD></TR><TR><TD>B</TD><TD>X</TD><TD>300</TD><TD>1</TD><TD>0.25</TD></TR><TR><TD>C</TD><TD>X</TD><TD>400</TD><TD>1</TD><TD>0.333333333</TD></TR><TR><TD>D</TD><TD>X</TD><TD>500</TD><TD>1</TD><TD>0.416666667</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Could anyone help me. How I can achieve it ?</P><P>Thanks in advance.</P><P>Chetan C</P> Tue, 20 Jul 2021 12:28:44 GMT https://community.qlik.com/t5/App-Development/Calculation-of-Weightage-Average/m-p/1823296#M67539 C_ChetanChaudhari 2021-07-20T12:28:44Z