Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

kiranb13
New Contributor II

Cumulative sum expression

Hello Qlik Community,

Cummulative.PNGExpression

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 ? 

5 Replies
Frank_Hartmann
Honored Contributor

Re: Cumulative sum expression

can u share a sample qvw ? Or Excel?

 

Unbenannt.png

kiranb13
New Contributor II

Re: Cumulative sum expression

Cummulative.PNG

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()))

kiranb13
New Contributor II

Re: Cumulative sum expression

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())))

Highlighted
Frank_Hartmann
Honored Contributor

Re: Cumulative sum expression

try this:

 

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

kiranb13
New Contributor II

Re: Cumulative sum expression

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]))

 

 

Date range.PNGMonthly.PNGWeekly.PNG