Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Geometrical mean

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

No single QV function, but you can use something like

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

Hope this helps,

Stefan

View solution in original post

3 Replies
swuehl
MVP
MVP

No single QV function, but you can use something like

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

Hope this helps,

Stefan

Anonymous
Not applicable
Author

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

exp(avg(log10(value)))

spring101
Contributor III
Contributor III

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?