Geometrical mean

[#1]

How can i calculate the geometrical mean on Qlikview? Are there any Funcitons available?

[swuehl · Accepted solution]

No single QV function, but you can use something like

=pow(exp(sum(log( YOURFIELD))),1/count( YOURFIELD) )

Hope this helps,

Stefan

[Anonymous]

I do not have experience with this but maybe start with something like:

exp(avg(log10(value)))

[spring101]

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.

Has anyone else encountered this? Any solutions?