Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

How do I calculate the value of a forecast?

I have a bar chart with data from 2009 to present.

I have a trend line, with forecast going forwards 10 months.

What I need to calculate is the total value for those forecast months.

forecast.jpg

Any idea how I do this? I can't see how to reveal any numbers in the trend line (indeed my research tells me thats not possible) and I can't see a way to show the equation for the trend line.

Any ideas?

Thanks for looking

Rob

6 Replies
Highlighted
Not applicable

Re: How do I calculate the value of a forecast?

On Chart Properties > Expressions > Select 'Show Equation' under 'Trendlines':

Capture.JPG

Highlighted
Not applicable

Re: How do I calculate the value of a forecast?

Hi,

Thanks for the response.

On my Qlikview (V11.00.11282.0 SR1 64-bit Edition (x64) ) that option is greyed out. I can't click it.

Is this a limitation of the personal edition? If so is there another way to to do this? (If not, how do I fix it?)

Highlighted
Not applicable

Re: How do I calculate the value of a forecast?

Mine does that too. It's weird, you have to select inside the line to make it not greyed out.

What it looks like at first:

Capture.JPG

When you click on the line 'Linear':

Capture.JPG

Highlighted
Not applicable

Re: How do I calculate the value of a forecast?

It's easiest if you de-select it and re-select it by the way.

Highlighted
MVP
MVP

Re: How do I calculate the value of a forecast?

If you want to actually use the value of the slope of your trend line in another calculation, look into the linest_m (resp. linest_b) functions.

{in the Help, chapter "Statistical Aggregation Functions in Charts")

Hope this helps,

Stefan

Highlighted
Not applicable

Re: How do I calculate the value of a forecast?

Hi guys,

Thanks for that.

Stefan, what I ultimately need is effectively the area underneath it, so that will help greatly. Thanks.