Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
aut_phil
Contributor

Sum() behaviour

Hi,

does it make a difference perfomancewise?

sum(Value*ExchangeRate)

sum(Value)*ExchangeRate

You could assume that the second one is faster because its first sums all value and then multiplies it only once with the exchange rate.

But i dont know if thats the case in the QIX Engine.

Any thoughts are appreciated!

-Phil

2 Replies
Highlighted

Re: Sum() behaviour

Not sure about the performance, but second one would only work if you have a single possible ExchangeRate for each of the combination of your dimension. If there are multiple Exchange Rates, it will become null

Highlighted
aut_phil
Contributor

Re: Sum() behaviour

Hello Sunny,

Im aware of that, thanks!