topic fact table with multiple dates in QlikView https://community.qlik.com/t5/QlikView/fact-table-with-multiple-dates/m-p/1109768#M367144 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have an one fact table with order date and ship date.</P><P></P><P>Now i want to connect with this to master calendar,how can i link between the tables.</P><P></P><P>I can connect to order date from fact table to master calendar but i want to get ship date also?</P><P></P><P>How can i do this one?</P><P></P><P>Is there any need to copy same master calendar and need to connect to ship date?</P><P></P><P>Please give me suggestions..</P><P></P><P>Thanks in advance</P><P></P><P>regards</P><P>Venkey</P></BODY></HTML> Wed, 20 Jul 2016 14:41:33 GMT venkey2847 2016-07-20T14:41:33Z fact table with multiple dates https://community.qlik.com/t5/QlikView/fact-table-with-multiple-dates/m-p/1109768#M367144 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have an one fact table with order date and ship date.</P><P></P><P>Now i want to connect with this to master calendar,how can i link between the tables.</P><P></P><P>I can connect to order date from fact table to master calendar but i want to get ship date also?</P><P></P><P>How can i do this one?</P><P></P><P>Is there any need to copy same master calendar and need to connect to ship date?</P><P></P><P>Please give me suggestions..</P><P></P><P>Thanks in advance</P><P></P><P>regards</P><P>Venkey</P></BODY></HTML> Wed, 20 Jul 2016 14:41:33 GMT https://community.qlik.com/t5/QlikView/fact-table-with-multiple-dates/m-p/1109768#M367144 venkey2847 2016-07-20T14:41:33Z Re: fact table with multiple dates https://community.qlik.com/t5/QlikView/fact-table-with-multiple-dates/m-p/1109769#M367145 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Read this excellent blog from Henric regarding canonical dates it should give you all the info you need. Let us know if you need anything further.</P><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P></BODY></HTML> Wed, 20 Jul 2016 15:32:41 GMT https://community.qlik.com/t5/QlikView/fact-table-with-multiple-dates/m-p/1109769#M367145 Anonymous 2016-07-20T15:32:41Z Re: fact table with multiple dates https://community.qlik.com/t5/QlikView/fact-table-with-multiple-dates/m-p/1109770#M367146 <HTML><HEAD></HEAD><BODY><P>See if this blog helps:</P><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P></BODY></HTML> Wed, 20 Jul 2016 15:33:36 GMT https://community.qlik.com/t5/QlikView/fact-table-with-multiple-dates/m-p/1109770#M367146 sunny_talwar 2016-07-20T15:33:36Z