topic Re: Filter records based on columns of another table in App Development

Filter records based on columns of another table

lzzoe — Mon, 29 Dec 2025 05:55:56 GMT

Dear All,

I am quite new to Qlik. I want to filter records (table A+B) based on the columns from both table A and table B.

After inner joining table A and table B by using col Key, I want to select only records with AMT within Range1 and Range2. May I ask if I want to do this in data load editor, what function should I use? Thank you

TableA:

Key	Range1	Range2
123	1	10
134	10	1000
185	5	8
199	7	200

TableB:

Key	AMT
123	5
134	290
185	46
199	35

After joining and filter Range1<=AMT<=Range2:

Key	AMT
123	5
134	290
199	35

Re: Filter records based on columns of another table

Sierd_Boersma — Mon, 29 Dec 2025 07:16:30 GMT

Yiou can use IntervalMatch, which checks wether a value falls within a ragen, The script will then look something like this:

inner join([TableB])
IntervalMatch(AMT, Key)
LOAD
  Range1
  ,Range2
  ,Key
Resident TableA;

Re: Filter records based on columns of another table

Chanty4u — Sun, 04 Jan 2026 15:52:26 GMT

Try this

TableA:

LOAD

Key,

Range1,

Range2

INLINE [

Key, Range1, Range2

123, 1, 10

134, 10, 1000

185, 5, 8

199, 7, 200

];

INNER JOIN (TableA)

LOAD

Key,

AMT

INLINE [

Key, AMT

123, 5

134, 290

185, 46

199, 35

]

WHERE AMT >= Ran

ge1

AND AMT <= Range2;

Re: Filter records based on columns of another table

Chanty4u — Sun, 04 Jan 2026 15:52:41 GMT

Try this

TableA:

LOAD

Key,

Range1,

Range2

INLINE [

Key, Range1, Range2

123, 1, 10

134, 10, 1000

185, 5, 8

199, 7, 200

];

INNER JOIN (TableA)

LOAD

Key,

AMT

INLINE [

Key, AMT

123, 5

134, 290

185, 46

199, 35

]

WHERE AMT >= Ran

ge1

AND AMT <= Range2;

Re: Filter records based on columns of another table

HirisH_V7 — Sun, 04 Jan 2026 18:21:02 GMT

This would do.

TableA: LOAD Key, Range1, Range2 INLINE [ Key, Range1, Range2 123, 1, 10 134, 10, 1000 185, 5, 8 199, 7, 200 ]; TableB: LOAD Key, AMT INLINE [ Key, AMT 123, 5 134, 290 185, 46 199, 35 ]; IntervalMatch (AMT) LOAD Range1, Range2 RESIDENT TableA; Inner Join (TableA) LOAD Key, AMT RESIDENT TableB; FinalTable: LOAD Key, AMT RESIDENT TableA; DROP TABLE TableA; DROP TABLE TableB;