Data association issue

[RaMa]

I have 3 Tables

1. Sales - > Having Order#, Line#, SKU1, SKU2, Plant#, OrderQuantity - (consider SKU2 as substitute item for SKU1)

2. Item Master - > Mat#, SKU# (mapping is available for Mat1 to SKU1 and Mat2 to SKU2 in this table), 

3. Inventory Table - > Mat#, Plant# , Avl Qty

Using Association without using script is there a way to view

Order # , SKU1, OrderQuantity, Avl Qty (for SKU1) , SKU2, Avl Qty (for SKU2) 

[RaMa]

The scenario is in Qliksense environment