Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

vchuprina
New Contributor II

Open Receivables and Receivables Age

Hi,

Did someone done such scenario:

Open Receivables is defined as invoiced Sales less any payments. Open receivables

does not trend over time as it is a point in time metric and only exists at the moment

it is calculated. Open receivables should be displayed in 30-brackets depending upon

how old the receivable is. Any receivable less than one day old is considered current

and current is a bucket that must be displayed. The BILL and AMTPAID field

should be used for this metric.

I have a table with billing table and want to calculate open receivables, but didn't understand how I can do this and wich formula I should use

MEDNOACCTNUMINVOICEBILLDATEAMTPAID
14627AA5555216511/6/19960
20514AA568971301/2/19970
29102AA569701551/6/19970
23955AA9700500553/18/19970
2 Replies
Not applicable

Re: Open Receivables and Receivables Age

Same issue.. Any Luck?

vchuprina
New Contributor II

Re: Open Receivables and Receivables Age

Hi Muhamed,

Yes, I solved this problem.