Use different columns in set analysis calculation based on value of another column

[mkierin]

Hi, 

I'm relatively new to Qliksense. 

I have table A which has column M

Column M has three different values (x,y,z)

I have table B which has columns N,O,P

I want to create a set calculation that changes column is used in table B based on the values (x,y,z) of column M.   The values x,y,z are the same as the column names N,O,P. 

I hope I made my question clear. Thanks in advance for your help.

Now I want to