topic Re: RangeSum on different column in QlikView

RangeSum on different column

Tue, 13 Dec 2016 11:57:26 GMT

Hello

I've been trying to calculate a Sum of an expression using only one value per Rank.

Rank Product Expression RequestedColumn

1 1 14 14

1 2 14 14

2 3 14 28

2 4 14 28

3 5 12 40

13 6 12 40

I've tried multiple rangesum / above / aggr combinations but i can't seem to get it to work.

Either returning all 0 or nested aggr as result.

This is my first post on the community help forum, please advise if i need to provide additional information or should formulate question differently.

Thanks in advance,

Regards

Daan

Re: RangeSum on different column

sunny_talwar — Tue, 13 Dec 2016 12:25:27 GMT

May be this?

=Aggr(NODISTINCT RangeSum(Above(CalculatedField, 0, RowNo())), Rank)

Re: RangeSum on different column

enriquem — Tue, 13 Dec 2016 12:27:04 GMT

Hi,

I don't know what you are trying to rangesum or sum, but maybe you can use the 'set analysis'. I leave you here a link to see some examples Set Analysis - Ejemplos

Regards

Re: RangeSum on different column

Tue, 13 Dec 2016 12:41:33 GMT

Hey Sunny

Thanks for your quick response implemented and tested it in my project and so far so good!

I'm going to lookup some extra information about NODisctinct since i have never used this yet.

Re: RangeSum on different column

sunny_talwar — Tue, 13 Dec 2016 16:23:45 GMT

Its a pretty handy thing, but I would try to avoid its use to bare minimum. In this case, I can't think of another way to do it and that's why I had to propose this solution