topic Crosstable links in QlikView https://community.qlik.com/t5/QlikView/Crosstable-links/m-p/201972#M59839 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Please advise on the correct code to link the following crosstable with another table. I tried join, concatenate and keep but couldn't get the answer that I was looking for.</P><P>Fund_Perf:<BR />CROSSTABLE(Fund_ID, Fund_Perf)<BR />LOAD Date,<BR /> [15893],<BR /> [2878],<BR /> [2882],<BR /> [10826],<BR />FROM ...;<BR /><BR /><BR />Fund_Info:<BR />Load Fund_ID,<BR /> Fund_Name<BR />FROM ...;</P><P></P><P>Thank you</P></BODY></HTML> Sun, 04 Apr 2010 21:18:27 GMT 2010-04-04T21:18:27Z Crosstable links https://community.qlik.com/t5/QlikView/Crosstable-links/m-p/201972#M59839 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Please advise on the correct code to link the following crosstable with another table. I tried join, concatenate and keep but couldn't get the answer that I was looking for.</P><P>Fund_Perf:<BR />CROSSTABLE(Fund_ID, Fund_Perf)<BR />LOAD Date,<BR /> [15893],<BR /> [2878],<BR /> [2882],<BR /> [10826],<BR />FROM ...;<BR /><BR /><BR />Fund_Info:<BR />Load Fund_ID,<BR /> Fund_Name<BR />FROM ...;</P><P></P><P>Thank you</P></BODY></HTML> Sun, 04 Apr 2010 21:18:27 GMT https://community.qlik.com/t5/QlikView/Crosstable-links/m-p/201972#M59839 2010-04-04T21:18:27Z Crosstable links https://community.qlik.com/t5/QlikView/Crosstable-links/m-p/201973#M59840 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You don't need. QV guess the link between the 2 tables.</P><P>Anyway, you can use a Concatenate load</P><P></P><P>// Fund_Info:<BR />Concatenate Load Fund_ID,<BR /> Fund_Name<BR />FROM ...;</P><P></P><P>jj</P></BODY></HTML> Mon, 05 Apr 2010 19:11:14 GMT https://community.qlik.com/t5/QlikView/Crosstable-links/m-p/201973#M59840 2010-04-05T19:11:14Z Crosstable links https://community.qlik.com/t5/QlikView/Crosstable-links/m-p/201974#M59841 <HTML><HEAD></HEAD><BODY><P>Doesn't look like Concatenate should be your answer. I'd think more along the lines of "left join". What was, however, the answer that you were looking for? It's not totally clear from your message...</P><P></P><DIV id="refHTML"></DIV></BODY></HTML> Tue, 06 Apr 2010 05:39:05 GMT https://community.qlik.com/t5/QlikView/Crosstable-links/m-p/201974#M59841 Oleg_Troyansky 2010-04-06T05:39:05Z