Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bumin
Partner - Creator II
Partner - Creator II

Aging analysis per month

Hi together,

I want to create an aging analysis

(

  • open items,
  • <30 days due,
  • between 30 and 60 mdays due
  • more than 60 days

)

  for the last rolling 12 months based on a reporting day.

I have created the aging expressions, but I couldn't define the 12 rolling months.

Has anyone did something like this before?

thanks and regards

Bumin

11 Replies
bumin
Partner - Creator II
Partner - Creator II
Author

Kiran,

I want to see only the 12 last months

The report should show the aging as

per last month

per last month -1

per last month -2

...

So each bucket has to show all documents with their aging regarding the period's monthend

regards

Bumin

Not applicable

Bumin,

What I would recommened is in load script create a field called document_ageing which should return Open, <30,<60 ,30-60 etc.

Then you can create this chart with document_ageing, calendar_month and count({<MonthID<={"$(=VL12Months)"}>}document_number). This would be very light and easy to use solution.

Kiran.