Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Class Function

Hi All,

Please assist me how to get <= value in class function

Example

class(expression, 5)  would return 

0 <= x < 5                            value returning 0 to 4

5 <= x < 10                          value returning 5to 9

I want the value

0 <= x <= 5                            value should return 0 to 5

5 <= x < =10                          value should return 5 to 10

 

Thanks

 

 

 

 

 

 

 

 

 

 

Labels (2)
1 Reply
marcus_sommer

I think it's not possible with the class-function but you could use a logic like:

pick(ceil(expression / 5), '0 to 5', '5 to 10', ....)

- Marcus