topic Re: Sales forecast in QlikView

Sales forecast

paolojolly — Tue, 21 Jul 2015 11:03:26 GMT

Hi, I'm not very experienced in QlikView and I need help to create pivot table starting from the attached file in which for each month remaining until the end of this year I have to calculate the sales forecast

For example:

Sale of item A from 01/01/2015 to today is 25420
Today is day 202 of the year
Sales for each day are 25420/202 = 125,8415842

31/07/2015 will be the 212 day of the year
I expect that sales at 31.07.2015 will be 125,8415842 * 212

31/08/2015 will be the 243 day of the year

I expect that sales at 31.08.2015 will be 125,8415842 * 243

the end result should be

Can someone help me?

thanks

Re: Sales forecast

tresB — Tue, 21 Jul 2015 11:21:42 GMT

Something like in attached?

Re: Sales forecast

Kushal_Chawda — Tue, 21 Jul 2015 12:02:40 GMT

Please see the attached with some changes

Re: Sales forecast

paolojolly — Tue, 21 Jul 2015 16:47:13 GMT

Thank you, your answer is helpful.

But what I need is to calculate the forecast until the end of the year and for different items

Then I need to calculate the forecast directly on the pivot table

thanks again

Re: Sales forecast

paolojolly — Tue, 21 Jul 2015 16:49:54 GMT

thanks but your solution stops with today date and I need to make the forecast until the end of year

Re: Sales forecast

Kushal_Chawda — Wed, 22 Jul 2015 05:47:11 GMT

Hi,

I have created the forecast data till year end for each item. I have slightly modified your excel till today's data. I have few questions

1) Either forecast data will be provided by Business (without value as it should be calculated) or you have to create the data?

If you have to create the data for each item then this approach will work for you as attached

2) I have created forecast values directly from script. So what do you mean by forecast directly on pivot?

Please see the attached.

Re: Sales forecast

paolojolly — Wed, 22 Jul 2015 06:10:02 GMT

Hi,

thanks for the reply
Forecast data will be provided by Business (data come from a database sql) and will not be entered
I have the need of filter data for different dimensions (nation, type of product, customer, ..)

and I think it is more flexible to make the forecast on the pivot expression

thanks