topic Re: Interval match with additional key in QlikView https://community.qlik.com/t5/QlikView/Interval-match-with-additional-key/m-p/59149#M605540 <HTML><HEAD></HEAD><BODY><P>Thanks a lot, Gysbert!</P></BODY></HTML> Tue, 05 Jun 2018 15:34:44 GMT Anonymous 2018-06-05T15:34:44Z Interval match with additional key https://community.qlik.com/t5/QlikView/Interval-match-with-additional-key/m-p/59147#M605538 <HTML><HEAD></HEAD><BODY><P>Hi everyone!</P><P>I'm trying to understand logic behind Intervalmatch function, so its clear when we try to apply it having only two fields (start date, end date).</P><P>In my example i'm trying to apply intervals (join Value field to Main table) not only using Start &amp; End date, but other fields (Company = Company Map, Account = Account Map).</P><P></P><P>Could anyone please explain how to play around this case? Thanks in advance!</P><P>Test qvw with example you can find in attachment.</P></BODY></HTML> Tue, 05 Jun 2018 14:34:31 GMT https://community.qlik.com/t5/QlikView/Interval-match-with-additional-key/m-p/59147#M605538 Anonymous 2018-06-05T14:34:31Z Re: Interval match with additional key https://community.qlik.com/t5/QlikView/Interval-match-with-additional-key/m-p/59148#M605539 <HTML><HEAD></HEAD><BODY><P>Perhaps this discussion helps: <A href="https://community.qlik.com/message/722210">Re: IntervalMatch Multiplying Records</A></P></BODY></HTML> Tue, 05 Jun 2018 15:22:59 GMT https://community.qlik.com/t5/QlikView/Interval-match-with-additional-key/m-p/59148#M605539 Gysbert_Wassenaar 2018-06-05T15:22:59Z Re: Interval match with additional key https://community.qlik.com/t5/QlikView/Interval-match-with-additional-key/m-p/59149#M605540 <HTML><HEAD></HEAD><BODY><P>Thanks a lot, Gysbert!</P></BODY></HTML> Tue, 05 Jun 2018 15:34:44 GMT https://community.qlik.com/t5/QlikView/Interval-match-with-additional-key/m-p/59149#M605540 Anonymous 2018-06-05T15:34:44Z Re: Interval match with additional key https://community.qlik.com/t5/QlikView/Interval-match-with-additional-key/m-p/59150#M605541 <HTML><HEAD></HEAD><BODY><P>Tested your example and in my case Date for Company 1 and Account 1 isn't related to any appropriate date range (Start &amp; End), so should be empty...</P></BODY></HTML> Tue, 05 Jun 2018 16:52:40 GMT https://community.qlik.com/t5/QlikView/Interval-match-with-additional-key/m-p/59150#M605541 Anonymous 2018-06-05T16:52:40Z