topic Non Ordered Running Sum in QlikView

Non Ordered Running Sum

Tue, 28 Jan 2014 18:47:48 GMT

Hey everyone. I need some help.

I need to sum all of the values in my chart that are larger then the current value. This is kind of like a running sum, but the values are not in order so i cant do a running sum. I was trying something like this, but it does work: sum(total aggr(if(sum([New Policy Count])>[New Policy Count], sum([New Policy Count]),0),MainProducer)).

Here is an example of what i am looking for:

ID	NewCount	Desired Result	Calculation
001IL	5	62	5+12+18+27
002IL	12	57	12+18+27
001IN	1	64	1+1+5+12+18+27
002IN	1	64	1+1+5+12+18+27
001OH	27	27	27
002OH	18	45	18+27

Re: Non Ordered Running Sum

Tue, 28 Jan 2014 19:56:32 GMT

Hey Micah,

Please check out the attached file. I did the calculation on the back-end and created a field called NewValue which would give you the values you are looking for.

Hope it helps you

Thanks

Re: Non Ordered Running Sum

Wed, 29 Jan 2014 15:30:46 GMT

There are a few ways that i can pre-calculate this, what i am looking for is a way to do it in an expression in my chart.