How to match Forecast with Actuals Data

[homee]

Hi Qlik Community,

for the financial reporting i want to compare actuals with forecast. We are getting orders (many many per day) and we have a monthly target. So i have a table with the forecast data that consists of the revenue which always occurs on the first os each month.  And a i have that huge table with all orders inside. Now i have two variables fc_date and Date (which is from my master calendar). If i now put everything in the analysis fc_date is not matched to Date, which is a problem for the visualization and also if i use the calendar field. In the picture it is also gruouped by our channels. If i change anything in the date field only the actuals respond to that and the forecast revenue in the graph is totally off...