Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
]