Set analysis for AR Aging

[#1]

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

[MK_QSL]

SUM({<OverDue = {"<=0"}>}BlahBlah)

[#3]

Same result

[MK_QSL]

Provide sample data please...

or try

Interval(Today() - DueDate,'D') as OverDue

[sunny_talwar]

Qlikview is case sensetive, it is Overdue or OverDue?

[#6]

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)

[sunny_talwar · Accepted solution]

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)

[#8]

That makes too much common sense!   Thanks for the help!

[sunny_talwar]

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