topic multiply vs. rangesum in QlikView

multiply vs. rangesum

Tue, 18 Oct 2011 18:34:40 GMT

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

Tue, 18 Oct 2011 19:20:10 GMT

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

swuehl — Tue, 18 Oct 2011 23:24:10 GMT

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:

Have a nice evening,

Stefan

qliksus — Wed, 19 Oct 2011 05:19:23 GMT

Hi ,

Create a variable in the document properties Variable1 like

= concat(value,'*')

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