Discussion Board for collaboration related to QlikView App Development.
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,
May be this?
=Aggr(NODISTINCT RangeSum(Above(CalculatedField, 0, RowNo())), Rank)
View solution in original post
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
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.
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