Add linear regression script to the already availa... - Qlik Community

Anonymous · ‎2018-06-20

How can I add the available script for linear regression (to be chosen from the QLIK functions list) to a curve in an x,y-diagram?

I have chosen the right function, positioned it within the available x,y-diagram script, but the linear regression line was not added to the curve.

yannick_c · ‎2018-07-25

Hello Peter,

Did you try LINEST function ?

Regards

balabhaskarqlik · ‎2018-07-25

May be this:

You can use below two expressions in your chart aggregated over the dimension.

=LINEST_M(aggr(Avg({TW1}($(vActiveUnitField))),Cofely.Id),aggr(Avg({TW1}Cofely.Temperature),Cofely.Id))

=LINEST_B(aggr(Avg({TW1}($(vActiveUnitField))),Cofely.Id),aggr(Avg({TW1}Cofely.Temperature),Cofely.Id))

balabhaskarqlik · ‎2018-07-25

Add linear regression script to the already available curve in an x,y-diagram