Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
RaMa
Contributor
Contributor

Data association issue

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) 

 

 

 

 

Labels (1)
1 Reply
RaMa
Contributor
Contributor
Author

The scenario is in Qliksense environment