topic Intervalmatch in QlikView https://community.qlik.com/t5/QlikView/Intervalmatch/m-p/1788688#M1210332 <P>Hello,</P><P>I have the following table</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>SHIP</TD><TD>PERIOD</TD><TD>START_DATE</TD><TD>END_DATE</TD><TD>VALUE</TD></TR><TR><TD>2803845</TD><TD>201802</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201802</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201802</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201803</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201803</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201803</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201804</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201804</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201804</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201805</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201805</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201805</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201806</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201806</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201806</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201807</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201807</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201807</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201808</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201808</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201808</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201809</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201809</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201809</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201810</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201810</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201810</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201811</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201811</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201811</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201812</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201812</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201812</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201901</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201901</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201901</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201902</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201902</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201902</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201903</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201903</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201903</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201904</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201904</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201904</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201905</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201905</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201905</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201906</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201906</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201906</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201907</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201907</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201907</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201908</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201908</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201908</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201909</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201909</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201909</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201910</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201910</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201910</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201911</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201911</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201911</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201912</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201912</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201912</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>202001</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>202001</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>202001</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>202002</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>202002</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>202002</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>202003</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>202003</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>202003</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What I need to do is compare if the Period is in the range Start_Date/End_Date and bring a single row per Period with the Value associated to that Period:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>SHIP</TD><TD>PERIOD</TD><TD>START_DATE</TD><TD>END_DATE</TD><TD>VALUE</TD></TR><TR><TD>2803845</TD><TD>201802</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201803</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201804</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201805</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201806</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201807</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201808</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201809</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201810</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201811</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201812</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201901</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201902</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201903</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201904</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201905</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201906</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201907</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201908</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201909</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201910</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201911</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201912</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>202001</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>202002</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>202003</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Is there any way to do that?</P><P>Thank you!!</P> Fri, 05 Mar 2021 13:44:15 GMT AleRods88 2021-03-05T13:44:15Z Intervalmatch https://community.qlik.com/t5/QlikView/Intervalmatch/m-p/1788688#M1210332 <P>Hello,</P><P>I have the following table</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>SHIP</TD><TD>PERIOD</TD><TD>START_DATE</TD><TD>END_DATE</TD><TD>VALUE</TD></TR><TR><TD>2803845</TD><TD>201802</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201802</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201802</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201803</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201803</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201803</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201804</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201804</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201804</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201805</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201805</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201805</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201806</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201806</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201806</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201807</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201807</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201807</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201808</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201808</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201808</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201809</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201809</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201809</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201810</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201810</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201810</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201811</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201811</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201811</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201812</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201812</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201812</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201901</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201901</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201901</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201902</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201902</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201902</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201903</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201903</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201903</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201904</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201904</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201904</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201905</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201905</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201905</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201906</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201906</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201906</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201907</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201907</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201907</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201908</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201908</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201908</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201909</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201909</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201909</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201910</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201910</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201910</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201911</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201911</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201911</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>201912</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201912</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201912</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>202001</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>202001</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>202001</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>202002</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>202002</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>202002</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>202003</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>202003</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>202003</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What I need to do is compare if the Period is in the range Start_Date/End_Date and bring a single row per Period with the Value associated to that Period:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>SHIP</TD><TD>PERIOD</TD><TD>START_DATE</TD><TD>END_DATE</TD><TD>VALUE</TD></TR><TR><TD>2803845</TD><TD>201802</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201803</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201804</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201805</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201806</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201807</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201808</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201809</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201810</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201811</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201812</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201901</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201902</TD><TD>4/2/2018</TD><TD>3/2/2019</TD><TD>3</TD></TR><TR><TD>2803845</TD><TD>201903</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201904</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201905</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201906</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201907</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201908</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201909</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201910</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201911</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>201912</TD><TD>4/2/2019</TD><TD>3/1/2020</TD><TD>4</TD></TR><TR><TD>2803845</TD><TD>202001</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>202002</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR><TR><TD>2803845</TD><TD>202003</TD><TD>4/1/2020</TD><TD>1/3/2020</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Is there any way to do that?</P><P>Thank you!!</P> Fri, 05 Mar 2021 13:44:15 GMT https://community.qlik.com/t5/QlikView/Intervalmatch/m-p/1788688#M1210332 AleRods88 2021-03-05T13:44:15Z Re: Intervalmatch https://community.qlik.com/t5/QlikView/Intervalmatch/m-p/1788727#M1210339 <P>you dont need intervalmatch just use an if statement when loading:<BR /><BR />=if(date(right('201802',2)&amp;'/01/'&amp;left('201802',4))&gt;=startdate and&nbsp;date(right('201802',2)&amp;'/01/'&amp;left('201802',4))&lt;=enddate, ....</P><P>note though that your period is month date so you need to define the business rules, will 02/2018 be in the period 02/15/2018 to 03/15/2018?&nbsp; if so:</P><P>=if(date(right('201802',2)&amp;'/01/'&amp;left('201802',4))&gt;=monthstart(startdate) and&nbsp;date(right('201802',2)&amp;'/01/'&amp;left('201802',4))&lt;=monthend(enddate), ....</P><P>&nbsp;</P> Fri, 05 Mar 2021 14:46:44 GMT https://community.qlik.com/t5/QlikView/Intervalmatch/m-p/1788727#M1210339 edwin 2021-03-05T14:46:44Z