topic Re: cumulative sum in QlikView

cumulative sum

Mon, 06 Jul 2015 06:50:19 GMT

Hi,

i want to do a cumulative sum by month but i don't know how to do this,

i try the rangesum function but it dont work...

The CA field is this expression : Sum({$<[LVR.Date d_expédition]={">=$(vStartDate)<=$(vEndDate)"}>}LVR.Montant)/1000

How can i do this? Thanks a lot !!

Re: cumulative sum

er_mohit — Mon, 06 Jul 2015 07:03:31 GMT

Hi try this

Rangesum(Above(Sum({$<[LVR.Date d_expédition]={">=$(vStartDate)<=$(vEndDate)"}>}LVR.Montant),1,rowno(Total)))/1000

or try this

Rangesum(Above(Sum(LVR.Montant),1,rowno(Total)))/1000

Re: cumulative sum

Mon, 06 Jul 2015 07:09:10 GMT

Hi ! Thanks for your speed answer but the twice function that you give me made "0" everywhere...

Re: cumulative sum

Mon, 06 Jul 2015 07:24:13 GMT

Hi I am attaching QVW ..this might help u..

sample data..sample screen shot..

Re: cumulative sum

Mon, 06 Jul 2015 07:33:17 GMT

Thanks a lot Narendra .. but

So i try this :

Rangesum(Above(Sum({$<[LVR.Date d_expédition]={">=$(vStartDate)<=$(vEndDate)"}>}LVR.Montant),0,rowno()))/1000

as you can see that don't give me cumulative

I try Rangesum(Above(Sum(LVR.Montant),0,rowno()))/1000 but it doesen't work too

Re: cumulative sum

Kushal_Chawda — Mon, 06 Jul 2015 07:40:36 GMT

try ,

=RangeSum(above( Sum({$<[LVR.Date d_expédition]={">=$(vStartDate)<=$(vEndDate)"}>}LVR.Montant)/1000,1, RowNo()),

Sum({$<[LVR.Date d_expédition]={">=$(vStartDate)<=$(vEndDate)"}>}LVR.Montant)/1000,

)

Re: cumulative sum

Mon, 06 Jul 2015 07:43:09 GMT

Hi, the same result like before

thanks a lot

Re: cumulative sum

Kushal_Chawda — Mon, 06 Jul 2015 07:55:32 GMT

Please post your sample app

Re: cumulative sum

Kushal_Chawda — Mon, 06 Jul 2015 07:57:07 GMT

have you tried the expression which I suggested? what values you are getting using that?

Re: cumulative sum

Mon, 06 Jul 2015 08:06:04 GMT

Oh that works sorry i tried your expression and that seem to be ok

thanks a lot KUSH !! So much!!

Re: cumulative sum

jonathandienst — Mon, 06 Jul 2015 08:10:19 GMT

You need a total in Above as well and 0 as the starting index to include the current row in the cumulative value:

=Rangesum(Above(Total Sum({$<[LVR.Date d_expédition] = {">=$(vStartDate)<=$(vEndDate)"}>} LVR.Montant), 0, rowno(Total))) / 1000