Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
Can anyone tell me about forcasting in Qlikview.
Is it possible..? If yes then how to implement it and also provide me documents for the same.
Regards & Thanks,
Kaushik Solanki
So you basically want the forecast to be based always on the last sold month, ignoring seasonal changes etc?
Hi all
The "Before" function is only valid in pivot charts, in all other charts it will return NULL, which is why you get zero values in your columns.
I'm not sure of the best approach to do a a month over month. One way I've have done is to use macros, in this example I tried a different approach using rank() together with getpossiblecount() to figure out how to multiply the growthfactor.
In my attached example, I have 4 different ways of cacluating a forecast for next 12 months.
Best Regards,
Robert Svebeck
Hi,
I would be interested in having a glance on your file. May you please make it available ?
Thanks
Julien
Hi Robert,
Your example has turned out to be pretty helpful for me. i was wondering if you could assist me in figuring out how to do your forecast for more than one year.
Say for example i had Data for 2010 (july-dec) and 2011 (jan -dec)
How would I show values for the latest year (i.e max(year)) and then show a forecast for the next year?
I cant seem to figure out how to show the forecast line graphs onto the extended x axis but only for one single year. my values give me the current sales and a forecast for ALL my years .
Please Help.
Thanks
Sarah