topic Re: RangeSum in QlikView

RangeSum

asiggillino — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I need to calculate a cumulative function on Frontend.

I see a very strange behavior because of the value of the Range Sum in the same as the sum.

What is the issue?

Attached he qvd and qvw files.

Thanks a lot for any suggestions

Alessandro

RangeSum

asiggillino — Mon, 04 Mar 2019 21:28:40 GMT

Hi All,

I need to calculate a cumulative function on Frontend.

I see a very strange behavior because of the value of the Range Sum in the same as the sum.

What is the issue?

Attached he qvd and qvw files.

Thanks a lot for any suggestions

Alessandro

Re: RangeSum

jonathandienst — Tue, 05 Mar 2019 05:15:05 GMT

You need some TOTAL qualifiers:

RANGESUM(ABOVE(total SUM([TPK.#VALUE]),0,RowNo(total)))

Re: RangeSum

asiggillino — Tue, 05 Mar 2019 08:16:00 GMT

It works. Thanks a lot.

But I don't understand why need to insert the TOTAL aggregation?

Alessandro

Re: RangeSum

Sue_Macaluso — Wed, 06 Mar 2019 13:40:43 GMT

Hi is this for QlikView or Sense? I want to move it into the correct product forum as more experts will see this. This forum is suppose to be for general discussion.