Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

How to arrange an Age analyst of Debtors

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

1 Solution

Accepted Solutions
Highlighted
Master
Master

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

View solution in original post

2 Replies
Highlighted
Master II
Master II

Highlighted
Master
Master

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

View solution in original post