multiply vs. rangesum

[#1]

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

[#2]

Hi

maybe this :   exp(   Sum(  Log( value))  )

JJ

[swuehl]

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

[qliksus]

Hi ,

Create  a variable in the document properties Variable1 like

  = concat(value,'*')

and in the chart expression give it like $(Variable1)