I may not have titled this question well. I want to be able to do this after all of the data has been loaded. I'd like to load a table of factors, tFactors. Then, in another table tWorking, I want to use numbers from tFactors. The numbers from tFactors will depend on the row in tWorking but also will depend on other filtered values, such as a year.
Suppose I have a value, "V", in tWorking, which is the number of dollars accumulated up until date "D". D was selected by the user in the dashboard. Using "D" I want to display an adjusted value of "V", which will use 2 numbers from tFactor, based on "D" and also based on some other columns in tWorking.
Can I do this in QlikView?