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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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
MVP
MVP

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