Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Creating A Forecast Chart!

Dear all,

How can I create a Sales Forecast chart (showing current sales (have data until 2011) and forecast of next year (say 2012)  in my QV document. I have YearForecast and Sales as dimensions.

Help appreciated.

Thanks.

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Creating A Forecast Chart!

Hi Khaled

Use the time as your dimension, then you need to enter two expressions, one for the forecast, one for the actual sales.

EG dimension = month

expr1 = sum(Sales)

expr2 = sum(YearForecast)

is this what you need?

Regards,

Erica

2 Replies
Not applicable

Creating A Forecast Chart!

Hi Khaled

Use the time as your dimension, then you need to enter two expressions, one for the forecast, one for the actual sales.

EG dimension = month

expr1 = sum(Sales)

expr2 = sum(YearForecast)

is this what you need?

Regards,

Erica

Not applicable

Creating A Forecast Chart!

Thanks Erica. It worked.