topic Re: Cumulative sum expression in QlikView

Cumulative sum expression

kiranb13 — Wed, 25 Nov 2020 16:16:04 GMT

Hello Qlik Community,

I Expression

I have got the value as 12.65 for the expression -

=(Sum (EST_Automate_TC)+Sum (EST_Manual_TC))/(networkdays([Analysis end Date Planned],[Test Completion date]))

I need the to add cummulative sum function for the above expression.

Any idea for the above mentioned expression ?

Re: Cumulative sum expression

Frank_Hartmann — Wed, 13 Feb 2019 10:34:06 GMT

can u share a sample qvw ? Or Excel?

Re: Cumulative sum expression

kiranb13 — Wed, 13 Feb 2019 10:56:05 GMT

Hi Frank,

In the above chart total number of TC's (Sum (EST_Automate_TC)+Sum (EST_Manual_TC)) is 632 shown in green line.

I need to divide 632 by number of days i.e given by Data range. - (networkdays([Analysis end Date Planned],[Test Completion date]))

So i have used the expression --> =(Sum (EST_Automate_TC)+Sum (EST_Manual_TC))/(networkdays([Analysis end Date Planned],[Test Completion date])) i.e 632/50 i got the value as 12.65.

i need to show the cumulative value for the above expression.

I have used the below expression for cummulative expression. I need total cummulative sum. Can you please help me in altering the below expression by adding sum of sum in rangesum function.

RangeSum(Above((Sum (EST_Automate_TC)+Sum (EST_Manual_TC))/(networkdays([Analysis end Date Planned],[Test Completion date])), 0, RowNo()))

Re: Cumulative sum expression

kiranb13 — Wed, 13 Feb 2019 13:09:44 GMT

I need to put this expression in rangesum function

(Sum (EST_Automate_TC)+Sum (EST_Manual_TC))/(networkdays([Analysis end Date Planned],[Test Completion date]))

PFB,

I am getting error for the below expression.

Can anyone help me in correcting the below expression.

RangeSum(Above(Sum((Sum (EST_Automate_TC)+Sum (EST_Manual_TC))/(networkdays([Analysis end Date Planned],[Test Completion date])), 0, RowNo())))

Re: Cumulative sum expression

Frank_Hartmann — Wed, 13 Feb 2019 14:05:37 GMT

try this:

RangeSum(Above(Sum (EST_Automate_TC)+Sum (EST_Manual_TC))/(networkdays([Analysis end Date Planned],[Test Completion date])), 0, RowNo()))

Re: Cumulative sum expression

kiranb13 — Wed, 13 Feb 2019 14:16:03 GMT

Hi Frank,

I have tried the above expression earlier. It gives the data for the date range but when i select weekly in cyclic group wrong data is appearing. The above expression is not flexible when i change the dimensions in cyclic group.

This is my expression. I want to sum the result from the below expression with rangesum function.

(Sum (EST_Automate_TC)+Sum (EST_Manual_TC))/(networkdays([Analysis end Date Planned],[Test Completion date]))