Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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
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