topic Range Question in QlikView https://community.qlik.com/t5/QlikView/Range-Question/m-p/285649#M1200930 <HTML><HEAD></HEAD><BODY><P>I have the following Bank Schedule in a table:</P><P></P><P>ID From To</P><P>1 1/1/2010 1/8/2010</P><P>2 1/9/2010 1/20/2010</P><P>3 1/21/2010 1/25/2010</P><P>.</P><P>.</P><P>n 12/25/2010 12/31/2010</P><P></P><P>The above schedule does not follow any specific patterns &amp; depends on bank holidays etc. I have a different transaction table, which is below:</P><P></P><P>Date Amount</P><P>2/2/2010 10</P><P>2/22/2010 20</P><P>.</P><P>.</P><P>.</P><P></P><P>How do I filter transaction table depending on which ID is selected?</P><P></P><P>Thanks,</P><P>Dinesh.</P></BODY></HTML> Tue, 02 Nov 2010 13:01:49 GMT Anonymous 2010-11-02T13:01:49Z Range Question https://community.qlik.com/t5/QlikView/Range-Question/m-p/285649#M1200930 <HTML><HEAD></HEAD><BODY><P>I have the following Bank Schedule in a table:</P><P></P><P>ID From To</P><P>1 1/1/2010 1/8/2010</P><P>2 1/9/2010 1/20/2010</P><P>3 1/21/2010 1/25/2010</P><P>.</P><P>.</P><P>n 12/25/2010 12/31/2010</P><P></P><P>The above schedule does not follow any specific patterns &amp; depends on bank holidays etc. I have a different transaction table, which is below:</P><P></P><P>Date Amount</P><P>2/2/2010 10</P><P>2/22/2010 20</P><P>.</P><P>.</P><P>.</P><P></P><P>How do I filter transaction table depending on which ID is selected?</P><P></P><P>Thanks,</P><P>Dinesh.</P></BODY></HTML> Tue, 02 Nov 2010 13:01:49 GMT https://community.qlik.com/t5/QlikView/Range-Question/m-p/285649#M1200930 Anonymous 2010-11-02T13:01:49Z Range Question https://community.qlik.com/t5/QlikView/Range-Question/m-p/285650#M1200931 <HTML><HEAD></HEAD><BODY><P>Hello, Dinesh</P><P>You should use IntervalMatch() function. see in reference manual for more details...</P></BODY></HTML> Tue, 02 Nov 2010 13:18:35 GMT https://community.qlik.com/t5/QlikView/Range-Question/m-p/285650#M1200931 sparur 2010-11-02T13:18:35Z Range Question https://community.qlik.com/t5/QlikView/Range-Question/m-p/285651#M1200932 <HTML><HEAD></HEAD><BODY><P>Hey Thonipad, I had more or less the same problem as you the last month.</P><P>What I wanted in my case is to get the range of possible numbers between a minimun and maximum value.</P><P>John Whiterspoon helped me doing the intervalmatch table to solve that.</P><P>Hope it helps. I've added you the link of my solved question.</P><P></P><P>http://community.qlik.com/forums/t/33525.aspx</P></BODY></HTML> Tue, 02 Nov 2010 14:49:36 GMT https://community.qlik.com/t5/QlikView/Range-Question/m-p/285651#M1200932 marcel_olmo 2010-11-02T14:49:36Z