topic Put data in to Groups in QlikView

Put data in to Groups

anuradhaa — Mon, 11 Feb 2013 06:06:37 GMT

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

sreenivas — Mon, 11 Feb 2013 06:11:16 GMT

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

Add this in Calculated Dimension

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

anuradhaa — Mon, 11 Feb 2013 06:20:18 GMT

Thanks