topic Trend lines question in QlikView

Trend lines question

jduenyas — Wed, 16 May 2012 01:49:14 GMT

Is there a way to tell what the values are for a Linear Trend Line at the 2 extremes? (at start point and at end point as they are graphed on the chart)

One can easily tell the "trend" by looking st the line, but can it be given numericaly?

Thanks

Josh

Trend lines question

kaushiknsolanki — Wed, 16 May 2012 05:54:51 GMT

HI,

What I understood from your requirement is that you need to show the values on the Trend line..?

Correct me if I am wrong and give us more clarification on what you want. If possible give example

Regards,

Kaushik Solanki

Re: Trend lines question

jonathandienst — Wed, 16 May 2012 06:32:28 GMT

I don't think it is possible to get the linear values from the chart, but you can calculate the values using QV's statistical functions

linest_m() gives the slope of the linear fit (m in y = mx + b)

linest_b() gives the y intercept (b in y = mx + b)

Hope that helps

Jonathan

Re: Trend lines question

jonathandienst — Wed, 16 May 2012 06:34:49 GMT

Or if you just want to display the fit equation, you can check the "Show Equation" box on the chart Properties | Expressions tab.

Trend lines question

jduenyas — Wed, 16 May 2012 16:52:28 GMT

Thank you Jonathan, This helps as all I am trying to achieve is identifying winners v losers over time.
If slope is positive then it is a winner else if it is negative then it is a loser.

That definitely helps.

Trend lines question

jduenyas — Wed, 16 May 2012 16:54:38 GMT

Kaushik, thank you for your reply. You can see the resolution to the question in my reply to Jonathan,

Re: Trend lines question

swarup_malli — Tue, 09 Oct 2012 15:25:39 GMT

Jonathan,

Is it possible to find the formula the trendline is using.. i wanted to create an expression in the chart that mimics the trend line..

Is it possible...

Swarup