topic needs cleaning up in QlikView https://community.qlik.com/t5/QlikView/needs-cleaning-up/m-p/221894#M74651 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-521_sourceID:521" /></P><P>I have a report that brings in historical Invoiced Sales (ZAPInvFinal), Static on hold and on pick orders (OnHoldOnPickFinal) and forecast sales (Forecast Final).</P><P>I cannot concatenate the ZAPInvFinal and OnHoldOnPickFinal as they are compatible but can I create a link table. I dont know how to do this.</P><P>At present the report works but I want to add the ForecastCustomerDiv into the OnHold OnPick sales but as it is a mess the file size goes from 4MB to 25MB</P><P>any help appreciated</P><P>David</P></BODY></HTML> Thu, 22 Oct 2009 13:02:32 GMT 2009-10-22T13:02:32Z needs cleaning up https://community.qlik.com/t5/QlikView/needs-cleaning-up/m-p/221894#M74651 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-521_sourceID:521" /></P><P>I have a report that brings in historical Invoiced Sales (ZAPInvFinal), Static on hold and on pick orders (OnHoldOnPickFinal) and forecast sales (Forecast Final).</P><P>I cannot concatenate the ZAPInvFinal and OnHoldOnPickFinal as they are compatible but can I create a link table. I dont know how to do this.</P><P>At present the report works but I want to add the ForecastCustomerDiv into the OnHold OnPick sales but as it is a mess the file size goes from 4MB to 25MB</P><P>any help appreciated</P><P>David</P></BODY></HTML> Thu, 22 Oct 2009 13:02:32 GMT https://community.qlik.com/t5/QlikView/needs-cleaning-up/m-p/221894#M74651 2009-10-22T13:02:32Z needs cleaning up https://community.qlik.com/t5/QlikView/needs-cleaning-up/m-p/221895#M74652 <HTML><HEAD></HEAD><BODY><P>I don't see why you could not concatenate these two similar tables. Simply add another column to each load statement indicating which source the data comes from. That will enable you to still distinguish the data.</P><P>Otherwise, there is a useful explanation of Link Tables at <A href="http://www.quickqlearqool.nl/?p=910">http://www.quickqlearqool.nl/?p=910</A></P></BODY></HTML> Thu, 22 Oct 2009 16:16:52 GMT https://community.qlik.com/t5/QlikView/needs-cleaning-up/m-p/221895#M74652 MichaelRobertshaw 2009-10-22T16:16:52Z