topic Re: Trend Line in QlikView

Trend Line

tracycrown — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Trend Line

Gysbert_Wassenaar — Mon, 31 Dec 2018 09:10:51 GMT

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.

Re: Trend Line

tracycrown — Wed, 02 Jan 2019 00:31:03 GMT

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

Re: Trend Line

Gysbert_Wassenaar — Wed, 02 Jan 2019 06:33:13 GMT

Thanks! Best wishes to you too, Tracy.