topic Select field between available ranges in QlikView https://community.qlik.com/t5/QlikView/Select-field-between-available-ranges/m-p/195103#M55754 <HTML><HEAD></HEAD><BODY><P>Try using IntervalMatch .</P></BODY></HTML> Fri, 26 Mar 2010 13:01:15 GMT vidyut 2010-03-26T13:01:15Z Select field between available ranges https://community.qlik.com/t5/QlikView/Select-field-between-available-ranges/m-p/195102#M55753 <HTML><HEAD></HEAD><BODY><P>I have 3 account numbers:</P><P>1000000</P><P>1500000</P><P>2000000</P><P>I have 5 ranges with names</P><P>Range name A with accounts 10000000 to 1399999</P><P>B, 1400000, 1599999</P><P>C, 1600000, 2500000</P><P>QV must return the right range name.</P><P></P><P>Thank you.</P><P></P><P></P></BODY></HTML> Fri, 26 Mar 2010 11:19:06 GMT https://community.qlik.com/t5/QlikView/Select-field-between-available-ranges/m-p/195102#M55753 2010-03-26T11:19:06Z Select field between available ranges https://community.qlik.com/t5/QlikView/Select-field-between-available-ranges/m-p/195103#M55754 <HTML><HEAD></HEAD><BODY><P>Try using IntervalMatch .</P></BODY></HTML> Fri, 26 Mar 2010 13:01:15 GMT https://community.qlik.com/t5/QlikView/Select-field-between-available-ranges/m-p/195103#M55754 vidyut 2010-03-26T13:01:15Z Select field between available ranges https://community.qlik.com/t5/QlikView/Select-field-between-available-ranges/m-p/195104#M55755 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>see the attached example. The keyword is INTERVALMATCH.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Fri, 26 Mar 2010 13:15:35 GMT https://community.qlik.com/t5/QlikView/Select-field-between-available-ranges/m-p/195104#M55755 2010-03-26T13:15:35Z Select field between available ranges https://community.qlik.com/t5/QlikView/Select-field-between-available-ranges/m-p/195105#M55756 <HTML><HEAD></HEAD><BODY><P>Very helpful, thank you.</P></BODY></HTML> Fri, 26 Mar 2010 13:42:02 GMT https://community.qlik.com/t5/QlikView/Select-field-between-available-ranges/m-p/195105#M55756 2010-03-26T13:42:02Z