topic Bar Chart - Forecasting in QlikView

Bar Chart - Forecasting

Wed, 17 Dec 2014 10:02:23 GMT

Hi guys,

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?

Best

HarryLee

Re: Bar Chart - Forecasting

amit_saini — Wed, 17 Dec 2014 10:07:00 GMT

Harry ,

This may help u.

Thanks,

Re: Bar Chart - Forecasting

Michiel_QV_Fan — Wed, 17 Dec 2014 10:09:13 GMT

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.

Re: Bar Chart - Forecasting

Wed, 17 Dec 2014 12:06:57 GMT

Hi guys,

Many thanks! Exactly what i needed to know

Best

Harry