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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

about class() function


image_jpeg.jpg

here in Class() what is[value] ???  and why we are using 10??

plese give me the answer.....

    those data should be coming in between <= and < (or) >=  and < like that.

       what is the  main theme of class() function??

please tell me..... 

10 Replies
Not applicable
Author

Hi,

The syntax of Class() is

class(expression, interval [ , label [ , offset ]])

It creates a classifications of expressions. The result will be in the format of a<=x<b where a is lower limit and b is the upper limit.

For Example:

class( var,10 ) with var = 23 returns '20<=x<30'

class( var,5,'value' ) with var = 23 returns '20<= value <25'

class( var,10,'x',5 ) with var = 23 returns '15<=x<25'


Here interval is 10 and x is 10,11,15,51

so

for 10 it result will be 10<=x=20

for 11 it result will be 10<=x=20

for 15 it result will be 10<=x=20

for 51 it result will be 50<=x=60


Thanks