topic Re: Why is my age function not working? in QlikView

Why is my age function not working?

Tue, 12 Aug 2014 14:00:23 GMT

Hi all,

New enought to QV but I am trying to use the age functio to as per below but I am getting nothing in return, nay ideas why?

AGE('01/sep/2014',IND_BIRTH_DT)/12 as age_at_sep14

Thanks,

Aidan

Re: Why is my age function not working?

marcus_sommer — Tue, 12 Aug 2014 14:08:08 GMT

It seems that your values within the age() won't be recognize as date-values. For this you could use date, date# or num, num# to format/convert your values.

- Marcus

Re: Why is my age function not working?

Tue, 12 Aug 2014 14:12:57 GMT

Try putting the date as 2014-09-01 format. so the expresssion would be as follows:

AGE('2014-09-01',IND_BIRTH_DT)/12 as age_at_sep14

Re: Why is my age function not working?

Tue, 12 Aug 2014 14:53:55 GMT

Hi,

Thanks but unfortunately this has not worked for me

Here is a few more things I have tried;

AGE(num#('01/aug/2014'),num#(IND_BIRTH_DT))/12 as age_at_aug14,
AGE(date(('01/sep/2014')),date(IND_BIRTH_DT))/12 as age_at_sep14,
AGE('2014-10-01',(IND_BIRTH_DT)/12) as age_at_oct14

Cheers,

Aidan

Re: Why is my age function not working?

Tue, 12 Aug 2014 14:54:05 GMT

AGE(num#('01/aug/2014'),num#(IND_BIRTH_DT))/12 as age_at_aug14,
AGE(date(('01/sep/2014')),date(IND_BIRTH_DT))/12 as age_at_sep14,
AGE('2014-10-01',(IND_BIRTH_DT)/12) as age_at_oct14

Re: Why is my age function not working?

sebastiandperei — Tue, 12 Aug 2014 15:52:24 GMT

Hi. I don't know what you have in IND_BIRTH_DT, also, i don't know which one is your date standard format....

So, you can try with:

Age ( Date(Makedate(2014,09,01)), Date(Date#(IND_BIRTH_DT)))

To test this before do reload, select a value in IND_BIRTH_DT and put the above function in a TextBox. It should return the number of years. The most important is the format of IND_BIRTH_DT field. If the last doesn't work, please, go to tables (Ctrl+T), right click on the table that contents this fields, and tell us exactly the format of the values in the field, and if it is right of left arranged.

Also, AGE() will return an integer with the number of years. About the "/12" of your function, i guess you need the number of months. For do that, tell us how much months you need to show between these dates:

20/Jan/2014 - 15/Apr/2014: 2 or 3 months?

Re: Why is my age function not working?

datagrrl — Tue, 12 Aug 2014 16:07:46 GMT

Okay, I am new at this, so maybe I overdid it, but this worked for me:

AGE(DATE(DATE#('01/sep/2014','DD/MMM/YYYY'),'MM/DD/YYYY'),DATE(IND_BIRTH_DT,'MM/DD/YYYY'))

As for the /12 I am not sure what you are trying to get here. It would be one for every 12 years. If you want rough months you could do *12.

It could be some internal measure I don't understand, if so you should be able to tack it onto the above.

Re: Why is my age function not working?

Wed, 13 Aug 2014 07:47:50 GMT

The below worked when removed the /12, it was something I carried over from SQL

Thanks for all replies

AGE('2014-10-01',IND_BIRTH_DT) as age_at_oct14,