topic Matching data based on date field in QlikView https://community.qlik.com/t5/QlikView/Matching-data-based-on-date-field/m-p/1164636#M379294 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I need your expertise again.</P><P>In the attached document when people place orders where ProductCode='40'&nbsp; they must be another corresponding other with the Same Ordernumber and orderdate BUT diffenrent ProductCode.</P><P>Where this is not present I would like to represent the result on a Chart/table showing that there are Orders with ProductCode ='40' <BR />with or with no corresponding/matching OrderDate for the same OrderNumber.</P><P><IMG alt="sampleorderdtls.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/129955_sampleorderdtls.PNG" style="height: auto;" /></P><P>I appreciate any assistance.</P><P>Regards<BR />Didier</P></BODY></HTML> Mon, 04 Jul 2016 02:46:46 GMT didierodayo 2016-07-04T02:46:46Z Matching data based on date field https://community.qlik.com/t5/QlikView/Matching-data-based-on-date-field/m-p/1164636#M379294 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I need your expertise again.</P><P>In the attached document when people place orders where ProductCode='40'&nbsp; they must be another corresponding other with the Same Ordernumber and orderdate BUT diffenrent ProductCode.</P><P>Where this is not present I would like to represent the result on a Chart/table showing that there are Orders with ProductCode ='40' <BR />with or with no corresponding/matching OrderDate for the same OrderNumber.</P><P><IMG alt="sampleorderdtls.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/129955_sampleorderdtls.PNG" style="height: auto;" /></P><P>I appreciate any assistance.</P><P>Regards<BR />Didier</P></BODY></HTML> Mon, 04 Jul 2016 02:46:46 GMT https://community.qlik.com/t5/QlikView/Matching-data-based-on-date-field/m-p/1164636#M379294 didierodayo 2016-07-04T02:46:46Z Re: Matching data based on date field https://community.qlik.com/t5/QlikView/Matching-data-based-on-date-field/m-p/1164637#M379295 <HTML><HEAD></HEAD><BODY><P>Change the color of the rows and it okay. But it depends on the order of the excel! Hope this helps!</P></BODY></HTML> Mon, 04 Jul 2016 05:02:57 GMT https://community.qlik.com/t5/QlikView/Matching-data-based-on-date-field/m-p/1164637#M379295 2016-07-04T05:02:57Z