topic Re: Age to be calculated to the nearest Month in QlikView

Age to be calculated to the nearest Month

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

Dear Members,

Once Age table is created, ages in Months are getting zeros, how this will be made to nearest Month such as 0.3,0.4 etc.

Thanks

Neville

nevilledhamsiri — Sun, 27 Oct 2019 03:48:23 GMT

Anil_Babu_Samineni — Sun, 27 Oct 2019 09:02:16 GMT

Perhaps like this?

=If(Age(Today(), DATE_JOINED)>1, Age(Today(), DATE_JOINED), Month(Today())-Month(Date(DATE_JOINED)))

Or, Self satisfaction 🙂

=If(Age(Today(), DATE_JOINED)>1, Age(Today(), DATE_JOINED) & ' Years', (Month(Today())-Month(Date(DATE_JOINED)) & ' Months'))

Image for Ref :

nevilledhamsiri — Sun, 27 Oct 2019 09:02:58 GMT

Could you please please send me the formula I cannot open up the qvd

Thanks

Neville

Anil_Babu_Samineni — Sun, 27 Oct 2019 09:05:27 GMT

It is there in the body message 🙂

nevilledhamsiri — Sun, 27 Oct 2019 09:23:29 GMT

Dear Anil,

I added some more records with 2018 , then the calculation seems to be some what wrong only for those who joined 2018.

Could you please look in to this

Neville

Anil_Babu_Samineni — Sun, 27 Oct 2019 10:15:52 GMT

Can'y you simply this, Instead AGE()?

=(Year(Today())-Year(Date(DATE_JOINED)) & ' Years') & ' ' & (Month(Today())-Month(Date(DATE_JOINED))) & ' Months'

nevilledhamsiri — Sun, 27 Oct 2019 14:05:43 GMT

Thanks Anil,

This is ok now.

Neville