I need to create a logical forecasting system within qlikview.
I need to show the comparison between the actual sales figures Vs the Forecast
Every Month the future Forecasted figures are adjusted. But we still need to be able to see the previously forecasted figures.
I have two Tables.
Fact Table has the Actual Sales Figures.
Forecast Table has the Forecast Figures.
In the Forecast Table there is a field, "Reporting Period", Which indicates when this forecast was for
Logically we should compare Actual to the current forecast, but if at some point we need to compare the Forecast of the previous Reporting Period Vs The Actual how could we show this logically?
If I link Reporting Period to the Date in the Actual Table this will reflect incorrectly.
Maybe having a list box with the reporting periods, but what would I link to in the fact table to make it work logically?
