Cumulative Percentages in a Chart

[#1]

Hi,

I'm trying to create a Cumulative Percentages in a Chart.

I have tried the below and it doesnt work.

rangesum(above(count({<[ArriveDate]= {'$(vCurrentDayGB)'}>}[ED_Att_No]))))-(rangesum(above(sum({<[ArriveDate]= {'$(vCurrentDayGB)'}>}[ED_BREACH])))))/(rangesum(above(count({<[ArriveDate]= {'$(vCurrentDayGB)'}>}[ED_Att_No]))))

Thanks.

[Gysbert_Wassenaar · Accepted solution]

Try this:

(rangesum(above(count({<[ArriveDate]= {'$(vCurrentDayGB)'}>}[ED_Att_No] ),0,rowno()))-rangesum(above(sum({<[ArriveDate]= {'$(vCurrentDayGB)'}>}[ED_BREACH]),0,rowno()))) /rangesum(above(count({<[ArriveDate]= {'$(vCurrentDayGB)'}>}[ED_Att_No]),0,rowno()))

If that doesn't work, please post a small qlikview document that demonstrates the problem.