Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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
]