topic Re: Working out age using months and years in QlikView

Working out age using months and years

Thu, 07 May 2015 11:36:23 GMT

Hi,

I am trying to calculate a persion age using 3 different fields, taking the Date of Birth and the Start date calculating the age and then adding the duration to find out the age at expiry. Taking the example below this person would be 69 years 7 months. I am having problems with the duration part of this. I am looking to do this at the loader stage.

Start Date 25/02/2015

Date of Birth 31/01/1969

Duration 36 months

Answer 69.07

Any help would be great.

Re: Working out age using months and years

rubenmarin — Thu, 07 May 2015 11:47:27 GMT

Hi Marie, if I use:

=Date(AddMonths('25/02/2015', 36)- date('31/01/1969'), 'YY.MM')

Returns 49.01, 46.01 is the difference and adding the 36 months gives 49.01, how should be the calculations to return 69.07, can you explain step by step?

Re: Working out age using months and years

Thu, 07 May 2015 13:02:06 GMT

Thanks Ruben, the correct answer is 49.01 for the example

Re: Working out age using months and years

sunilkumarqv — Thu, 07 May 2015 13:07:21 GMT

Check the result in attached

give your feedback so we can work on that@

Re: Working out age using months and years

Thu, 07 May 2015 14:38:03 GMT

Thanks Sunil, I have looked at this in this instance the Ager would show as 46.01.

Re: Working out age using months and years

Thu, 07 May 2015 14:45:09 GMT

Thanks everyone, this has been answered on another thread.