topic Re: Set analysis for AR Aging in QlikView

Set analysis for AR Aging

Thu, 09 Jul 2015 18:10:05 GMT

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

Re: Set analysis for AR Aging

MK_QSL — Thu, 09 Jul 2015 18:11:01 GMT

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

Re: Set analysis for AR Aging

Thu, 09 Jul 2015 18:17:09 GMT

Same result

Re: Set analysis for AR Aging

MK_QSL — Thu, 09 Jul 2015 18:25:10 GMT

Provide sample data please...

or try

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

Re: Set analysis for AR Aging

sunny_talwar — Thu, 09 Jul 2015 18:36:45 GMT

Qlikview is case sensetive, it is Overdue or OverDue?

Re: Set analysis for AR Aging

Thu, 09 Jul 2015 20:15:56 GMT

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)

Re: Set analysis for AR Aging

sunny_talwar — Thu, 09 Jul 2015 20:19:10 GMT

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)

Re: Set analysis for AR Aging

Thu, 09 Jul 2015 20:30:26 GMT

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

Re: Set analysis for AR Aging

sunny_talwar — Thu, 09 Jul 2015 20:33:28 GMT

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