Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nishanthi_8
Creator
Creator

How to group the data ?

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 ?

4 Replies
sushil353
Master II
Master II

Not applicable

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
Specialist
Specialist

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
Specialist
Specialist

If you got the output, Please close the thread.