Table not linking with master calendar

[tenyeapen]

I created one master calendar based on one date field from the table. master calendar created, but its not showing as linked with the main table. qvw file attached. Please help me ..

[MindaugasBacius]

Try this:

[Approved Date] as ApprovedDate, 
     [Approved Month], 
     [Approved Year], 
     [Resubmit user id], 
     [Resubmit user id_1]
FROM
[C:\Users\teapen\Desktop\QlikView\MCO\MCO.xlsx]
(ooxml, embedded labels, table is [Export Worksheet]);

The one Date field in table Export Worksheet have to be the same like in MasterCalendar.

Or else they will not connect.