Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the need in a QlikView file of create a formula that multiplies all the values in a field.
That would be easily described as the product of sequences, yet in QlikView it seems to me that is not present a "product()" function.
I came across the solution already proposed in 2009 in another thread:
Dimension | Value |
---|---|
A | 1.3 |
A | 1.25 |
B | 1.5 |
B | 1.7 |
Exp(sum(log(Value) works for me. Something like this should work in the script:
T1:
LOAD * INLINE [
Dimension, Value
A, 1.3
A, 1.25
B, 1.5
B, 1.7
];
T2:
load Dimension, Evaluate(Concat(Value,'*')) as Product
Resident T1
group by Dimension;
See attached example.
Yes, I suppose it could be worked around like that, still I'm confused with the Exp(Sum(Log(Value))) expression not working...