Finding Sequence based off Range

veldetta — Fri, 09 Feb 2018 16:15:42 GMT

Hi All!

I have 2 tables:

ID	Type	Value
123	A	$100
456	A	$3,000
879	B	$4,000
234	B	$7,000

Type	Sequence	Value
A	1	$1,000
A	2	$4,000
B	1	$1,000
B	2	$6,000
B	3	$10,000

For each ID, I need to find out which Type and Sequence it should be based on the second table. For example, ID 123 should be in Sequence 2 of Type A, ID 879 should be in Sequence 2 of Type B. I'm thinking using the function, Interval Match, but i'm not too sure.

topic Finding Sequence based off Range in QlikView

Finding Sequence based off Range