Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
Please can you assist me.
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?
Any Ideas will be appreciated.
Thanks
try using alternate states.
The user can select from a list-box which period to compare with actual s
and you can display both on a chart