How to arrange an Age analyst of Debtors

[nevilledhamsiri]

Hi,

Please be good enough to explain me as to how an age analyst is arranged as per the given data below. As at 25th August age of each Debtor is mentioned. This age to be arranged in classes such as

0-30

30-60

60-90

90-120

>120

etc,

Appreciate if our experts  elaborate on this & explain how this could be done with possible expressions.Also if possible explain if the risk date is given how we could calculated number of dates as at given date.

Hence I expect two answers here!

(1) how to calculate number of dates or each Debtor say as at 31st August 2017

(2) Arrange that calculated dates in a class such as one given above .(0-30, 30-60 bla bla bla)

Thank you

Neville

[devarasu07]

Hi,

Try to use age bucketing, check below article

https://community.qlik.com/blogs/qlikviewdesignblog/2014/07/14/buckets

https://community.qlik.com/thread/119623

[effinty2112 · Accepted solution]

Hi Neville,

I don't know what you mean by

(1) how to calculate number of dates or each Debtor say as at 31st August 2017

can you advise?

Devarasu gave you good advice that is worth checking out. The only problem with the class function is that you are restricted to having classes of a single size so in general you won't have a single class for Age >90. Records falling into this category would be classed as perhaps many different 30 day periods.

Here is an approach you can use in script or the UI.

Work out the age using an expression like Age = Floor(Today() - TRN_DATE). Suggest doing this in script is best.

For age classes try something like

AgeClass=

Pick(

Match(-1, Age <=30, Age <= 60, Age <= 90, Age <= 120, -1)

'0-30'

'31-60'

'61-90'

'91-120'

'>120')

Good luck

Andrew