Accounts Receivable Aging

Thu, 15 May 2014 19:56:03 GMT

Hi,

Can anyone please help me to figure out how to calculate accounts receivable aging using set analysis?

I am using the following syntax but it is not working.

=Sum({<isAccountInvoiced={'1'},rDate = {">=$(=Date(max(rDate)-121)<=$(=Date(max(rDate)-150)"} >}Sales - Costs)

where

isAccountInvoiced={'1'} - selects all accounts invoiced (all accounts invoiced have a value of 1)

rDate - is the date MM/DD/YYYY

rDate = {">=$(=Date(max(rDate)-121)<=$(=Date(max(rDate)-150)"} - syntax used for accounts receivable age between 121-150 days

Thank you

Re: Accounts Receivable Aging

Thu, 15 May 2014 21:42:24 GMT

Hello,

for me it looks, like you open 3 brackets, but close only two in rDate boudaries definition.

Put your expression into straight table and give no label. Then on the label field you will see, how expression is evaluated. If it is ok, i expect you should have two dates in this part.\\

regards

Darek

topic Accounts Receivable Aging in QlikView

Accounts Receivable Aging

Re: Accounts Receivable Aging