topic Re: Age() Function not working in qliksense. Can anyone help on this ? in App Development

Age() Function not working in qliksense. Can anyone help on this ?

anilet123 — Mon, 05 Feb 2018 13:52:09 GMT

Age() Function not working in qliksense. Can anyone help on this ?

Re: Age() Function not working in qliksense. Can anyone help on this ?

jerryyang756 — Mon, 05 Feb 2018 15:20:02 GMT

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

=AGE('12/12/2013','06/07/1989')

here is my output

Re: Age() Function not working in qliksense. Can anyone help on this ?

anilet123 — Tue, 06 Feb 2018 06:23:04 GMT

Hi Pritam,

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.

Regards,

Anilet Nirmal

Re: Age() Function not working in qliksense. Can anyone help on this ?

pradosh_thakur — Tue, 06 Feb 2018 07:19:05 GMT

what are the date format in both the date ? any sample you can provide?

Re: Age() Function not working in qliksense. Can anyone help on this ?

anilet123 — Wed, 07 Feb 2018 06:16:06 GMT

Please find the data exported from qliksense chart. Date format is 'M/D/YYYY'.

Function used is Age(Collection_Date,Bill_Date)

Re: Age() Function not working in qliksense. Can anyone help on this ?

jonathandienst — Wed, 07 Feb 2018 07:15:06 GMT

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')

Re: Age() Function not working in qliksense. Can anyone help on this ?

anilet123 — Wed, 07 Feb 2018 07:21:03 GMT

An eye opener .. Thank you Jonathan.

I assumed its a bug in QlikSense. I was wrong.

Regards,

Anilet Nirmal