topic Master Calendar not linking correctly in QlikView https://community.qlik.com/t5/QlikView/Master-Calendar-not-linking-correctly/m-p/248370#M1206132 <HTML><HEAD></HEAD><BODY><P>I have created a master calender in my script and renamed the primary key to the same name as the date field in my fact table. I have formatted the two dates in both tables to DD/MM/YYYY and removed the timestamp info from the end of the DD/MM/YYYY hh:mm:ss statement in my script declarations.</P><P>In my table viewer screen the two tables are linked correctly. (see attached image)<BR />When i preview the data in both tables they both have dates in the fields in the correct formats and my Master calendar has entries for every day between the two dates I wanted.</P><P></P><P>However when I put a list box of Calendar Quarters, or Yeartodate etc or any field from the master calender, selecting the data in that list box will not return any data from the Facts table at all.</P><P></P><P>What am i missing here?</P><P></P><P></P></BODY></HTML> Tue, 23 Mar 2010 13:01:54 GMT 2010-03-23T13:01:54Z Master Calendar not linking correctly https://community.qlik.com/t5/QlikView/Master-Calendar-not-linking-correctly/m-p/248370#M1206132 <HTML><HEAD></HEAD><BODY><P>I have created a master calender in my script and renamed the primary key to the same name as the date field in my fact table. I have formatted the two dates in both tables to DD/MM/YYYY and removed the timestamp info from the end of the DD/MM/YYYY hh:mm:ss statement in my script declarations.</P><P>In my table viewer screen the two tables are linked correctly. (see attached image)<BR />When i preview the data in both tables they both have dates in the fields in the correct formats and my Master calendar has entries for every day between the two dates I wanted.</P><P></P><P>However when I put a list box of Calendar Quarters, or Yeartodate etc or any field from the master calender, selecting the data in that list box will not return any data from the Facts table at all.</P><P></P><P>What am i missing here?</P><P></P><P></P></BODY></HTML> Tue, 23 Mar 2010 13:01:54 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-not-linking-correctly/m-p/248370#M1206132 2010-03-23T13:01:54Z Master Calendar not linking correctly https://community.qlik.com/t5/QlikView/Master-Calendar-not-linking-correctly/m-p/248371#M1206135 <HTML><HEAD></HEAD><BODY><P>in order to discard hh:mm:ss , you can use</P><P>load ... DayStart(OPENEDDATE) as OPENEDDATE ..</P></BODY></HTML> Tue, 23 Mar 2010 14:17:14 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-not-linking-correctly/m-p/248371#M1206135 2010-03-23T14:17:14Z Master Calendar not linking correctly https://community.qlik.com/t5/QlikView/Master-Calendar-not-linking-correctly/m-p/248372#M1206137 <HTML><HEAD></HEAD><BODY><P>Thanks Alex, that seems to have sorted out my issues perfectly! <IMG alt="Smile" src="http://community.qlik.com/emoticons/emotion-1.gif" /></P></BODY></HTML> Wed, 24 Mar 2010 12:08:31 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-not-linking-correctly/m-p/248372#M1206137 2010-03-24T12:08:31Z