topic Use a masterDateDimension table to link to more than 1 field in QlikView https://community.qlik.com/t5/QlikView/Use-a-masterDateDimension-table-to-link-to-more-than-1-field/m-p/426179#M158769 <HTML><HEAD></HEAD><BODY><P>Is it possible to link different fields in the same fact table (like orderdate and deliverydate) to the same masterDate table?</P><P>I'm trying to load a starscheme into qlikview, but don't suceed to link both dates to the same table without having either:</P><UL><LI>having a circle reference</LI><LI>or duplicating the table</LI></UL><P>How is this solved?</P></BODY></HTML> Sun, 10 Mar 2013 16:46:11 GMT 2013-03-10T16:46:11Z Use a masterDateDimension table to link to more than 1 field https://community.qlik.com/t5/QlikView/Use-a-masterDateDimension-table-to-link-to-more-than-1-field/m-p/426179#M158769 <HTML><HEAD></HEAD><BODY><P>Is it possible to link different fields in the same fact table (like orderdate and deliverydate) to the same masterDate table?</P><P>I'm trying to load a starscheme into qlikview, but don't suceed to link both dates to the same table without having either:</P><UL><LI>having a circle reference</LI><LI>or duplicating the table</LI></UL><P>How is this solved?</P></BODY></HTML> Sun, 10 Mar 2013 16:46:11 GMT https://community.qlik.com/t5/QlikView/Use-a-masterDateDimension-table-to-link-to-more-than-1-field/m-p/426179#M158769 2013-03-10T16:46:11Z Re: Use a masterDateDimension table to link to more than 1 field https://community.qlik.com/t5/QlikView/Use-a-masterDateDimension-table-to-link-to-more-than-1-field/m-p/426180#M158770 <HTML><HEAD></HEAD><BODY><P>See <A _jive_internal="true" href="https://community.qlik.com/thread/64619">this discussion</A>.</P></BODY></HTML> Sun, 10 Mar 2013 17:10:31 GMT https://community.qlik.com/t5/QlikView/Use-a-masterDateDimension-table-to-link-to-more-than-1-field/m-p/426180#M158770 Gysbert_Wassenaar 2013-03-10T17:10:31Z Re: Use a masterDateDimension table to link to more than 1 field https://community.qlik.com/t5/QlikView/Use-a-masterDateDimension-table-to-link-to-more-than-1-field/m-p/426181#M158771 <HTML><HEAD></HEAD><BODY><P>See also</P><P>"<A href="http://robwunderlich.com/storage/qvtutorial/QvTutorial_CommonDateDimension.qvw" style="color: #3b871b; font-family: Arial, Helvetica, Geneva, sans-serif; font-size: 12px; background-color: #ffffff;">Using Common Date Dimensions and Shared Calendars</A>" at <A class="loading" href="http://robwunderlich.com/tutorials/" title="http://robwunderlich.com/tutorials/">http://robwunderlich.com/tutorials/</A>.</P><P></P><P>-Rob</P></BODY></HTML> Mon, 11 Mar 2013 06:03:07 GMT https://community.qlik.com/t5/QlikView/Use-a-masterDateDimension-table-to-link-to-more-than-1-field/m-p/426181#M158771 rwunderlich 2013-03-11T06:03:07Z Re: Use a masterDateDimension table to link to more than 1 field https://community.qlik.com/t5/QlikView/Use-a-masterDateDimension-table-to-link-to-more-than-1-field/m-p/426182#M158772 <HTML><HEAD></HEAD><BODY><P><SPAN class="jive-thread-message clearfix" id="thread-message-301514"></SPAN></P><P class="jive-thread-reply-indent-shadow">Hi,</P><P class="jive-thread-reply-indent-shadow"></P><P class="jive-thread-reply-indent-shadow">See the below Thread:<BR /><BR /></P><P class="jive-thread-reply-indent-shadow"><A _jive_internal="true" class="loading" href="https://community.qlik.com/message/301488#301488" title="http://community.qlik.com/message/301488#301488">http://community.qlik.com/message/301488#301488</A></P><P></P><P></P><P>Regards,</P><P>Nirav Bhimani</P></BODY></HTML> Mon, 11 Mar 2013 10:26:13 GMT https://community.qlik.com/t5/QlikView/Use-a-masterDateDimension-table-to-link-to-more-than-1-field/m-p/426182#M158772 nirav_bhimani 2013-03-11T10:26:13Z