Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Create class with dynamic width/interval

Hi everyone, I have an imported field with some number, and I would like to create a class from this values. Let me explain:

I have this field:

ID_Cost     Cost

1               134

2               257

3               548

4               823

5               1004

and I would like to create something like this (I can't create it inline, since I need to import those values):

ID_cost_class      cost_class     class_name

1                         0-134               low price

2                         135-257           low-mid price

3                         258-548           mid price

4                         549-823           high-mid price

5                         824-                 high price


such to categorize some other elements by price


ID_item     price     price_class (this is the field to add)

1               374          mid price

2               194          low-mid price

3               834          high price



Please, can someone help me? Thankyou very much for any advice.