Discussion board where members can get started with Qlik Sense.
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.
Go to Solution.
I think the most simplistic calculation could be this:
round( (JoiningDate - BirthDate)/365 )
Upgrade your Qlik skills at the Masters Summit for Qlik - coming to Boston, MA this October!
Maybe using the Age() function?
age - script and chart function ‒ Qlik Sense