topic lookup from another table in memory in QlikView https://community.qlik.com/t5/QlikView/lookup-from-another-table-in-memory/m-p/537449#M200890 <HTML><HEAD></HEAD><BODY><P>I may not have titled this question well.&nbsp; I want to be able to do this after all of the data has been loaded.&nbsp; I'd like to load a table of factors, tFactors.&nbsp; Then, in another table tWorking, I want to use numbers from tFactors.&nbsp; The numbers from tFactors will depend on the row in tWorking but also will depend on other filtered values, such as a year.</P><P></P><P>Suppose I have a value, "V", in tWorking, which is the number of dollars accumulated up until date "D".&nbsp; D was selected by the user in the dashboard.&nbsp; 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.</P><P></P><P>Can I do this in QlikView?</P></BODY></HTML> Mon, 28 Oct 2013 19:01:05 GMT 2013-10-28T19:01:05Z lookup from another table in memory https://community.qlik.com/t5/QlikView/lookup-from-another-table-in-memory/m-p/537449#M200890 <HTML><HEAD></HEAD><BODY><P>I may not have titled this question well.&nbsp; I want to be able to do this after all of the data has been loaded.&nbsp; I'd like to load a table of factors, tFactors.&nbsp; Then, in another table tWorking, I want to use numbers from tFactors.&nbsp; The numbers from tFactors will depend on the row in tWorking but also will depend on other filtered values, such as a year.</P><P></P><P>Suppose I have a value, "V", in tWorking, which is the number of dollars accumulated up until date "D".&nbsp; D was selected by the user in the dashboard.&nbsp; 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.</P><P></P><P>Can I do this in QlikView?</P></BODY></HTML> Mon, 28 Oct 2013 19:01:05 GMT https://community.qlik.com/t5/QlikView/lookup-from-another-table-in-memory/m-p/537449#M200890 2013-10-28T19:01:05Z