Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to get aging per day?

Hi,

May I ask what function or syntax that be used in getting the aging of an invoice. Can someone give me an example?

Thank you

- Ahyel

14 Replies

Re: How to get aging per day?

May be

Age([Invoice Date], Today())

Not applicable

Re: How to get aging per day?

Hi Aheyl,

Age function can be used.

This might be of help:

Re: Age Field

Not applicable

Re: How to get aging per day?

Hi Manish,

Thanks for this.. Just a clarification, do you mean the date TODAY? or will I use today as it is?

My apologies as I havent got any trainings for this yet,

Thank you so much

- AHyel

MVP
MVP

Re: How to get aging per day?

Today() is a qv function that returns current day date. However, if you want to calculate the age in no. of days, you should rather use expression like: =Today() - [Invoice Date] rather than age() which gives you completed years.

sunilkumarqv
Valued Contributor II

Re: Re: How to get aging per day?

Hi Ahyel,

See attached....

Re: How to get aging per day?

If you want to find out number of Days, use as below..

=Interval(Today()-Date,'DD')

Not applicable

Re: How to get aging per day?

Okay, got it. But is it possible that if i make this syntax

Today()-Date#([Request Date],'DD.MM.YYYY') as Aging

the result in the X- axis will be numbers, right? How will i make it like for example, 1 = 1 day the 2 = 2 days.. Something like that..

Thank you so much

- Ahyel

MVP
MVP

Re: How to get aging per day?

Hi,


Try like this


Today()-Date#([Request Date],'DD.MM.YYYY') & ' Days' as Aging


Regards,

Jagan.

MVP
MVP

Re: How to get aging per day?

Try like:

Today()-Date#([Request Date],'DD.MM.YYYY') &

          (If (Today()-Date#([Request Date],'DD.MM.YYYY')>1, 'Days', 'Day') as Aging

Community Browser