topic Interval Match in QlikView https://community.qlik.com/t5/QlikView/Interval-Match/m-p/1156769#M890183 <HTML><HEAD></HEAD><BODY><P><BR />Dear All,</P><P></P><P>Good afternoon,</P><P></P><P>Need your help to link the performance data (PAR excel sheet) by&nbsp; employee number in HRDB worksheet as well as to the date in the calendar (see table view in qlikview)</P><P></P><P>Performance data should show based on the year selected from the "YEAR FIELD SELECTION" in qlikview.&nbsp; You can find this filter fro the left hand side of the screen.</P><P></P><P>Same goes to EmpInfo excel worksheet.&nbsp; This needs to be linked to HRDB by employee number.</P><P></P><P>Linked should not produce duplicated records</P><P></P><P></P><P>I have attached two files for easy reference:</P><P></P><P>1. HRDB_WF_TestData - the source file</P><P>2. Qlikview project</P><P></P><P>I appreciate your help.</P><P></P><P>Regards,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Interval Match https://community.qlik.com/t5/QlikView/Interval-Match/m-p/1156769#M890183 <HTML><HEAD></HEAD><BODY><P><BR />Dear All,</P><P></P><P>Good afternoon,</P><P></P><P>Need your help to link the performance data (PAR excel sheet) by&nbsp; employee number in HRDB worksheet as well as to the date in the calendar (see table view in qlikview)</P><P></P><P>Performance data should show based on the year selected from the "YEAR FIELD SELECTION" in qlikview.&nbsp; You can find this filter fro the left hand side of the screen.</P><P></P><P>Same goes to EmpInfo excel worksheet.&nbsp; This needs to be linked to HRDB by employee number.</P><P></P><P>Linked should not produce duplicated records</P><P></P><P></P><P>I have attached two files for easy reference:</P><P></P><P>1. HRDB_WF_TestData - the source file</P><P>2. Qlikview project</P><P></P><P>I appreciate your help.</P><P></P><P>Regards,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Interval-Match/m-p/1156769#M890183 2020-11-25T16:16:04Z Re: Interval Match https://community.qlik.com/t5/QlikView/Interval-Match/m-p/1156770#M890184 <HTML><HEAD></HEAD><BODY><P>Good morning Qlikview community.&nbsp; Just wanted to know if there is someone who could help me on this post.</P><P></P><P>regards,</P></BODY></HTML> Mon, 19 Sep 2016 04:58:26 GMT https://community.qlik.com/t5/QlikView/Interval-Match/m-p/1156770#M890184 2016-09-19T04:58:26Z