topic Re: Age and Age Range in QlikView

Age and Age Range

Anonymous — Mon, 25 Jun 2018 12:14:49 GMT

Hello guys,

I have this problem that i should create Age and Age Range in script so i add it like:

Age(Today(), date_of_birth) as Age,

If(Age(Today(), date_of_birth) <= 20, Dual('<=20', 1),

If(Age(Today(), date_of_birth)<= 30, Dual('20-30', 2),

If(Age(Today(),date_of_birth)<= 40, Dual('30-40', 3),

If(Age(Today(), date_of_birth) > 60, Dual('60-above',4))))) as AgeRange,

and it works but when i want to add it as dimension it doesn't show up with the others columns , any suggestion please!

sunny_talwar — Mon, 25 Jun 2018 12:16:40 GMT

but when i want to add it as dimension it doesn't show up with the others columns , any suggestion please!

What other dimensions? And both Age and Age_Range don't show up? Can you share your complete script?

Anonymous — Tue, 26 Jun 2018 07:03:51 GMT

The problem is solved thank you very much