topic calculating share in QlikView https://community.qlik.com/t5/QlikView/calculating-share/m-p/1111145#M367501 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need to calculate a share of groups ABCDE within each Edition.</P><P></P><P>I'm using the formula:</P><P>Value / (sum({&lt;Edition=, Group=&gt;}Value))*100</P><P></P><P>But it doesn't work. It show 100 for each group.</P><P></P><P>The example ia attached.</P><P></P><P>Thank you in advance,</P><P></P><P>Larisa</P></BODY></HTML> Mon, 15 Aug 2016 17:24:02 GMT Anonymous 2016-08-15T17:24:02Z calculating share https://community.qlik.com/t5/QlikView/calculating-share/m-p/1111145#M367501 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need to calculate a share of groups ABCDE within each Edition.</P><P></P><P>I'm using the formula:</P><P>Value / (sum({&lt;Edition=, Group=&gt;}Value))*100</P><P></P><P>But it doesn't work. It show 100 for each group.</P><P></P><P>The example ia attached.</P><P></P><P>Thank you in advance,</P><P></P><P>Larisa</P></BODY></HTML> Mon, 15 Aug 2016 17:24:02 GMT https://community.qlik.com/t5/QlikView/calculating-share/m-p/1111145#M367501 Anonymous 2016-08-15T17:24:02Z Re: calculating share https://community.qlik.com/t5/QlikView/calculating-share/m-p/1111146#M367502 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>Value / (Sum(<SPAN style="color: #ff0000;">TOTAL &lt;Edition&gt;</SPAN>{&lt;Edition=, Group=&gt;}Value))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/134589_Capture.PNG" style="height: 321px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Mon, 15 Aug 2016 17:26:18 GMT https://community.qlik.com/t5/QlikView/calculating-share/m-p/1111146#M367502 sunny_talwar 2016-08-15T17:26:18Z