topic Calculating a Share in a Straight Table in QlikView https://community.qlik.com/t5/QlikView/Calculating-a-Share-in-a-Straight-Table/m-p/1142648#M374156 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need to calculate a Share in an unusual way.</P><P></P><P>Could you please have a look in the file attached and help?</P><P></P><P>Thank you in advance,</P><P></P><P>Larisa</P></BODY></HTML> Mon, 25 Jul 2016 19:26:14 GMT Anonymous 2016-07-25T19:26:14Z Calculating a Share in a Straight Table https://community.qlik.com/t5/QlikView/Calculating-a-Share-in-a-Straight-Table/m-p/1142648#M374156 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need to calculate a Share in an unusual way.</P><P></P><P>Could you please have a look in the file attached and help?</P><P></P><P>Thank you in advance,</P><P></P><P>Larisa</P></BODY></HTML> Mon, 25 Jul 2016 19:26:14 GMT https://community.qlik.com/t5/QlikView/Calculating-a-Share-in-a-Straight-Table/m-p/1142648#M374156 Anonymous 2016-07-25T19:26:14Z Re: Calculating a Share in a Straight Table https://community.qlik.com/t5/QlikView/Calculating-a-Share-in-a-Straight-Table/m-p/1142649#M374157 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Only({&lt;Edition=, Group=&gt;}Value) / Only(<SPAN style="color: #ff0000;">TOTAL &lt;Wave&gt;</SPAN>{&lt;Edition={'Major'}, Group={'All'}&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/132382_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Mon, 25 Jul 2016 19:30:40 GMT https://community.qlik.com/t5/QlikView/Calculating-a-Share-in-a-Straight-Table/m-p/1142649#M374157 sunny_talwar 2016-07-25T19:30:40Z Re: Calculating a Share in a Straight Table https://community.qlik.com/t5/QlikView/Calculating-a-Share-in-a-Straight-Table/m-p/1142650#M374158 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Mon, 25 Jul 2016 19:35:39 GMT https://community.qlik.com/t5/QlikView/Calculating-a-Share-in-a-Straight-Table/m-p/1142650#M374158 Anonymous 2016-07-25T19:35:39Z Re: Calculating a Share in a Straight Table https://community.qlik.com/t5/QlikView/Calculating-a-Share-in-a-Straight-Table/m-p/1142651#M374159 <HTML><HEAD></HEAD><BODY><P>Let me know if this works</P></BODY></HTML> Mon, 25 Jul 2016 19:44:14 GMT https://community.qlik.com/t5/QlikView/Calculating-a-Share-in-a-Straight-Table/m-p/1142651#M374159 maheshkuttappa 2016-07-25T19:44:14Z Re: Calculating a Share in a Straight Table https://community.qlik.com/t5/QlikView/Calculating-a-Share-in-a-Straight-Table/m-p/1142652#M374160 <HTML><HEAD></HEAD><BODY><P>attached file</P></BODY></HTML> Mon, 25 Jul 2016 19:45:58 GMT https://community.qlik.com/t5/QlikView/Calculating-a-Share-in-a-Straight-Table/m-p/1142652#M374160 maheshkuttappa 2016-07-25T19:45:58Z