topic Table Join Question in QlikView https://community.qlik.com/t5/QlikView/Table-Join-Question/m-p/1034752#M933598 <HTML><HEAD></HEAD><BODY><P>There are tables:</P><P></P><P>Machine_Table:</P><P>Load </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Machine_name,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Install_Date</P><P>From....</P><P></P><P>Service_Table:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Service_OrderID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Machine_name,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Service_Date</P><P>From...</P><P></P><P>Calculate the Machine QTY and Service OrderID QTY.</P><P></P><P>1. Calculate the last 3 Months Machine QTY</P><P>2. Calculate the last 1 Months Service OrderID QTY of the related last 3 Months Installed Machine QTY</P><P></P><P>There are two date, I have no idea how connect two table and How to calcuate the Service OrderID QTY.</P><P>Please help . It's urgent. Thanks.</P></BODY></HTML> Fri, 26 Feb 2016 06:23:55 GMT 2016-02-26T06:23:55Z Table Join Question https://community.qlik.com/t5/QlikView/Table-Join-Question/m-p/1034752#M933598 <HTML><HEAD></HEAD><BODY><P>There are tables:</P><P></P><P>Machine_Table:</P><P>Load </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Machine_name,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Install_Date</P><P>From....</P><P></P><P>Service_Table:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Service_OrderID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Machine_name,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Service_Date</P><P>From...</P><P></P><P>Calculate the Machine QTY and Service OrderID QTY.</P><P></P><P>1. Calculate the last 3 Months Machine QTY</P><P>2. Calculate the last 1 Months Service OrderID QTY of the related last 3 Months Installed Machine QTY</P><P></P><P>There are two date, I have no idea how connect two table and How to calcuate the Service OrderID QTY.</P><P>Please help . It's urgent. Thanks.</P></BODY></HTML> Fri, 26 Feb 2016 06:23:55 GMT https://community.qlik.com/t5/QlikView/Table-Join-Question/m-p/1034752#M933598 2016-02-26T06:23:55Z Re: Table Join Question https://community.qlik.com/t5/QlikView/Table-Join-Question/m-p/1034753#M933601 <HTML><HEAD></HEAD><BODY><P>Hope this helps</P><P><A href="https://community.qlik.com/message/978980">return of tailback stock qty</A></P></BODY></HTML> Fri, 26 Feb 2016 10:53:15 GMT https://community.qlik.com/t5/QlikView/Table-Join-Question/m-p/1034753#M933601 Chanty4u 2016-02-26T10:53:15Z Re: Table Join Question https://community.qlik.com/t5/QlikView/Table-Join-Question/m-p/1034754#M933603 <HTML><HEAD></HEAD><BODY><P>Hi chen ,H<SPAN style="font-size: 10pt; line-height: 1.5em;">ave a nice day.</SPAN></P><P></P><P>Try to create link table</P><P></P><P><A href="http://www.qliktips.com/2011/05/rules-for-creating-keylink-table-in.html" title="http://www.qliktips.com/2011/05/rules-for-creating-keylink-table-in.html">Qlik Tips: Rules for creating a Key/Link Table in QlikView</A></P></BODY></HTML> Fri, 26 Feb 2016 11:16:12 GMT https://community.qlik.com/t5/QlikView/Table-Join-Question/m-p/1034754#M933603 2016-02-26T11:16:12Z