Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Sazabi
Creator
Creator

How to get the class() function to become more granular?

Salutations Qliksters,

 

I have a question - is it possible to get the class() function to break down its segments into smaller incremental chunks?

 

For example: 

By default the class(field, 3) function might return something like

0<=x<3

3<=x<6

6<=x<9

 

I am looking for my classifications to be something more like 

0<=x<3

1<=x<4

2<=x<5

3<=x<6

4<=x<7

5<=x<8

etc, etc

 

Is this possible? 

 

Regards,

 

 

S

1 Reply
tresesco
MVP
MVP

@Sazabi 

You can. In that case, your class would be overlapping. Try something like:

Load
IterNo(),
Class(Num,3, 'x', Mod(IterNo()-1,2)) as Class,
Num
While IterNo()<6;
Load *
Inline [
Num
1
2
3
4
5
6
7
8
9
10
]