topic Re: Calculatuing Average in QlikView https://community.qlik.com/t5/QlikView/Calculatuing-Average/m-p/462052#M172547 <HTML><HEAD></HEAD><BODY><P>This should do the trick:</P><P></P><P><EM>=avg(numerator/denominator)*100</EM></P><P></P><P>For targetting only Kpi=1, use:</P><P></P><P><EM>=avg({$&lt;Kpi={1}&gt;} numerator/denominator)*100</EM></P></BODY></HTML> Fri, 23 Nov 2012 09:48:46 GMT Anonymous 2012-11-23T09:48:46Z Calculatuing Average https://community.qlik.com/t5/QlikView/Calculatuing-Average/m-p/462051#M172546 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have got large amount of data which looks something like this</P><P>example:</P><P></P><P>Kpi&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Location&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; numerator&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Denominator</P><P></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; London&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Essex&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp; </P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sussex&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Newcastle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Oxford&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp; </P><P></P><P></P><P>I have created a Bar chart with Location on X axis and and percentage on Y axis.</P><P>Percentage is calculated by (Numerator/denominator)*100 </P><P>I am looking to calculate the AVERAGE and display it in a text box under the chart wrt to KPI 1. </P><P></P><P>Can I get some help for this please. </P></BODY></HTML> Fri, 23 Nov 2012 09:41:16 GMT https://community.qlik.com/t5/QlikView/Calculatuing-Average/m-p/462051#M172546 2012-11-23T09:41:16Z Re: Calculatuing Average https://community.qlik.com/t5/QlikView/Calculatuing-Average/m-p/462052#M172547 <HTML><HEAD></HEAD><BODY><P>This should do the trick:</P><P></P><P><EM>=avg(numerator/denominator)*100</EM></P><P></P><P>For targetting only Kpi=1, use:</P><P></P><P><EM>=avg({$&lt;Kpi={1}&gt;} numerator/denominator)*100</EM></P></BODY></HTML> Fri, 23 Nov 2012 09:48:46 GMT https://community.qlik.com/t5/QlikView/Calculatuing-Average/m-p/462052#M172547 Anonymous 2012-11-23T09:48:46Z Re: Calculatuing Average https://community.qlik.com/t5/QlikView/Calculatuing-Average/m-p/462053#M172548 <HTML><HEAD></HEAD><BODY><P>Thanks <A _jive_internal="true" class="jiveTT-hover-user jive-username-link" href="https://community.qlik.com/people/jsn" id="jive-23887044069836334191" onmouseout="" onmouseover="">Johannes Sunden</A>. That was of much help.</P><P></P><P>Regards,</P><P>K.V</P></BODY></HTML> Fri, 23 Nov 2012 10:01:44 GMT https://community.qlik.com/t5/QlikView/Calculatuing-Average/m-p/462053#M172548 2012-11-23T10:01:44Z