Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gameoverzx
Partner
Partner

class() function

Hi all,

I want to display a dimension of income using the class() function.

dimensions are as follows:

0=<x<1000

1000=<x<2000

2000=<x<3000

3000=<x<4000

4000=<x<5000

5000=<x<6000

6000=<x<7000

7000=<x<8000

8000=<x<9000

9000=<x<10000

10000=<x<15000

15000=<x<20000

x => 20000

i am able to obtain all the intervals using :

=if(HOUSEHOLDINCOME>10000,

class(HOUSEHOLDINCOME,5000),

class(HOUSEHOLDINCOME,1000))

Having trouble with the last range of x=>20000,

any suggestions would be appreciated.

Regards,

Gaston

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try just putting one more condition like:

= If(HOUSEHOLDINCOME>=20000, 'x => 20000',

   if(HOUSEHOLDINCOME>10000,

      class(HOUSEHOLDINCOME,5000),

       class(HOUSEHOLDINCOME,1000))

)

View solution in original post

1 Reply
tresesco
MVP
MVP

Try just putting one more condition like:

= If(HOUSEHOLDINCOME>=20000, 'x => 20000',

   if(HOUSEHOLDINCOME>10000,

      class(HOUSEHOLDINCOME,5000),

       class(HOUSEHOLDINCOME,1000))

)

View solution in original post