topic IntervalMatch with Datetime in QlikView https://community.qlik.com/t5/QlikView/IntervalMatch-with-Datetime/m-p/283638#M1186094 <HTML><HEAD></HEAD><BODY><P>Guys</P><P></P><P>I have attached 1 file with 2 sample sheets. We have a production system that provides us the amount of qty created by each plant (key) If we have a problem and issues sheet is completed with the date time of the issue. </P><P></P><P>I need to join this to the main summary sheet but have two issuess. </P><P></P><P>1. some times the value in the main sheet is missing (ie we don't have a start datetime and end datetime ) </P><P>2. the other issue is the interval match does not work with datetime. </P><P></P><P>Please could someone help. </P><P></P><P>Suky</P></BODY></HTML> Thu, 22 Sep 2011 19:10:30 GMT sukydhak 2011-09-22T19:10:30Z IntervalMatch with Datetime https://community.qlik.com/t5/QlikView/IntervalMatch-with-Datetime/m-p/283638#M1186094 <HTML><HEAD></HEAD><BODY><P>Guys</P><P></P><P>I have attached 1 file with 2 sample sheets. We have a production system that provides us the amount of qty created by each plant (key) If we have a problem and issues sheet is completed with the date time of the issue. </P><P></P><P>I need to join this to the main summary sheet but have two issuess. </P><P></P><P>1. some times the value in the main sheet is missing (ie we don't have a start datetime and end datetime ) </P><P>2. the other issue is the interval match does not work with datetime. </P><P></P><P>Please could someone help. </P><P></P><P>Suky</P></BODY></HTML> Thu, 22 Sep 2011 19:10:30 GMT https://community.qlik.com/t5/QlikView/IntervalMatch-with-Datetime/m-p/283638#M1186094 sukydhak 2011-09-22T19:10:30Z