Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can i calculate the geometrical mean on Qlikview? Are there any Funcitons available?
No single QV function, but you can use something like
=pow(exp(sum(log( YOURFIELD))),1/count( YOURFIELD) )
Hope this helps,
Stefan
No single QV function, but you can use something like
=pow(exp(sum(log( YOURFIELD))),1/count( YOURFIELD) )
Hope this helps,
Stefan
I do not have experience with this but maybe start with something like:
exp(avg(log10(value)))
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?