Calculate rolling Sum of AR amount and overdues.

[akash_durai1507]

I'm building Qliksense reports for Accounts receivable finance data.

To achieve rolling sum of amounts,

I've created a As-Of table using IntervalMatch function.
The rolling sum works completely fine.

But while calculating the amount along with other filters, the results are not as expected.
My data model looks like this,
https://imgbox.com/tLrX5S8S

My script to create As-Of Table looks like below,
https://imgbox.com/qwhbZkl2

The exact case where I'm facing issues is that while calculating overdues, there are multiple conditions required so i created an expression as below,

Sum({<GLaccountCode={'121001','117000'}>}If(NetDueDate<=YearEnd([Report Date]) and Arrears>0 and [Clearing Date]>YearEnd([Report Date]),ARAmountLC))

Using Month as key for As-Of calendar table provides the expected results.
But when changed to Report Date as key, numbers are wrong.

Please help! TIA!

[pablolabbe]

Probably you need to combine this solution with canonical calendar table Check this post about it https://community.qlik.com/t5/Design/Canonical-Date/ba-p/1463578