Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
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!
Maybe using the Age() function?