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.
Try: if(Table1_category = Table2_category, Discount)