Calculated Dimensions based on different tables

[YJ_SG]

This is my data, three tables. Output when select [Product] , [Forecast Report], it should able to show what is the forecast Qty and Order Qty, Delta and On hand inventory.

In Excel, I am able to do it through SUMIFS(), not sure how QlikView works. Please help.

Forecast:
LOAD * INLINE [
Forecast Report,Product,Forecast Month,Forecast Qty
JAN,A,Feb,1500
JAN,A,Mar,1500
JAN,A,Apr,1500
JAN,B,Feb,2000
JAN,B,Mar,2000
JAN,B,Apr,2000
FEB,A,Mar,1200
FEB,A,Apr,1200
FEB,A,May,1200
FEB,B,Mar,1500
FEB,B,Apr,1500
FEB,B,May,1500
];

Order:
LOAD * INLINE [
Order Report,Product,Order Month,Order Qty
JAN,A,Feb,3000
JAN,A,Mar
JAN,A,Apr,1000
JAN,B,Feb
JAN,B,Mar
JAN,B,Apr,5000
FEB,A,Mar
FEB,A,Apr,1000
FEB,A,May
FEB,B,Mar
FEB,B,Apr
FEB,B,May,3000
];

Inventory:
Load * INLINE [
Inventory Month,Product,On Hand
JAN,A,1000
JAN,A,5000
FEB,A,2500
FEB,B,3000
];

[Brett_Bleess]

About the best I can offer would be the Help:

https://help.qlik.com/en-US/qlikview/April2020/Content/QV_HelpSites/Home.htm

Education site:

https://www.qlik.com/us/services/training

The Design Blog area of Community:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

You can also search YouTube to see if there are any posts there that may help too.