Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello, Dinesh
You should use IntervalMatch() function. see in reference manual for more details...
Hello, Dinesh
You should use IntervalMatch() function. see in reference manual for more details...
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