topic Re: Generate Date to age groups in QlikView

Generate Date to age groups

Anonymous — Sat, 26 Dec 2015 21:52:57 GMT

I have [dateOfBirth] for patinets and i want to make group for them per ages

for example:

Age Group

00-15

16-31

32-47

47+

Regards,

Sat, 26 Dec 2015 22:00:17 GMT

Using Today ( function) you can calculate the years of patinets . Through nested if we can establish groups . Regards.

sunny_talwar — Sat, 26 Dec 2015 22:14:16 GMT

Do you have a sample you can share?

Sat, 26 Dec 2015 22:23:32 GMT

!Good evening, .qvw Attach a file. It can be seen as the deudaV2 , deudaV3 eyelashes ... I falsify dates . Regards.

Anonymous — Sat, 26 Dec 2015 23:06:45 GMT

Check the attachment please for clear example

Regards,

Anonymous — Sat, 26 Dec 2015 23:07:13 GMT

Check the last comment please.

Regards,

sunny_talwar — Sat, 26 Dec 2015 23:20:51 GMT

May be this expression in list box:

=Aggr(If(Age(today(), Only({1}dateOfBirth)) < 16, Dual('0-15', 1),

If(Age(today(), Only({1}dateOfBirth)) < 32, Dual('16-31', 2),

If(Age(today(), Only({1}dateOfBirth)) < 48, Dual('32-47', 3), Dual('47+', 4)))), dateOfBirth)