topic Re: Using Common Calendar for multiple table in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Using-Common-Calendar-for-multiple-table/m-p/1246217#M2426 <HTML><HEAD></HEAD><BODY><P>I don't see what your common date has to do with hotel names. Those aren't dates. You need to get the dates from the different tables into the link table and replace them in those tables with a date key. Perhaps this document helps: <A href="https://community.qlik.com/docs/DOC-5834">Linking to two or more dates</A></P></BODY></HTML> Mon, 12 Dec 2016 13:31:20 GMT Gysbert_Wassenaar 2016-12-12T13:31:20Z Using Common Calendar for multiple table https://community.qlik.com/t5/Connectivity-Data-Prep/Using-Common-Calendar-for-multiple-table/m-p/1246216#M2425 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Below is a screenshot of the data model with the common calendar I created. However I'm not able to use the dates in the ocmmon calendar as filters for my charts. Can anyone suggest me where I'm going wrong here? <BR />Thanks</P></BODY></HTML> Mon, 12 Dec 2016 12:54:48 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Using-Common-Calendar-for-multiple-table/m-p/1246216#M2425 2016-12-12T12:54:48Z Re: Using Common Calendar for multiple table https://community.qlik.com/t5/Connectivity-Data-Prep/Using-Common-Calendar-for-multiple-table/m-p/1246217#M2426 <HTML><HEAD></HEAD><BODY><P>I don't see what your common date has to do with hotel names. Those aren't dates. You need to get the dates from the different tables into the link table and replace them in those tables with a date key. Perhaps this document helps: <A href="https://community.qlik.com/docs/DOC-5834">Linking to two or more dates</A></P></BODY></HTML> Mon, 12 Dec 2016 13:31:20 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Using-Common-Calendar-for-multiple-table/m-p/1246217#M2426 Gysbert_Wassenaar 2016-12-12T13:31:20Z Re: Using Common Calendar for multiple table https://community.qlik.com/t5/Connectivity-Data-Prep/Using-Common-Calendar-for-multiple-table/m-p/1246218#M2427 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P>The document link you shared links all the dates in tables using OrderID I guess. The four tables in my data doesn't have such a unique ID common to all tables. Any suggestions how to link them?</P><P>I'm sorry, I'm new to Qlik Sense hence don't know much about data modelling. I'd really appreciate any help.</P><P>Thanks.</P></BODY></HTML> Tue, 13 Dec 2016 12:58:31 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Using-Common-Calendar-for-multiple-table/m-p/1246218#M2427 2016-12-13T12:58:31Z