Lookup to unrelated Table via Straight Table Expression

[Irvin182]

Hi Guys,

I need your expertise on how to lookup unrelated table via straight table expression.

I have here two unrelated tables and I need to lookup using expression and variables to get the MatrixVal.

 

I hope you can help me with my problem. see attached file.

Regards,

Irvin182

[lironbaram]

Hi , 
my first question to you is why don't you connect the tables, 
it will make the expressions easier, and you'll benefit from the qlik analytics engine 

[Irvin182]

Hi @lironbaram we didn't do that because we're making the data dynamic we will put a slider to make the data move. See the variable overview there's a vFTCountweight this will be the value of the slider