Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

anuradhaa
Not applicable

Put data in to Groups

Hi,

i have a data set which have age 18-70 . i need to cataoried them in groups. 18-22,22-25 etc.

Then i want to use those data in charts.

Please tell me how can i catogoried those data in to groups.

Thanks

1 Solution

Accepted Solutions
sreenivas
Not applicable

Re: Put data in to Groups

if u want to do in the script side

if(Age>=18 and Age<22,'18-22',if(Age>=22 and Age<=25 ,'22-25','Above 25') as AgeCategory

or

Add this in Calculated Dimension

if(Age>=18 and Age<22,'18-22',if(Age>=22 and Age<=25 ,'22-25','Above 25')

2 Replies
sreenivas
Not applicable

Re: Put data in to Groups

if u want to do in the script side

if(Age>=18 and Age<22,'18-22',if(Age>=22 and Age<=25 ,'22-25','Above 25') as AgeCategory

or

Add this in Calculated Dimension

if(Age>=18 and Age<22,'18-22',if(Age>=22 and Age<=25 ,'22-25','Above 25')

anuradhaa
Not applicable

Re: Put data in to Groups

Thanks