2 Replies Latest reply: May 23, 2013 9:26 AM by Adam Haithcox RSS

    Join tables with expression

    Adam Haithcox

      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.

       

      Capture_04 May. 20.jpg