Hi All,

I have a measure defined within the application with set analysis and based on the result (integer) i would like to get a corresponding values which is defined in a data mapping table.

Eg.

Data Mapping Table

LowestValue - HighestValue - Category

0 - 50 - A

51 - 100 - B

101 - 150 - C

151 - 200 - D

so on...

In the qlik sense application I would like to get the following table result where:

customer is a dimension value

value is a calculated measure

Category is a lookup result based on the interval cluster for value and the data mapping table

Customer - Value - Category

Andrea - 45 - A

Kris - 123 - C

Paul - 189 - D

In the above example Andrea's value, 45, is between 0 and 50 which is the A interval defined in the data mapping table.

I'm not able to lookup dynamically based an interval.

Any idea?

Thanks,

Antonello