Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlik Community,
I
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 ?
can u share a sample qvw ? Or Excel?
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()))
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())))
try this:
RangeSum(Above(Sum (EST_Automate_TC)+Sum (EST_Manual_TC))/(networkdays([Analysis end Date Planned],[Test Completion date])), 0, RowNo()))
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]))