Range Question

[Anonymous]

I have the following Bank Schedule in a table:

ID From To

1 1/1/2010 1/8/2010

2 1/9/2010 1/20/2010

3 1/21/2010 1/25/2010

.

.

n 12/25/2010 12/31/2010

The above schedule does not follow any specific patterns & depends on bank holidays etc. I have a different transaction table, which is below:

Date Amount

2/2/2010 10

2/22/2010 20

.

.

.

How do I filter transaction table depending on which ID is selected?

Thanks,

Dinesh.

[sparur · Accepted solution]

Hello, Dinesh

You should use IntervalMatch() function. see in reference manual for more details...

[marcel_olmo]

Hey Thonipad, I had more or less the same problem as you the last month.

What I wanted in my case is to get the range of possible numbers between a minimun and maximum value.

John Whiterspoon helped me doing the intervalmatch table to solve that.

Hope it helps. I've added you the link of my solved question.

http://community.qlik.com/forums/t/33525.aspx