Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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