topic Re: DIfference in QlikView

DIfference

lionking15 — Fri, 16 Sep 2016 10:43:50 GMT

HI,

can anyone tell the difference between sum and rangesum function???

THANKS!!!!!!!

sunny_talwar — Fri, 16 Sep 2016 10:46:52 GMT

Sum is used to add values within a single field, whereas RangeSum is used to sum values across multiple fields.

tresB — Fri, 16 Sep 2016 10:50:16 GMT

Say you have data like:

F1, F2

10, 20

30, 40

You can sum values of a single field like: Sum(F1) - gives 10+30=40

You can sun multiple field values of a record like: Rangesum(F1, F2) - gives 10+20=30 when first record is selected

hope this helps.

Fri, 16 Sep 2016 12:24:41 GMT

the below link explain about the rangesum

Digvijay_Singh — Fri, 16 Sep 2016 13:00:30 GMT

It also helps in handling NULLs like below -

SUM(Cost1) + Sum(Cost2), if any of both sum is null(), the whole output will be null but

Rangesum(Sum(Cost1), Sum(Cost2)) - this won't result into null() in same situation.

Thanks,