Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Antoine
Contributor III
Contributor III

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

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:

IndexMINMAX
A210
B1115
C1635
D351E+99

 

And the second one is : 

 Issue N°CriticityIndice
Issue1 5 
Issue250  
Issue318  
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°CriticityIndice
Issue1 5 A
Issue250  D
Issue318  C
Issue414 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

 

1 Solution

Accepted Solutions
Vegar
MVP
MVP

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;

View solution in original post

2 Replies
Vegar
MVP
MVP

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
Contributor III
Contributor III
Author

Thanks! Works just fine!