Discussion board where members can get started with QlikView.
Is it possible in QlikView to calculate a patient's age in years at the time of hospital admission?
I need help with the expression using the 2 dates: DOB and Admission_date_time.
Is this done in a list box or table?
I'm working on my very first QlikView project and seem to be stumped.
Thank you, Sue
you have to provide more inof.
e.g. how may data tables are you using?
You can use age function to calculate age in years.
Syntax: age(Admission_date_time, DOB)
It depends on the way you would like to report this value in the Dashboard i.e. as a list box or in chart.
Hope it helps..
You can use the following expr to calculate age
year(Date_of_Admission) - year(DOB)
See attached file
its better to use the age () function as suggested by Narasimha.
Thank you for your help. I used year(Date_of_Admission) - year(DOB) in my data script.
other way is:
timestamp(Date(Date_of_Admission) - Date(DOB), 'Y')