Dear All,
Good afternoon,
Need your help to link the performance data (PAR excel sheet) by employee number in HRDB worksheet as well as to the date in the calendar (see table view in qlikview)
Performance data should show based on the year selected from the "YEAR FIELD SELECTION" in qlikview. You can find this filter fro the left hand side of the screen.
Same goes to EmpInfo excel worksheet. This needs to be linked to HRDB by employee number.
Linked should not produce duplicated records
I have attached two files for easy reference:
1. HRDB_WF_TestData - the source file
2. Qlikview project
I appreciate your help.
Regards,
