topic Link tables in QlikView https://community.qlik.com/t5/QlikView/Link-tables/m-p/232132#M83788 <HTML><HEAD></HEAD><BODY><P>Thanks Miguel!</P><P>It is the right syntax</P></BODY></HTML> Fri, 08 Oct 2010 13:57:00 GMT 2010-10-08T13:57:00Z Link tables https://community.qlik.com/t5/QlikView/Link-tables/m-p/232130#M83786 <HTML><HEAD></HEAD><BODY><P>Is it possible to link the two tables and give the right Rate by the good record in Table1</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 158pt; border-collapse: collapse;" width="211"><COLGROUP><COL style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;" width="67" /><COL span="2" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;" width="72" /></COLGROUP><TBODY><TR height="20" style="height: 15pt;"><TD class="xl65" height="20" style="width: 50pt; height: 15pt; background-color: transparent; border: #ece9d8;" width="67"><STRONG>TABLE 1</STRONG></TD><TD class="xl65" style="width: 54pt; background-color: transparent; border: #ece9d8;" width="72"><STRONG></STRONG></TD><TD class="xl65" style="width: 54pt; background-color: transparent; border: #ece9d8;" width="72"><STRONG></STRONG></TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt; background-color: transparent; border: #ece9d8;">Orderline</TD><TD style="background-color: transparent; border: #ece9d8;">OrderDate</TD><TD style="background-color: transparent; border: #ece9d8;">EUR value</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt; background-color: transparent; border: #ece9d8;">1</TD><TD align="right" class="xl63" style="background-color: transparent; border: #ece9d8;">15-1-2010</TD><TD class="xl64" style="background-color: transparent; border: #ece9d8;">10,00</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt; background-color: transparent; border: #ece9d8;">2</TD><TD align="right" class="xl63" style="background-color: transparent; border: #ece9d8;">15-2-2010</TD><TD class="xl64" style="background-color: transparent; border: #ece9d8;">10,00</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt; background-color: transparent; border: #ece9d8;">3</TD><TD align="right" class="xl63" style="background-color: transparent; border: #ece9d8;">15-3-2010</TD><TD class="xl64" style="background-color: transparent; border: #ece9d8;">10,00</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt; background-color: transparent; border: #ece9d8;">4</TD><TD align="right" class="xl63" style="background-color: transparent; border: #ece9d8;">15-4-2010</TD><TD class="xl64" style="background-color: transparent; border: #ece9d8;">10,00</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt; background-color: transparent; border: #ece9d8;">5</TD><TD align="right" class="xl63" style="background-color: transparent; border: #ece9d8;">15-5-2010</TD><TD class="xl64" style="background-color: transparent; border: #ece9d8;">10,00</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt; background-color: transparent; border: #ece9d8;">6</TD><TD align="right" class="xl63" style="background-color: transparent; border: #ece9d8;">15-6-2010</TD><TD class="xl64" style="background-color: transparent; border: #ece9d8;">10,00</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="height: 15pt; background-color: transparent; border: #ece9d8;">7</TD><TD align="right" class="xl63" style="background-color: transparent; border: #ece9d8;">15-7-2010</TD><TD class="xl64" style="background-color: transparent; border: #ece9d8;">10,00</TD></TR></TBODY></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 169pt; border-collapse: collapse;" width="225"><COLGROUP><COL style="width: 66pt; mso-width-source: userset; mso-width-alt: 3218;" width="88" /><COL style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;" width="69" /><COL style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;" width="68" /></COLGROUP><TBODY><TR height="20" style="height: 15pt;"><TD class="xl66" height="20" style="width: 66pt; height: 15pt; background-color: transparent; border: #ece9d8;" width="88"><STRONG>TABLE 2</STRONG></TD><TD class="xl66" style="width: 52pt; background-color: transparent; border: #ece9d8;" width="69"><STRONG></STRONG></TD><TD class="xl66" style="width: 51pt; background-color: transparent; border: #ece9d8;" width="68"><STRONG></STRONG></TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt; background-color: transparent; border: #ece9d8;">Date from</TD><TD style="background-color: transparent; border: #ece9d8;">Date until</TD><TD style="background-color: transparent; border: #ece9d8;">USD Rate</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" class="xl65" height="20" style="height: 15pt; background-color: transparent; border: #ece9d8;">1-1-2010</TD><TD align="right" class="xl65" style="background-color: transparent; border: #ece9d8;">31-3-2010</TD><TD align="right" style="background-color: transparent; border: #ece9d8;">1,25</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" class="xl65" height="20" style="height: 15pt; background-color: transparent; border: #ece9d8;">1-4-2010</TD><TD align="right" class="xl65" style="background-color: transparent; border: #ece9d8;">30-6-2010</TD><TD align="right" style="background-color: transparent; border: #ece9d8;">1,29</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" class="xl65" height="20" style="height: 15pt; background-color: transparent; border: #ece9d8;">1-7-2010</TD><TD align="right" class="xl65" style="background-color: transparent; border: #ece9d8;">30-9-2010</TD><TD align="right" style="background-color: transparent; border: #ece9d8;">1,34</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 08 Oct 2010 13:21:54 GMT https://community.qlik.com/t5/QlikView/Link-tables/m-p/232130#M83786 2010-10-08T13:21:54Z Link tables https://community.qlik.com/t5/QlikView/Link-tables/m-p/232131#M83787 <HTML><HEAD></HEAD><BODY><P>Hello Alfred,</P><P>Check the sample code in <A href="http://community.qlik.com/forums/p/34022/132389.aspx" target="_blank">this post</A>.</P><P>Hope that helps!</P></BODY></HTML> Fri, 08 Oct 2010 13:25:09 GMT https://community.qlik.com/t5/QlikView/Link-tables/m-p/232131#M83787 Miguel_Angel_Baeyens 2010-10-08T13:25:09Z Link tables https://community.qlik.com/t5/QlikView/Link-tables/m-p/232132#M83788 <HTML><HEAD></HEAD><BODY><P>Thanks Miguel!</P><P>It is the right syntax</P></BODY></HTML> Fri, 08 Oct 2010 13:57:00 GMT https://community.qlik.com/t5/QlikView/Link-tables/m-p/232132#M83788 2010-10-08T13:57:00Z