Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
tenyeapen
New Contributor

Table not linking with master calendar

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 ..

1 Reply
MindaugasBacius
Valued Contributor III

Re: Table not linking with master calendar

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.