Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.