topic *** IntervalMatch Issue *** in QlikView https://community.qlik.com/t5/QlikView/IntervalMatch-Issue/m-p/279442#M103985 <HTML><HEAD></HEAD><BODY><P><EM style="font-family: trebuchet ms,geneva;">Dear All,</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">Very simple question about IntervalMatch. I have used this long time back and I am struggling to get this working. I hope one of you can help me. The issue is IntervalMatch is returning One Row per specified Range. And this is returning incorrect values...</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">I am attaching the QV document for your reference.</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">Many thanks in advance.</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">Cheers - DV</EM></P></BODY></HTML> Wed, 21 Sep 2011 17:58:23 GMT IAMDV 2011-09-21T17:58:23Z *** IntervalMatch Issue *** https://community.qlik.com/t5/QlikView/IntervalMatch-Issue/m-p/279442#M103985 <HTML><HEAD></HEAD><BODY><P><EM style="font-family: trebuchet ms,geneva;">Dear All,</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">Very simple question about IntervalMatch. I have used this long time back and I am struggling to get this working. I hope one of you can help me. The issue is IntervalMatch is returning One Row per specified Range. And this is returning incorrect values...</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">I am attaching the QV document for your reference.</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">Many thanks in advance.</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">Cheers - DV</EM></P></BODY></HTML> Wed, 21 Sep 2011 17:58:23 GMT https://community.qlik.com/t5/QlikView/IntervalMatch-Issue/m-p/279442#M103985 IAMDV 2011-09-21T17:58:23Z Re: *** IntervalMatch Issue *** https://community.qlik.com/t5/QlikView/IntervalMatch-Issue/m-p/279443#M103986 <HTML><HEAD></HEAD><BODY><P>Hi DV</P><P></P><P>I think the problem is the join after the intervalmatch. Change this join to:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>Left JOIN (Raw_Data)</P><P>LOAD</P><P> LBound AS %_LBound,</P><P> UBound AS %_UBound,</P><P> RangeName</P><P>RESIDENT Beds_IntervalMatch;</P></PRE><P></P><P>You need the bounds to complete the join correctly.</P><P></P><P>Hope that helps</P><P>Jonathan</P></BODY></HTML> Wed, 21 Sep 2011 18:09:56 GMT https://community.qlik.com/t5/QlikView/IntervalMatch-Issue/m-p/279443#M103986 jonathandienst 2011-09-21T18:09:56Z