Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Forcasting in Qlikview

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
13 Replies
RSvebeck
Specialist
Specialist

So you basically want the forecast to be based always on the last sold month, ignoring seasonal changes etc?

Svebeck Consulting AB
RSvebeck
Specialist
Specialist

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

Svebeck Consulting AB
Not applicable

Hi,

I would be interested in having a glance on your file. May you please make it available ?

Thanks

Julien

Anonymous
Not applicable

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