topic Re: Cumulative Percentages in a Chart in QlikView

Cumulative Percentages in a Chart

Wed, 02 Dec 2015 13:34:38 GMT

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.

Re: Cumulative Percentages in a Chart

Gysbert_Wassenaar — Wed, 02 Dec 2015 18:16:13 GMT

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.