Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

tracycrown
Contributor II

Trend Line

Dear all

Can someone help to explain how QV compute the b and m in trend line ?.

b : linest_b(Sales,t)

m : linest_m(Sales,t)

Thank you

Tracy

 

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Trend Line

See attached qvw.

The linest_b differs a bit, because linest_b uses 0 as start of the x-axis, while the chart doesn't include 0 on the x-axis. If you set the x-axis of the chart to Continuous you get the same values.


talk is cheap, supply exceeds demand
3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Trend Line

See attached qvw.

The linest_b differs a bit, because linest_b uses 0 as start of the x-axis, while the chart doesn't include 0 on the x-axis. If you set the x-axis of the chart to Continuous you get the same values.


talk is cheap, supply exceeds demand
tracycrown
Contributor II

Re: Trend Line

Dear Mr Gysbert_Wassenaar

Thank you very much for your kind advice, I have learned something new from you.

Wishing you and your family a Happy, Healthy and Prosperous New Year 2019.

Best Wishes

Tracy 

MVP & Luminary
MVP & Luminary

Re: Trend Line

Thanks! Best wishes to you too, Tracy.

talk is cheap, supply exceeds demand