Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create an AR Aging but it does not seem to be working
First I calculate if the invoice is current or overdue. Then I try and do set analysis based on the calculation
Overdue = vToday - DueDate //results in a number
Aging
Current
sum({<[OverDue] = {"<=$(=0)"} >} ARMaster.ARBalance)
This results in everything adding even of [Overdue] is greater than zero
Not sure what syntax to use for my next buckets 31-60, 61-90, over 90
Try these:
Current: sum( {< Overdue = {"<=0"} >} ARBalance)
1-30: sum( {< Overdue = {">=1<=30"} >} ARBalance)
31-60 sum( {< Overdue = {">=31<=60"} >} ARBalance)
61-90 sum( {< Overdue = {">=61<=90"} >} ARBalance)
Over90 sum( {< Overdue = {">=91"} >} ARBalance)
SUM({<OverDue = {"<=0"}>}BlahBlah)
Same result
Provide sample data please...
or try
Interval(Today() - DueDate,'D') as OverDue
Qlikview is case sensetive, it is Overdue or OverDue?
It wasn't wanting to calculate overdue on the fly and then apply to set analysis. I tried a couple different ways and finally just put into my LOAD script today()-DueDate as Overdue
Now in my set analysis it is picking up Overdue properly and summing as a set for Current and Over90 but not for the in between. I see my problem, just not sure how to modify it yet.
Current: sum( {< Overdue = {"<=0"} >} ARBalance)
1-30: sum( {< Overdue = {">=1","<=30"} >} ARBalance)
31-60 sum( {< Overdue = {">=31","<=60"} >} ARBalance)
61-90 sum( {< Overdue = {">=61","<=90"} >} ARBalance)
Over90 sum( {< Overdue = {">=90"} >} ARBalance)
Try these:
Current: sum( {< Overdue = {"<=0"} >} ARBalance)
1-30: sum( {< Overdue = {">=1<=30"} >} ARBalance)
31-60 sum( {< Overdue = {">=31<=60"} >} ARBalance)
61-90 sum( {< Overdue = {">=61<=90"} >} ARBalance)
Over90 sum( {< Overdue = {">=91"} >} ARBalance)
That makes too much common sense! Thanks for the help!
No problem
I am glad we were able to help.
Best,
Sunny
P.S. Just so you know, you don't have to change the correct answers around, you can always reward people by marking the answers as helpful answers