I'm trying to make a calculation in QlikView (in the script). I have two tables but there is no key between them... I'll attach a supporting excel-document in which I have simplified my data.
In the excel-file I have a couple of variables. The variable "Company" is the general key between the different tables (Tables with the key "Company" is Positions, Price, Value and Turnover). But I also have a table called "Rule" and in my calculation (as you can see in the excel-sheet "Calculation") I want to link the "Rule" table to the other tables. The goal of this is to derive a premium based on how many days (tempVar in the excel-table "Calculation") it takes me to sell a position (based on a upper and lower boundary in the "Rule" table). In excel I can just use the function LOOKUP or some IF formulas. But how would I do this in QlikView when there is no link between the tables?
