Hi there my first every post on Qlik Community so fingers crossed it solves my problem.
I have an app that uses 2 tables one being a QVD file that contains records against a company code 503,506,509,ext the other table is a reference data table the maps Company codes to Business . There are thousands of company codes and 5 or 6 businesses. I want to control the data load so I can create an App for just one business by filtering the data load to just give me the relevant records for the distinct set of company codes. I don't want to create 1000s of filters. Can I reference the other table in the data load to filter out the data ?