Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
I'm trying to multiply each values in a straight or pivot table.
Tables looks like this
id value multi
1 0.9 0.0432
2 0.8 0.0432
3 0.2 0.0432
4 0.3 0.0432
multi should be the multiplication of 0.9x0.8x0.2x0.3 = 0.0432
Tried with bevore/above but without success. Any hints?
Thanks in advance
Aloah
Hi
maybe this : exp( Sum( Log( value)) )
JJ
Hi,
in a table, you probably need a
exp( sum( total log(value)))
And if your values are calculated, you maybe need advanced aggregation within the log function.
Surprisingly, an almost identical question was raised here today:
http://community.qlik.com/message/158687
Have a nice evening,
Stefan
Hi ,
Create a variable in the document properties Variable1 like
= concat(value,'*')
and in the chart expression give it like $(Variable1)