topic Intervalmatch in QlikView https://community.qlik.com/t5/QlikView/Intervalmatch/m-p/1789253#M1210423 <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> Mon, 08 Mar 2021 15:00:28 GMT AleRods88 2021-03-08T15:00:28Z Intervalmatch https://community.qlik.com/t5/QlikView/Intervalmatch/m-p/1789253#M1210423 <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> Mon, 08 Mar 2021 15:00:28 GMT https://community.qlik.com/t5/QlikView/Intervalmatch/m-p/1789253#M1210423 AleRods88 2021-03-08T15:00:28Z Re: Intervalmatch https://community.qlik.com/t5/QlikView/Intervalmatch/m-p/1789321#M1210431 <P>can you elaborate how you get the second table for the first ? examples</P> Mon, 08 Mar 2021 19:07:55 GMT https://community.qlik.com/t5/QlikView/Intervalmatch/m-p/1789321#M1210431 Taoufiq_Zarra 2021-03-08T19:07:55Z Re: Intervalmatch https://community.qlik.com/t5/QlikView/Intervalmatch/m-p/1789387#M1210434 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/94877">@AleRods88</a>&nbsp;</P><P>Try like this</P><P><STRONG>Load * where Date &gt;= START_DATE and Date &lt;= END_DATE;</STRONG><BR />LOAD *, <STRONG>MakeDate(Left(PERIOD,4), right(PERIOD,2),28) as Date</STRONG> INLINE [<BR />SHIP, PERIOD, START_DATE, END_DATE, VALUE<BR />2803845, 201802, 4/2/2018, 3/2/2019, 3<BR />2803845, 201802, 4/2/2019, 3/1/2020, 4<BR />2803845, 201802, 4/1/2020, 1/3/2020, 1<BR />2803845, 201803, 4/2/2018, 3/2/2019, 3<BR />2803845, 201803, 4/2/2019, 3/1/2020, 4<BR />2803845, 201803, 4/1/2020, 1/3/2020, 1<BR />2803845, 201804, 4/2/2018, 3/2/2019, 3<BR />2803845, 201804, 4/2/2019, 3/1/2020, 4<BR />2803845, 201804, 4/1/2020, 1/3/2020, 1<BR />2803845, 201805, 4/2/2018, 3/2/2019, 3<BR />2803845, 201805, 4/2/2019, 3/1/2020, 4<BR />2803845, 201805, 4/1/2020, 1/3/2020, 1<BR />2803845, 201806, 4/2/2018, 3/2/2019, 3<BR />2803845, 201806, 4/2/2019, 3/1/2020, 4<BR />2803845, 201806, 4/1/2020, 1/3/2020, 1<BR />];</P> Tue, 09 Mar 2021 01:49:34 GMT https://community.qlik.com/t5/QlikView/Intervalmatch/m-p/1789387#M1210434 MayilVahanan 2021-03-09T01:49:34Z