topic Re: Difference using Sum() in QlikView

Difference using Sum()

Anonymous — Tue, 31 Jul 2012 14:29:35 GMT

Hello,

I was wondering if there's any difference between Sum(Price * Quantity) and Sum(Price) * Sum(Quantity). If there is any difference, when should I use each?

Thanks!

Re: Difference using Sum()

Tue, 31 Jul 2012 14:35:55 GMT

The first is sumproduct in my oppinion. So it adds the multipled results.

Re: Difference using Sum()

swuehl — Tue, 31 Jul 2012 14:35:57 GMT

Try this:

LOAD * INLINE [

Price, Quantity

1, -1

2, 0

3, 1

];

Do you see a difference? Why?