topic Re: Converting DOB to Age Range in QlikView

Converting DOB to Age Range

Tue, 23 Dec 2014 01:39:27 GMT

I have Date of Birth as dd mmm yyyy format in Excel. Appreciate if you could let me know how to convert the DOB to different Age Ranges like;

Age (20 - 30)

Age (31- 40)

Age (41 - 50)

Age (51 - 60)

Age (61 - 70)

Age (71 - 80)

Thanks

Re: Converting DOB to Age Range

sushil353 — Tue, 23 Dec 2014 04:43:51 GMT

Hi,

this is how you can do:

agegroup:
LOAD * Inline
[
Agemin,Agemax,group
0,5,0-5
5,10,5-10
10,18,10-18
];
age:
LOAD (now()-DOB)/365 as Age,* Inline
[
DOB,Name
12/28/2013,Pranya
09/05/2000, Ram
];
IntervalMatch (Age) LOAD Agemin, Agemax Resident agegroup;

HTH

sushil

Re: Converting DOB to Age Range

MarcoWedel — Tue, 23 Dec 2014 07:04:35 GMT

Class(Age(today(), DOB),10)

Re: Converting DOB to Age Range

MarcoWedel — Tue, 23 Dec 2014 09:22:59 GMT

Dual('Age ('&Replace(Class(Age(today(), DOB),10),'<= x <','-')&')',Class(Age(today(), DOB),10))

Re: Converting DOB to Age Range

MarcoWedel — Tue, 23 Dec 2014 09:25:46 GMT

LOAD *,
    Age(today(), DOB) as Age,
    Dual('Age ('&Replace(Class(Age(today(), DOB),10),'<= x <','-')&')',Class(Age(today(), DOB),10)) as AgeRange;
LOAD Date(Today()-Ceil(Rand()*35000)) as DOB
AutoGenerate 300;

hope this helps

regards

Marco

Re: Converting DOB to Age Range

Tue, 23 Dec 2014 17:34:43 GMT

by using class function.

Re: Converting DOB to Age Range

Wed, 24 Dec 2014 00:19:25 GMT

Thanks for that. Appreciate if you could explain ,

LOAD *,
Age(today(), DOB) as Age,
Dual('Age ('&Replace(Class(Age(today(), DOB),10),'<= x <','-')&')',Class(Age(today(), DOB),10)) as AgeRange;
LOAD Date(Today()-Ceil(Rand()*35000)) as DOB
AutoGenerate 300;

what these do, as I am new to Qlikview.

I also tried to edit my script using the above, but did not work. There is an error in the script. In fact I want to get a Chart "No. of Incidents By Age Range". I also attached the QVW. Appreciate your help.

Thanks for your help