topic Re: Master Time Calendar in QlikView https://community.qlik.com/t5/QlikView/Master-Time-Calendar/m-p/766734#M272402 <HTML><HEAD></HEAD><BODY><P>Looks good to me,</P><P></P><P>Many thanks,</P><P></P><P>Dean</P></BODY></HTML> Tue, 04 Nov 2014 21:14:33 GMT mccook 2014-11-04T21:14:33Z Master Time Calendar https://community.qlik.com/t5/QlikView/Master-Time-Calendar/m-p/766732#M272400 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><BR />I've created a master time calendar and linked this to my fact table, however for some reason the link is not working correctly (possibly because the time in both fields is in a different format, although they look the same) so the start time hour, start time minute etc are not linked to the appropriate lines in the fact table.</P><P></P><P>I've attached a sample of the data.</P><P></P><P>Any help appreciated.</P><P></P><P>Cheers,</P><P><BR />Dean</P></BODY></HTML> Tue, 04 Nov 2014 17:07:49 GMT https://community.qlik.com/t5/QlikView/Master-Time-Calendar/m-p/766732#M272400 mccook 2014-11-04T17:07:49Z Re: Master Time Calendar https://community.qlik.com/t5/QlikView/Master-Time-Calendar/m-p/766733#M272401 <HTML><HEAD></HEAD><BODY><P>Dean</P><P></P><P>I've rounded your join fields to the nearest second &amp; things look better.</P></BODY></HTML> Tue, 04 Nov 2014 18:01:04 GMT https://community.qlik.com/t5/QlikView/Master-Time-Calendar/m-p/766733#M272401 Anonymous 2014-11-04T18:01:04Z Re: Master Time Calendar https://community.qlik.com/t5/QlikView/Master-Time-Calendar/m-p/766734#M272402 <HTML><HEAD></HEAD><BODY><P>Looks good to me,</P><P></P><P>Many thanks,</P><P></P><P>Dean</P></BODY></HTML> Tue, 04 Nov 2014 21:14:33 GMT https://community.qlik.com/t5/QlikView/Master-Time-Calendar/m-p/766734#M272402 mccook 2014-11-04T21:14:33Z