Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

GaneshLakshman
New Contributor III

Grouping values

Hi,

I have a column called points in which there are values from 1 through 10.

I have to group them like 1-5 as class A, 5-7 as class B, remaining as class C in another column called classlevel.

Is there a way to do it? Tried class function but didn't help.

 

Thanks

Ganesh 

3 Solutions

Accepted Solutions
Highlighted
Partner
Partner

Re: Grouping values

Why not if statements?
If(yourfield<=5,'Class A',if(yourfield<=7,'Class B', 'Class C') ) as ClassLevel

or is your logic more complicated than specified?
GaneshLakshman
New Contributor III

Re: Grouping values

This works.. But the table has close to 60 million records, Is there any way we can use if statements and still preserve optimised load? 

Partner
Partner

Re: Grouping values

Unfortunatly cant think of any unless you can do the transformation in a resident load after loading the qvd.
4 Replies
Highlighted
Partner
Partner

Re: Grouping values

Why not if statements?
If(yourfield<=5,'Class A',if(yourfield<=7,'Class B', 'Class C') ) as ClassLevel

or is your logic more complicated than specified?
GaneshLakshman
New Contributor III

Re: Grouping values

This works.. But the table has close to 60 million records, Is there any way we can use if statements and still preserve optimised load? 

Partner
Partner

Re: Grouping values

Unfortunatly cant think of any unless you can do the transformation in a resident load after loading the qvd.
Channa
Valued Contributor III

Re: Grouping values

Grouping can use IntervalMactch for large data

Channa