Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nishanthi_8
Contributor

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
Honored Contributor II

Re: How to group the data ?

Not applicable

Re: How to group the data ?

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
Valued Contributor

Re: How to group the data ?

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
Valued Contributor

Re: How to group the data ?

If you got the output, Please close the thread.

Community Browser