Accumlation without NULL

Yuhka — Sat, 16 Nov 2024 01:50:31 GMT

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!

Re: Accumlation without NULL

Brett_Bleess — Mon, 09 Dec 2019 22:48:54 GMT

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

topic Accumlation without NULL in QlikView

Accumlation without NULL

Re: Accumlation without NULL