Forecasting Expression

[#1]

All, I have a simple bar chart with 4 years of data, and I want to add an additional 5 years of forecasting data. Any advice. This is just dummy data for a demo, so as long as I can show something that's fine.

Year = [Service Year]

Spend = Sum([Total Spend])

[sunny_talwar]

What exactly are you aiming to do here? What is the plan, can you elaborate may be? and provide a sample?

[#3]

Its complex when you need a accurate forecasting, but for demonstration, why not add a trend line on the graph? It seems easier! Just right click the chart to find it out!

[ajsjoshua]

Hi,

Prediction function in QlikView

[#5 · Accepted solution]

Thanks all, but I found an alternative.