I have a bar chart with some sales calculations (expressions). However every time I select a time frame (e.g. Nov-Dez 2013) I want one of my expressions to be calculated for the next 2 months (Jan - Feb 2015) and displayed in my bar chart.
Has someone an example for this kind of forecasting?
If you have no data for this time period, basically, QlikView will not display anything. This means you need to manufacture this data.
You could create an inline table with the periods you want to be displayed and value 0.
Concatenate this table to your fact table. Then add an expression with your calculations for forecasting that is showing the forecast for the future or the actuals for the present.
The level of detail of the inline table will determine how much of little forecast information can be created.
