Discussion Board for collaboration on QlikView Layout & Visualizations.
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:
Exp(sum(log(Value) works for me. Something like this should work in the script:
LOAD * INLINE [
load Dimension, Evaluate(Concat(Value,'*')) as Product
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...