topic How to create a Link table in qlikview in QlikView https://community.qlik.com/t5/QlikView/How-to-create-a-Link-table-in-qlikview/m-p/714908#M475507 <HTML><HEAD></HEAD><BODY><P><STRONG>Please explain with One Simple Example </STRONG></P></BODY></HTML> Mon, 21 Jul 2014 07:25:20 GMT sgg_gaikwad 2014-07-21T07:25:20Z How to create a Link table in qlikview https://community.qlik.com/t5/QlikView/How-to-create-a-Link-table-in-qlikview/m-p/714908#M475507 <HTML><HEAD></HEAD><BODY><P><STRONG>Please explain with One Simple Example </STRONG></P></BODY></HTML> Mon, 21 Jul 2014 07:25:20 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-Link-table-in-qlikview/m-p/714908#M475507 sgg_gaikwad 2014-07-21T07:25:20Z Re: How to create a Link table in qlikview https://community.qlik.com/t5/QlikView/How-to-create-a-Link-table-in-qlikview/m-p/714909#M475508 <HTML><HEAD></HEAD><BODY><P>Please follow below link</P><P><A href="https://community.qlik.com/thread/71740">What is Link Tables? What is the use?</A></P><P></P><P>--Jai</P></BODY></HTML> Mon, 21 Jul 2014 07:29:56 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-Link-table-in-qlikview/m-p/714909#M475508 jsingh71 2014-07-21T07:29:56Z Re: How to create a Link table in qlikview https://community.qlik.com/t5/QlikView/How-to-create-a-Link-table-in-qlikview/m-p/714910#M475509 <HTML><HEAD></HEAD><BODY><P>Hi Jai,</P><P>Thanks for your Response&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Mon, 21 Jul 2014 07:39:23 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-Link-table-in-qlikview/m-p/714910#M475509 sgg_gaikwad 2014-07-21T07:39:23Z Re: How to create a Link table in qlikview https://community.qlik.com/t5/QlikView/How-to-create-a-Link-table-in-qlikview/m-p/714911#M475510 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this sample script</P><P>&nbsp; </P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sales:</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">A &amp; '_' &amp; B &amp; '_' &amp; C AS Key,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">A,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">B,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">C,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sales</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">FROM Table1;</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LinkTable:</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD DISTINCT</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">A &amp; '_' &amp; B &amp; '_' &amp; C AS Key,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">A,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">B,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">C,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">'Sales' AS Flag</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RESIDENT Sales;</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">DROP FIELDS A, B, C From Sales;</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Budget:</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">A &amp; '_' &amp; B &amp; '_' &amp; C AS Key,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">A,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">B,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">C,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Budget</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">FROM Table2;</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Concatenate(LinkTable)</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD DISTINCT</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">A &amp; '_' &amp; B &amp; '_' &amp; C AS Key,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">A,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">B,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">C,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit;">'Budget' AS Flag</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RESIDENT Budget;</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">DROP FIELDS A, B, C From Budget;</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hope this helps you.</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Regards,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Jagan.</P></BODY></HTML> Mon, 21 Jul 2014 07:45:23 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-Link-table-in-qlikview/m-p/714911#M475510 jagan 2014-07-21T07:45:23Z Re: How to create a Link table in qlikview https://community.qlik.com/t5/QlikView/How-to-create-a-Link-table-in-qlikview/m-p/714912#M475511 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Attached document may help you.</P></BODY></HTML> Mon, 21 Jul 2014 07:49:06 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-Link-table-in-qlikview/m-p/714912#M475511 Anonymous 2014-07-21T07:49:06Z