Qlik to join 3 tables as per required

[amit_g]

Please review the data model.

What I need is for the pivot view to incorporate the following columns: Model and TMS_Model_Name.

The forecast_month and months contain similar data; how can I create one month column that aggregates the values of these two columns?

This is necessary because it overlaps two-month rows and the top row needs to be expanded to include the value, Current_Forecast_Quantity.

Please look at how its join too in data model and the Pivot.

[marcus_sommer]

The tables seems to contain equally data and therefore they should be merged per concatenate (union in sql) by unifying the field-names. Just adding manually an extra field [Source] to the loads is enough to be able to differentiate the sources per selections or dimensions or within set analysis conditions.