Create a new column in a table, with values depending on an already loaded table

[Antoine]

Hello,

Since my title my not be clear at all, I'll simply show you what I'm trying to do:

I have 2 tables, the first one is a quotation table:

Index	MIN	MAX
A	2	10
B	11	15
C	16	35
D	35	1E+99

And the second one is : 

Issue N°	Criticity	Indice
Issue1	5
Issue2	50
Issue3	18
Issue4	14

and I want to put in the Indice the value of the Index like :

Issue1:

For X = 1 to Table1Row.count

If Criticity of Issue1  is between RowX,MIN AND RowX,MAX of the first table then  Indice for Issue 1 RowX, Index

Next X

And it would give me:

Issue N°	Criticity	Indice
Issue1	5	A
Issue2	50	D
Issue3	18	C
Issue4	14	B

But I have no idea on how to do that with a script function in Qlik Sense...

Do you know which function I should try ?

Thanks by advance,

Antoine

[Vegar · Accepted solution]

You can solve it by using intervalmatch.

table1:
Load
[Issue N°],
Criticity
from table1;

Left join (table1)
intervalmatch (Criticity)
Load MIN, MAX
From table2;

Left join (table1)
Load MIN, MAX, Index
From table2 ;

Drop field MIN, MAX;

[Antoine]

Thanks! Works just fine!