topic Re: Calculate cumulative value in expression in QlikView

Calculate cumulative value in expression

Thu, 12 Nov 2015 10:41:05 GMT

Hi,

I need to calculate a value like "= sum(x) / cumulative sum of y"

I can only find cumulative expression based on "above()" function, which doesn't work in this case. I also tried invisible helper column, but this messes up the axes scaling.

What would be the best approach to solve this?

Re: Calculate cumulative value in expression

Anonymous — Thu, 12 Nov 2015 10:57:02 GMT

Go through following threads:

Accumulative Sums

Cumulative sum in Qlikview

accumulative sum?

Accumulative sum for two dimensions

Re: Calculate cumulative value in expression

Kushal_Chawda — Thu, 12 Nov 2015 10:59:15 GMT

It depends on the what data you have & what is the output you need.

Perhaps you need to use Peek & Previous functions to do the cumulative values

see the below links

https://www.qlikcommunity.com/thread/181718

https://www.qlikcommunity.com/thread/138528

Re: Calculate cumulative value in expression

sunny_talwar — Thu, 12 Nov 2015 11:23:40 GMT

May be if you can share a sample, someone here can help you get a better answer.

Re: Calculate cumulative value in expression

Mark_Little — Thu, 12 Nov 2015 14:53:07 GMT

Hi,

Like Kush has mentioned, in a normal case like this i would be looking to add a running total field in my script using the peek and previous functions, but not knowing anything about the data I couldn't say if this would be useful in your case.

So like Sunny has said a sample would be helpful.

Mark

Re: Calculate cumulative value in expression

simotrab — Thu, 12 Nov 2015 15:16:07 GMT

Probably as already said, if you give other informations, it is more simple to help.

Meanwhile I think you can try

Sum(x)/RangeSum(above(Sum(y),0, RowNo()))

Hope it can be useful.

Re: Calculate cumulative value in expression

Fri, 13 Nov 2015 07:16:11 GMT

Turns out I had a pretty simple error in my expression that took a while to spot

Instead of RangeSum(Above(sum(x), 0, RowNo()))

I had RangeSum(Above(sum(x)), 0, RowNo())

The results were different of course, and I only spotted it when working on an example for you.