topic Re: How to create a age group in QlikView

How to create a age group

Kohli — Sat, 16 Nov 2024 05:15:46 GMT

I have AGE filed in my table. I want convert it into Age group.

Age

I want covert like if AGE= (1-20) Young, (21-30)Middle. (31-40)Upper

Re: How to create a age group

PrashantSangle — Wed, 14 Nov 2018 06:26:01 GMT

Hi,

try with simple if else statement in script

try like

if(age>0 and age<21,'Young',if(age>21 and age<31,'Middle',if(age>30 and age<41,'Upper'))) as age_group

if(age>0 and age<21,'Young',if(age>21 and age<31,'Middle','Upper')) as age_group

Regards

Prashant Sangle

Re: How to create a age group

qlikviewwizard — Wed, 14 Nov 2018 06:46:44 GMT

Hi,

Please try this.

I included logic for Age > 40 as well. You can remove if it is not needed.

Data:
LOAD *,if(Age<=20 ,'Young',
if(Age>=21 and Age<=30 ,'Middle',
if(Age>=31 and Age<=40 ,'Upper','Other'
))) as [Age Group];
LOAD * INLINE [
Age
1
11
14
18
21
14
15
19
25
32
42
54
65
88
100];

Re: How to create a age group

timpoismans — Wed, 14 Nov 2018 09:37:16 GMT

Can possibly also use IntervalMatch:

Age:
Load * Inline [
Age
21
14
15
19
25
32
];

AgeInterval:
Load * Inline [
Min, Max, AgeGroup
1, 20, Young
21, 30, Middle
31, 99, Upper
];

Inner Join IntervalMatch (Age)
Load
Min,
Max
Resident AgeInterval;

Left Join (Age)
Load
Age,
AgeGroup
Resident AgeInterval;
Drop Table AgeInterval;