https://community.qlik.com/t5/App-Development/How-to-use-interval-match-when-you-have-no-fields-in-common/m-p/1537682#M38937 <P>This is fairly straightforward</P><P>T1:</P><P>LOAD</P><P>Leaders,</P><P>[Ebitda %]</P><P>FROM [...]</P><P>;</P><P>&nbsp;</P><P>T2:</P><P>LOAD</P><P>[Start Ebidta %],</P><P>[End Ebidta %],</P><P>Category</P><P>FROM [...]</P><P>;</P><P>&nbsp;</P><P>Link:</P><P>INTERVALMATCH([Ebitda %])</P><P>LOAD</P><P>[Start Ebidta %],</P><P>[End Ebidta %]</P><P>RESIDENT [T2]</P><P>;</P><P>//n.b. Link now contains [Ebitda %], and the related [Start Ebidta %], [End Ebidta %]</P><P>&nbsp;</P><P>-------</P><P>At this point you can left join on to T1 from Link (then drop it), and from T2</P><P>&nbsp;</P><P>Note that you will have issues if [Ebitda %] is 10% or 20% as this will match to more than one record in T2, so you may wish to reduce the Start or End Ebitda % values to avoid this</P> Thu, 31 Jan 2019 09:59:29 GMT marcus_malinow 2019-01-31T09:59:29Z https://community.qlik.com/t5/App-Development/How-to-use-interval-match-when-you-have-no-fields-in-common/m-p/1537587#M38936 <P>Hi All,</P><P>&nbsp;</P><P>I have one Table as T1</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Leaders</TD><TD>Ebitda %</TD></TR><TR><TD>A</TD><TD>3</TD></TR><TR><TD>B</TD><TD>5</TD></TR><TR><TD>C</TD><TD>16</TD></TR><TR><TD>D</TD><TD>28</TD></TR><TR><TD>E</TD><TD>18</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>And the other as Table T2</P><TABLE><TBODY><TR><TD>Start Ebidta %</TD><TD>End Ebidta %</TD><TD>Category</TD></TR><TR><TD>0</TD><TD>10</TD><TD>0-10 %</TD></TR><TR><TD>10</TD><TD>20</TD><TD>10-20 %</TD></TR><TR><TD>20</TD><TD>100</TD><TD>20% +</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to use Interval Match so that my category is made in T1 according to the logic in T2</P> Sat, 16 Nov 2024 06:42:53 GMT https://community.qlik.com/t5/App-Development/How-to-use-interval-match-when-you-have-no-fields-in-common/m-p/1537587#M38936 siddharthsoam 2024-11-16T06:42:53Z https://community.qlik.com/t5/App-Development/How-to-use-interval-match-when-you-have-no-fields-in-common/m-p/1537682#M38937 <P>This is fairly straightforward</P><P>T1:</P><P>LOAD</P><P>Leaders,</P><P>[Ebitda %]</P><P>FROM [...]</P><P>;</P><P>&nbsp;</P><P>T2:</P><P>LOAD</P><P>[Start Ebidta %],</P><P>[End Ebidta %],</P><P>Category</P><P>FROM [...]</P><P>;</P><P>&nbsp;</P><P>Link:</P><P>INTERVALMATCH([Ebitda %])</P><P>LOAD</P><P>[Start Ebidta %],</P><P>[End Ebidta %]</P><P>RESIDENT [T2]</P><P>;</P><P>//n.b. Link now contains [Ebitda %], and the related [Start Ebidta %], [End Ebidta %]</P><P>&nbsp;</P><P>-------</P><P>At this point you can left join on to T1 from Link (then drop it), and from T2</P><P>&nbsp;</P><P>Note that you will have issues if [Ebitda %] is 10% or 20% as this will match to more than one record in T2, so you may wish to reduce the Start or End Ebitda % values to avoid this</P> Thu, 31 Jan 2019 09:59:29 GMT https://community.qlik.com/t5/App-Development/How-to-use-interval-match-when-you-have-no-fields-in-common/m-p/1537682#M38937 marcus_malinow 2019-01-31T09:59:29Z