RangeSum

[asiggillino]

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

[asiggillino]

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

[jonathandienst]

You need some TOTAL qualifiers:

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

[asiggillino]

It works. Thanks a lot.

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

Alessandro

[Sue_Macaluso]

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.