Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikSensor
Partner - Creator
Partner - Creator

Finding the right line of a table

Hi, I have in one table, let's say the table's name is PROB, a field called OverallProbability. In another table, lets assume, the table's name is ASSESSMENT, I have severall lines like this:

Probability from, Probabilty to, Assessment

0, 0.1, High

0.1, 0.01, Medium

0.01, 0.001, Low

And I want to display the Assessment for a given OverallProbability in a table. How can I do this?

Labels (1)
1 Reply
sbaro_bd
Creator III
Creator III

Hi @QlikSensor ,

The IntervalMatch() function can help you to do that : https://help.qlik.com/fr-FR/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/...

Regards.