topic My Data Table: How do I link the date. in QlikView https://community.qlik.com/t5/QlikView/My-Data-Table-How-do-I-link-the-date/m-p/561074#M693440 <HTML><HEAD></HEAD><BODY><P>Hello, please check out my datastructure.</P><P><IMG alt="export.png" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/43857_export.png" width="450" /></P><P>I want to use the 'Datum' table with the dates also for StockDetails. How can I use the datum table for both tables?</P><P></P><P>MonthlyStockFinal contains a summary of the StockDetails for the end of each month. in StockDetails the StockDate field contains the date.</P></BODY></HTML> Wed, 10 Jul 2013 10:16:32 GMT 2013-07-10T10:16:32Z My Data Table: How do I link the date. https://community.qlik.com/t5/QlikView/My-Data-Table-How-do-I-link-the-date/m-p/561074#M693440 <HTML><HEAD></HEAD><BODY><P>Hello, please check out my datastructure.</P><P><IMG alt="export.png" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/43857_export.png" width="450" /></P><P>I want to use the 'Datum' table with the dates also for StockDetails. How can I use the datum table for both tables?</P><P></P><P>MonthlyStockFinal contains a summary of the StockDetails for the end of each month. in StockDetails the StockDate field contains the date.</P></BODY></HTML> Wed, 10 Jul 2013 10:16:32 GMT https://community.qlik.com/t5/QlikView/My-Data-Table-How-do-I-link-the-date/m-p/561074#M693440 2013-07-10T10:16:32Z Re: My Data Table: How do I link the date. https://community.qlik.com/t5/QlikView/My-Data-Table-How-do-I-link-the-date/m-p/561075#M693441 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>In ur stockdetails table create "Date" field</P><P>Then stockDetails table directly link to Datum table.</P><P>see below..........</P><P></P><P></P><P>StockDetails:</P><P>Load</P><P>..</P><P>..</P><P>KeyPart As %KeyPart,</P><P>StockDate</P><P>StockDate as Date</P><P>From.....</P><P></P><P></P><P>MonthlyStockFinal:</P><P>Load</P><P>Date As %date,</P><P>KeyPart As %KeyPart,</P><P>KeyPart,</P><P>EndOfMonthStock</P><P>From....</P></BODY></HTML> Wed, 10 Jul 2013 10:54:41 GMT https://community.qlik.com/t5/QlikView/My-Data-Table-How-do-I-link-the-date/m-p/561075#M693441 2013-07-10T10:54:41Z Re: My Data Table: How do I link the date. https://community.qlik.com/t5/QlikView/My-Data-Table-How-do-I-link-the-date/m-p/561076#M693442 <HTML><HEAD></HEAD><BODY><P>I tried this but I get Syn keys. Because of KeyPart</P></BODY></HTML> Wed, 10 Jul 2013 11:02:18 GMT https://community.qlik.com/t5/QlikView/My-Data-Table-How-do-I-link-the-date/m-p/561076#M693442 2013-07-10T11:02:18Z Re: My Data Table: How do I link the date. https://community.qlik.com/t5/QlikView/My-Data-Table-How-do-I-link-the-date/m-p/561077#M693443 <HTML><HEAD></HEAD><BODY><P>You can create a new fıeld with "date+keypart"&nbsp; in both stockdetails and monthlystokdinal tables.</P></BODY></HTML> Wed, 10 Jul 2013 11:09:30 GMT https://community.qlik.com/t5/QlikView/My-Data-Table-How-do-I-link-the-date/m-p/561077#M693443 2013-07-10T11:09:30Z