Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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.