Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
amita1621
Contributor III
Contributor III

I have a column with 4 values and i want to apply threshold on each column value and show values based on that.

I want to apply threshold on each bands and want to show result based on threshold.

1 Reply
tschullo
Creator III
Creator III

You can create the range labels by creating a table as follows:

Ranges:

Load <some unique ID>

if (Amount >=0 And Amount <=90, '0-90',

if (Amount >90 And Amount <=18, '91-180',

if (Amount >180 And Amount <=360, '181-360',

if (Amount >360, '>360')))) as Range

Resident DataTable;

In above example, you would have to create a unique key in your source data (row number would work) and use that key as linked field.