topic Re: Entry number range in QlikView https://community.qlik.com/t5/QlikView/Entry-number-range/m-p/1425878#M429441 <HTML><HEAD></HEAD><BODY><P>Glad it worked. Can you close the thread accordingly. </P></BODY></HTML> Tue, 19 Sep 2017 15:19:51 GMT vishsaggi 2017-09-19T15:19:51Z Entry number range https://community.qlik.com/t5/QlikView/Entry-number-range/m-p/1425875#M429438 <HTML><HEAD></HEAD><BODY><P>Hi, I urgently need some help with regards to my script.</P><P></P><P><STRONG><EM>My Item Register table has 2 fields available:</EM></STRONG></P><P>a. From entry number</P><P>b. To entry number</P><P></P><P><EM><STRONG>My Item Ledger Entry table has 1 filed available:</STRONG></EM></P><P>a. Entry number</P><P></P><P>I need to link these 2 tables based on the entry number in order to to view what the actual creation date of the document was.</P><P></P><P>As can be seen, the <STRONG>Item Register</STRONG> refers to a <STRONG>range of entry numbers</STRONG> on a line,whilst the <STRONG>Item Ledger Entry</STRONG> table lists each and <STRONG>every entry number</STRONG>.</P><P></P><P>How do I go about this???????</P></BODY></HTML> Fri, 15 Sep 2017 12:41:39 GMT https://community.qlik.com/t5/QlikView/Entry-number-range/m-p/1425875#M429438 ranibosch 2017-09-15T12:41:39Z Re: Entry number range https://community.qlik.com/t5/QlikView/Entry-number-range/m-p/1425876#M429439 <HTML><HEAD></HEAD><BODY><P>May be an IntervalMatch? read here: </P><P><A href="https://community.qlik.com/qlik-blogpost/3037">IntervalMatch</A></P><P><A href="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptPrefixes/IntervalMatch.htm" title="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptPrefixes/IntervalMatch.htm">IntervalMatch ‒ QlikView</A></P></BODY></HTML> Fri, 15 Sep 2017 16:02:45 GMT https://community.qlik.com/t5/QlikView/Entry-number-range/m-p/1425876#M429439 vishsaggi 2017-09-15T16:02:45Z Re: Entry number range https://community.qlik.com/t5/QlikView/Entry-number-range/m-p/1425877#M429440 <HTML><HEAD></HEAD><BODY><P>IntervalMatch worked perfectly. Thank you very much!</P></BODY></HTML> Tue, 19 Sep 2017 13:11:49 GMT https://community.qlik.com/t5/QlikView/Entry-number-range/m-p/1425877#M429440 ranibosch 2017-09-19T13:11:49Z Re: Entry number range https://community.qlik.com/t5/QlikView/Entry-number-range/m-p/1425878#M429441 <HTML><HEAD></HEAD><BODY><P>Glad it worked. Can you close the thread accordingly. </P></BODY></HTML> Tue, 19 Sep 2017 15:19:51 GMT https://community.qlik.com/t5/QlikView/Entry-number-range/m-p/1425878#M429441 vishsaggi 2017-09-19T15:19:51Z