How to group the data ?

[nishanthi_8]

I need to group the employees under certain grade say for example , Employees who fall between the grade level 0 to 1 in one category and 2,3,4 standalone and 5-6  together. How it can be achieved from script side ?

[sushil353]

Hi,

Check this out: https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/LoadData/matching-intervals-to-discrete...

using interval match you can achieve this.

HTH

[#3]

You can create a field "category" to classify them.

if(grade=0 or grade=1,"level1",if(grade=2 or grade =3...,"level2",if(...))) as category

FYR:Creating a new field with IF statement

[varshavig12]

if (grade = 0  or grade = 1 , 'Category0_1' ,

if (grade = 2  , 'Category2' ,

if (grade = 3, 'Category3' ,

if (grade =4  , 'Category4' ,

if (grade = 5 or grade = 6 , 'Category5_6'

))))) as Category_grade_level ;

[varshavig12]

If you got the output, Please close the thread.