Discussion board where members can learn more about Qlik Sense App Development and Usage.
Age() Function not working in qliksense. Can anyone help on this ?
Go to Solution.
Age() is the difference in years. The difference between Collection_Date and Bill_Date is less than 1 year, so Age = 0 is correct.
I suspect you are looking for age in days. Just subtract the dates - choose one of the expressions below according to your requirements.
=Collection_Date - Bill_Date
=Interval(Collection_Date - Bill_Date, 'd')
=Floor(Collection_Date - Bill_Date)
=Interval(Floor(Collection_Date - Bill_Date), 'd')
My code is working fine. Try to type it manually .when i copy and pasted from qlik help site example it was not working so i typed it manually and it working fine
here is my output
Thanks for the update. I am using QlikSense desktop version November 2017 Patch 2.
I tried using the function in load script as well as in UI both dint work for me. I do not want to hard code the value instead want to calculate based on fields End_Date and Start_Date.
Age() is a beautiful function in qlikview. I hope Qlik fixes this issue in QlikSense asap.
what are the date format in both the date ? any sample you can provide?
Please find the data exported from qliksense chart. Date format is 'M/D/YYYY'.
Function used is Age(Collection_Date,Bill_Date)
An eye opener .. Thank you Jonathan.
I assumed its a bug in QlikSense. I was wrong.