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

Highlighted
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
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? 

Highlighted
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