topic Re: Cumulative sum graph in QlikView

Cumulative sum graph

Wed, 25 Nov 2020 16:16:04 GMT

Dear community,

I want to create a graph where I am showing weeks along the bottom, then the expression is a sum of all field values where the date is less than the week being shown (for all data).

The complication is, I only want to show data for the previous 13 weeks - but the sum needs to include all previous weeks...

Current expression is:

=sum(if(collectdate<=Variable AND Category='Stock Value',tlNetValueCalculated))

Hopefully this makes sense.

Best regards,

Drew

Re: Cumulative sum graph

tracysmart — Fri, 04 Nov 2016 15:29:24 GMT

Hi Drew

You are probably going to have to use rangesum and the above function here.

so something like rangesum(above(yourexpression),1, rowno())

You might also need to use the aggr function to calculate over the whole Week dimension.

if you can send an example app it would be easier to help

Re: Cumulative sum graph

Frank_Hartmann — Fri, 04 Nov 2016 16:43:32 GMT

have a look at the attached sample.

hope this helps

--Edited--