topic Re: Forecast line overlay in QlikView

Forecast line overlay

Fri, 27 Mar 2015 16:06:20 GMT

Hi everyone,

My dashboard has a sand chart with sum(Amounts). Years go from 2010-2020. I would like to add a line to the chart that shows a forecast for 2015-2020, based on the trend in 2010-2014. The user could then compare that forecast line against the real data of sum(Amounts).

I first thought of overlaying a separate line chart on top of the existing sand chart, but I'm not quite sure what expression I would use. Any ideas?

Re: Forecast line overlay

Roop — Fri, 27 Mar 2015 16:22:59 GMT

I don't think that you can do exactly what you require, but I would be tempted to create a separate chart that would show the top part of the chart. I have included a sample.

The key items are to use ='<S2>' in your line style for the chart to turn it dashed and to use the same values when your lines are the same.

Hope this helps

Re: Forecast line overlay

Fri, 27 Mar 2015 17:34:54 GMT

Hi Rupert,

Thanks for the response. In many ways this is an elegant solution, and I was thinking of overlaying a chart on top as well.

The problem is that this data isn't dynamic - I want the chart to calculate a forecast regardless of my selection - something to the effect of "take the average of 2010-2015 and multiply 3% a year". I imagine this would be a complicated expression and need help writing it. Ultimately, I want to reach a point where the user could select the % growth per year.

Re: Forecast line overlay

Tue, 31 Mar 2015 16:31:42 GMT

Anyone else have any ideas?