topic Re: Rolling and Forecasting in QlikView

Rolling and Forecasting

Srinivas — Wed, 13 Aug 2014 10:07:37 GMT

Hi frds,

Here I want rolling months and Forecasting data based on IDs. I'm attaching my excel as well.

1.Here first tab i have rolling months like -1,-2,-3 like till -12. based on this we have to develop the rolling months data when i select ID that data should be showed previous 12 months sales data.

2.Second tab i have forecasting data have month wise. when i select any ID then data should be showed next 12 months data.

Thanks & Regards

Munna

Re: Rolling and Forecasting

amit_saini — Wed, 13 Aug 2014 10:09:31 GMT

Munna,

This attachment may help you.

Thanks,
AS

Re: Rolling and Forecasting

Srinivas — Wed, 13 Aug 2014 10:49:46 GMT

Hi Saini,

Forecasting is it ok we have month filed so we can achieved,

But in first tab Previous tab in that we don't have any date fields here we can do based on Previous months(Here months have -1,-2,-3...so on -12) in this case

My Expression is : Sum({<[Demand Time Series]>=-1 >} Adjusted_Demand_Qty) but it is wrong.

How we can do..?

Re: Rolling and Forecasting

Srinivas — Fri, 15 Aug 2014 10:15:52 GMT

Hi Friends,

Please help on this especially i am facing forecasting issue.