topic Re: Regarding the working of Rangesum() in QlikView

Regarding the working of Rangesum()

chandrikag — Mon, 25 Jan 2016 20:04:49 GMT

I would like to know how RANGESUM() works and what would the result be for this: RANGESUM(1,2,'abc',NULL(),5)?

Please let me know.

Re: Regarding the working of Rangesum()

sunny_talwar — Mon, 01 Feb 2016 21:09:14 GMT

To check the output, you can create a text object with the expression you have:

It is summing non-null numeric values (1, 2, and 5) and ignores null and letters.

Re: Regarding the working of Rangesum()

chandrikag — Mon, 01 Feb 2016 21:13:03 GMT

Thank you Sunny!

Re: Regarding the working of Rangesum()

Anonymous — Mon, 01 Feb 2016 21:44:47 GMT

Hi Chandrika,

I'm glad you were able to get some assistance. If Sunny's reply fully answered your question, please take a moment to mark his post as the Correct Answer. This changes the thread category from Unanswered Question to Answered Question and awards points to Sunny for helping you.

For more details, please see this thread: Qlik Community Tip: Marking Replies as Correct or Helpful

Best regards,

Qlik Community Moderation Team

Re: Regarding the working of Rangesum()

Peter_Cammaert — Mon, 01 Feb 2016 21:57:02 GMT

RangeSum() is not an aggregation function. It sums only individual numerical values that are listed as parameters to this call. There is no limit to the number of parameters you can specify.

Best,

Peter

Re: Regarding the working of Rangesum()

Peter_Cammaert — Mon, 01 Feb 2016 22:00:59 GMT

In addition to the preceding, RangSum() will always return a value because invalid values (like text or NULL values) will all be treated as 0. That's the main and very useful difference with the + operator which fill return NULL as soon as even one operand proves to be invalid or NULL.

Re: Regarding the working of Rangesum()

chandrikag — Tue, 02 Feb 2016 03:45:08 GMT

Thank you Cammaert!