Calculate No. of Year between 2 dates(QlikSense)

[#1]

Hi All,

I have one filed as "JoiningDate" and other as " BirthDate". I want to calculate "Age" i.e difference between 2 dates in no. of years  for each record and then need to calculate Avg Age.

How can I do this either in Load Script or in directly chart function. Please help. thanks.

[Oleg_Troyansky · Accepted solution]

I think the most simplistic calculation could be this:

round( (JoiningDate - BirthDate)/365 )

Cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming to Boston, MA this October!

[swuehl]

Maybe using the Age() function?

age - script and chart function ‒ Qlik Sense