topic Re: How to get aging per day? in QlikView

How to get aging per day?

Mon, 10 Mar 2014 07:44:04 GMT

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

Re: How to get aging per day?

MK_QSL — Mon, 10 Mar 2014 07:50:30 GMT

May be

Age([Invoice Date], Today())

Re: How to get aging per day?

Mon, 10 Mar 2014 07:52:13 GMT

Hi Aheyl,

Age function can be used.

This might be of help:

Re: Age Field

Re: How to get aging per day?

Mon, 10 Mar 2014 08:49:17 GMT

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

Re: How to get aging per day?

tresB — Mon, 10 Mar 2014 08:58:30 GMT

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.

Re: Re: How to get aging per day?

sunilkumarqv — Mon, 10 Mar 2014 09:18:17 GMT

Hi Ahyel,

See attached....

Re: How to get aging per day?

MK_QSL — Mon, 10 Mar 2014 09:26:06 GMT

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

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

Re: How to get aging per day?

Tue, 11 Mar 2014 03:22:38 GMT

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

Re: How to get aging per day?

jagan — Tue, 11 Mar 2014 03:44:16 GMT

Hi,

Try like this

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

Regards,

Jagan.

Re: How to get aging per day?

tresB — Tue, 11 Mar 2014 04:33:18 GMT

Try like:

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

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

Re: How to get aging per day?

SunilChauhan — Tue, 11 Mar 2014 04:43:17 GMT

as date#(Today(),'DD.MM.YYYY') will give you incorrect format so

try this

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

hope this helps

Re: How to get aging per day?

Fri, 14 Mar 2014 11:03:26 GMT

Hi,

Can you help me on this?

How can I get the duration of processing from two dates?

From PR Approved date to PO creation date including the weekend?

Thanks a lot!!

Regards,

Ahyel

Re: How to get aging per day?

SunilChauhan — Fri, 14 Mar 2014 11:07:39 GMT

[PR Approve Date]- [PO Creation date] as fieldname

Interval(PR Aprove date],[Po creation date],'DD') as Field

use expressions provided directly in Expression

hope this make sense

Re: How to get aging per day?

Fri, 14 Mar 2014 11:09:26 GMT

Hi Jagan,

can you help me on this?

How can I get the duration of processing from two dates?

From PR Approved date to PO creation date including the weekend?

Thanks a lot!!

Regards,

Ahyel

Re: How to get aging per day?

jagan — Fri, 14 Mar 2014 11:32:21 GMT

Hi,

Try like this

LOAD

Interval([PR Approved date] - [PO creation date], 'MM/DD/YYYY hh:mm:ss') AS Duration

FROM DataSource;

Regards,

Jagan.