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 ?
Check this out: https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/LoadData/matching-intervals-to-discrete-data.htm
using interval match you can achieve this.
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
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 ;
If you got the output, Please close the thread.
Retrieving data ...