Cumulative by each Unique Record

MalcolmCICWF — Sat, 16 Nov 2024 17:53:19 GMT

I am trying to create a Cumulative expression that is off of the incrimental per Example column. I can get it to do cumulative of the entire column, but Not for Example A and then start over on Example B. Is there a group by function I can write in the expression itself?

This is what I was trying to use. The PaymentAmount is what I divide by the Facevalue (per Example) to get Incremental %. But I'm wondering if I can just do it off the Incremental column itself as a reference.

RangeSum(Above(TOTAL Sum(PaymentAmount), 1, RowNo(TOTAL)))

Re: Cumulative by each Unique Record

chrismarlow — Mon, 02 Nov 2020 19:33:48 GMT

Hi,

Above/RangeSum do recongnise the change on the first column, so might the following work;

RangeSum(Above(Column(3), 0, RowNo()))

So as below;

Cheers,

Chris.

topic Cumulative by each Unique Record in QlikView

Cumulative by each Unique Record

Re: Cumulative by each Unique Record