Accumlation without NULL

[Yuhka]

Hello qlikers, I need some help for my accumlation chart.

I have a sorce data which has fields : No., Category, ReceptionDate, CloseDate and Rank.

I made a straight table which calculates monthly numbers of cases, accumulation cases, and Remaining Cases of each Rank(A,B,C).

For the chart monthly ascending order, I use an expression as follows to calculate Remaining cases of each Rank.

RangeSum(Above(Sum({<%Rank={A}>}%ReceptionFlag),0,RowNo()))-RangeSum(Above(Sum({<%Rank={A}>}%CloseFlag),0,RowNo()))

For the chart monthly descending order, I use an expression as follows.

Aggr(RangeSum(Above(Sum({<%Rank={A}>}%ReceptionFlag), 0, RowNo())), (%Date, NUMERIC))-Aggr(RangeSum(Above(Sum({<%Rank={A}>}%CloseFlag), 0, RowNo())), (%Date, NUMERIC))

 However, in case to use the expressions as above, NULL is shown in the descending chart.

How can I avoid this issue?

Thank you for your support!

[Brett_Bleess]

Only thing I have to try to help is the following Design Blog post:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Above-Function/ba-p/1465357

Might get you what you need to figure things out.

Regards,
Brett