Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
can anyone tell the difference between sum and rangesum function???
THANKS!!!!!!!
Sum is used to add values within a single field, whereas RangeSum is used to sum values across multiple fields.
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.
the below link explain about the rangesum
https://www.tutorialspoint.com/qlikview/qlikview_rangesum_function.htm
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,