topic how can i create LinkTable from 2 Table in QVD in QlikView https://community.qlik.com/t5/QlikView/how-can-i-create-LinkTable-from-2-Table-in-QVD/m-p/145459#M24178 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Thank s for your Help.</P><P>Shideh</P><P></P></BODY></HTML> Tue, 02 Jun 2009 13:28:12 GMT 2009-06-02T13:28:12Z how can i create LinkTable from 2 Table in QVD https://community.qlik.com/t5/QlikView/how-can-i-create-LinkTable-from-2-Table-in-QVD/m-p/145457#M24176 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have two different Table:</P><P></P><P>OrderTable (has 20 Field For Example)</P><P>SalesDocId</P><P>CreateOrder as Datum</P><P>Linenr.</P><P>NetVal</P><P>DeliveryCharges</P><P></P><P></P><P>BillingTable (has 35 Field for Example)</P><P>SalesDocId</P><P>CreateBill as Datum</P><P>BillingNr.</P><P>NetSales</P><P>BillingType</P><P>Tax</P><P></P><P>Calendar (as normal Calendar)</P><P>Date</P><P>Week</P><P>Day</P><P></P><P>I will create LinkTabel in Qlikview :</P><P>Sales DocId (when (Sales DocId from OrderTable) = Sales DocId from BillingTable)</P><P>KeyDatum(when CreateOrder from OrderTable = CreateBill from BillingTable)</P><P>Where</P><P>BillingType from BillingTable = ZBV or ZCR1</P><P>distinct Sales DocId</P><P>When the LinkTable is Create, I will link KeyDatum to Calendar for crate a formula to Count SalesDocId from LinkTable with CalenderDatum:</P><P></P><P>Thanks</P><P>Shideh</P><P></P></BODY></HTML> Fri, 29 May 2009 19:11:51 GMT https://community.qlik.com/t5/QlikView/how-can-i-create-LinkTable-from-2-Table-in-QVD/m-p/145457#M24176 2009-05-29T19:11:51Z how can i create LinkTable from 2 Table in QVD https://community.qlik.com/t5/QlikView/how-can-i-create-LinkTable-from-2-Table-in-QVD/m-p/145458#M24177 <HTML><HEAD></HEAD><BODY><P>Check this out:</P><P><A href="http://www.naturalsynergies.com/LinkTable85_Qonnections.ppt">http://www.naturalsynergies.com/LinkTable85_Qonnections.ppt</A></P><P>Phil has put together a very nice presentation on this one.</P></BODY></HTML> Sat, 30 May 2009 01:53:39 GMT https://community.qlik.com/t5/QlikView/how-can-i-create-LinkTable-from-2-Table-in-QVD/m-p/145458#M24177 disqr_rm 2009-05-30T01:53:39Z how can i create LinkTable from 2 Table in QVD https://community.qlik.com/t5/QlikView/how-can-i-create-LinkTable-from-2-Table-in-QVD/m-p/145459#M24178 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Thank s for your Help.</P><P>Shideh</P><P></P></BODY></HTML> Tue, 02 Jun 2009 13:28:12 GMT https://community.qlik.com/t5/QlikView/how-can-i-create-LinkTable-from-2-Table-in-QVD/m-p/145459#M24178 2009-06-02T13:28:12Z how can i create LinkTable from 2 Table in QVD https://community.qlik.com/t5/QlikView/how-can-i-create-LinkTable-from-2-Table-in-QVD/m-p/145460#M24179 <HTML><HEAD></HEAD><BODY><P>Hi rakesh,</P><P></P><P>Do u have the example</P><P>Link Table85_Exercise.qvw which is referred in the PPT. I could not find it.<BR />Thanks in advance..</P><P>Sravan</P></BODY></HTML> Tue, 02 Jun 2009 16:37:37 GMT https://community.qlik.com/t5/QlikView/how-can-i-create-LinkTable-from-2-Table-in-QVD/m-p/145460#M24179 2009-06-02T16:37:37Z how can i create LinkTable from 2 Table in QVD https://community.qlik.com/t5/QlikView/how-can-i-create-LinkTable-from-2-Table-in-QVD/m-p/145461#M24180 <HTML><HEAD></HEAD><BODY><P>Hi Sravan,</P><P>do you found any example?</P><P>Thanks</P><P>Shideh</P><P></P><P></P></BODY></HTML> Wed, 03 Jun 2009 16:16:18 GMT https://community.qlik.com/t5/QlikView/how-can-i-create-LinkTable-from-2-Table-in-QVD/m-p/145461#M24180 2009-06-03T16:16:18Z how can i create LinkTable from 2 Table in QVD https://community.qlik.com/t5/QlikView/how-can-i-create-LinkTable-from-2-Table-in-QVD/m-p/145462#M24181 <HTML><HEAD></HEAD><BODY><P>Hallo Shideh,</P><P><BR />No I did not find the said example..</P></BODY></HTML> Wed, 03 Jun 2009 16:29:11 GMT https://community.qlik.com/t5/QlikView/how-can-i-create-LinkTable-from-2-Table-in-QVD/m-p/145462#M24181 2009-06-03T16:29:11Z