topic Age() function in QlikView

Age() function

krishnacbe — Wed, 18 Jul 2012 12:42:39 GMT

I have a date field(ClaimDate). I need to calculate the age of claims. I have acheived it by using below expression.

=TimeStamp(Now()-ClaimDate,'hh:mm')

Can I use Age function in this secenerio?

Re: Age() function

nagaiank — Wed, 18 Jul 2012 12:44:45 GMT

You may use

Interval(Now()-ClaimDate,'hh:mm')

Re: Age() function

krishnacbe — Wed, 18 Jul 2012 12:54:55 GMT

Thanks for your fast reply.

In either cases, my Dashboard is getting refreshed frequently. Dashboard contains more records.

Re: Age() function

Gabriel — Wed, 18 Jul 2012 13:48:04 GMT

Hi Kriamam,

I can't see any reason why you couldn't use Age() function to calculate age of the claim. Please follow this syntax

age(timestamp(Now()),date_of_birth (which in your case it will be CLAIM DATE)) meaning age(now(),claim_date)

Let me know if it works.

Regards,

Gab

Re: Age() function

krishnacbe — Wed, 18 Jul 2012 14:05:39 GMT

Hi gabsus

If I use age(timestamp(Now()),claimdate), I am getting data in list box as -1 and 0. My requirement is to display the age in days/Hours/Minutes.

Thanks in advance.

Re: Age() function

cesaraccardi — Wed, 18 Jul 2012 14:11:31 GMT

Hi,

You cannot use the Age function since it will return only integer values for years. If you just use Now() - claimdate the result will be the difference in days. For hour and minutes you can use krishnamoorthy suggestion.

Regards,

Cesar

Re: Age() function

swuehl — Wed, 18 Jul 2012 14:20:06 GMT

You can use a format code that includes the days, check out the format codes section in the HELP:

=Interval(Now()-ClaimDate,'dd hh:mm')

Re: Age() function

Gabriel — Wed, 18 Jul 2012 14:27:05 GMT

Hi,

In that case what I will do is to use IF(age(now(),claim_date <0, age(now(),-claim_date,age(now(),claim_date)) this should give you right integer format.

Let me know if this is helpful or not

Regards,

Gab