By renaming field names and sometimes by loading a table twice with different names. Qlikview is not an sql database where you can select the tables you want to use. In Qlikview all the data is connected all the time. Think of it as one big virtual table. If you look at it that way you'll understand there cannot be multiple paths like are possible in sql databases.
