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

Announcements
Join us in Toronto Sept 9th 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