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

Sazabi — Tue, 15 Dec 2020 08:48:12 GMT

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,

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

tresB — Tue, 15 Dec 2020 09:56:44 GMT

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
]