topic Join tables with expression in QlikView https://community.qlik.com/t5/QlikView/Join-tables-with-expression/m-p/388705#M485027 <HTML><HEAD></HEAD><BODY><P>I know this is an ignorant question, but how can I use values in one record from two different tables. In the picture below, I want to only get the Discount from Table2 matching on category instead of all values as it is now. Easy in sql but I haven't figured it out in Qlikview yet. I would like to avoid altering the load script if possible.</P><P></P><P><IMG __jive_id="41348" class="jive-image-thumbnail jive-image" height="256" onclick="" alt="Capture_04 May. 20.jpg" src="/legacyfs/online/41348_Capture_04 May. 20.jpg" style="height: 256px; width: 545.9715639810427px;" width="546" /></P></BODY></HTML> Mon, 20 May 2013 21:07:47 GMT 2013-05-20T21:07:47Z Join tables with expression https://community.qlik.com/t5/QlikView/Join-tables-with-expression/m-p/388705#M485027 <HTML><HEAD></HEAD><BODY><P>I know this is an ignorant question, but how can I use values in one record from two different tables. In the picture below, I want to only get the Discount from Table2 matching on category instead of all values as it is now. Easy in sql but I haven't figured it out in Qlikview yet. I would like to avoid altering the load script if possible.</P><P></P><P><IMG __jive_id="41348" class="jive-image-thumbnail jive-image" height="256" onclick="" alt="Capture_04 May. 20.jpg" src="/legacyfs/online/41348_Capture_04 May. 20.jpg" style="height: 256px; width: 545.9715639810427px;" width="546" /></P></BODY></HTML> Mon, 20 May 2013 21:07:47 GMT https://community.qlik.com/t5/QlikView/Join-tables-with-expression/m-p/388705#M485027 2013-05-20T21:07:47Z Re: Join tables with expression https://community.qlik.com/t5/QlikView/Join-tables-with-expression/m-p/388706#M485028 <HTML><HEAD></HEAD><BODY><P>You should associate the tables in the script by giving the category fields the same name. That's the easy Qlikview equivalent of your easy sql join. You can do it in expressions. You will also throw away the advantages of Qlikviews in-memory database and very likely enjoy horrible performance. </P><P></P><P>Try: if(Table1_category = Table2_category, Discount)</P></BODY></HTML> Tue, 21 May 2013 06:26:46 GMT https://community.qlik.com/t5/QlikView/Join-tables-with-expression/m-p/388706#M485028 Gysbert_Wassenaar 2013-05-21T06:26:46Z Re: Join tables with expression https://community.qlik.com/t5/QlikView/Join-tables-with-expression/m-p/388707#M485029 <HTML><HEAD></HEAD><BODY><P>Thanks again for your help Gysbert. I'm working to make this work but it will require two associations which unfortunately at the moment is causing a loop. I'm trying to understand why now; I'll let you know the results. Thanks again.</P></BODY></HTML> Thu, 23 May 2013 13:26:50 GMT https://community.qlik.com/t5/QlikView/Join-tables-with-expression/m-p/388707#M485029 2013-05-23T13:26:50Z