topic Geometrical mean in QlikView https://community.qlik.com/t5/QlikView/Geometrical-mean/m-p/338540#M124870 <HTML><HEAD></HEAD><BODY><P>No single QV function, but you can use something like</P><P></P><P>=pow(exp(sum(log( YOURFIELD))),1/count( YOURFIELD) )</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Tue, 06 Mar 2012 14:25:43 GMT swuehl 2012-03-06T14:25:43Z Geometrical mean https://community.qlik.com/t5/QlikView/Geometrical-mean/m-p/338539#M124869 <HTML><HEAD></HEAD><BODY><P>How can i calculate the geometrical mean on Qlikview? Are there any Funcitons available?</P></BODY></HTML> Tue, 06 Mar 2012 14:17:04 GMT https://community.qlik.com/t5/QlikView/Geometrical-mean/m-p/338539#M124869 2012-03-06T14:17:04Z Geometrical mean https://community.qlik.com/t5/QlikView/Geometrical-mean/m-p/338540#M124870 <HTML><HEAD></HEAD><BODY><P>No single QV function, but you can use something like</P><P></P><P>=pow(exp(sum(log( YOURFIELD))),1/count( YOURFIELD) )</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Tue, 06 Mar 2012 14:25:43 GMT https://community.qlik.com/t5/QlikView/Geometrical-mean/m-p/338540#M124870 swuehl 2012-03-06T14:25:43Z Geometrical mean https://community.qlik.com/t5/QlikView/Geometrical-mean/m-p/338541#M124871 <HTML><HEAD></HEAD><BODY><P>I do not have experience with this but maybe start with something like:</P><P>exp(avg(log10(value)))</P></BODY></HTML> Tue, 06 Mar 2012 14:34:25 GMT https://community.qlik.com/t5/QlikView/Geometrical-mean/m-p/338541#M124871 Anonymous 2012-03-06T14:34:25Z Re: Geometrical mean https://community.qlik.com/t5/QlikView/Geometrical-mean/m-p/338542#M124872 <HTML><HEAD></HEAD><BODY><P>We have used this equation successfully in Qlik 11, but have recently upgraded to Qlik and it now doesn't work. We use this in a bar chart. In access point every record now shows a value of '1' on our v12 server. When editing the application it crashes. The table with the field I'm analyzing only has about 81,000 rows.</P><P></P><P>Has anyone else encountered this? Any solutions?</P></BODY></HTML> Thu, 04 Jan 2018 12:48:41 GMT https://community.qlik.com/t5/QlikView/Geometrical-mean/m-p/338542#M124872 spring101 2018-01-04T12:48:41Z