topic Re: Add linear regression script to the already available curve in an x,y-diagram in Integration, Extension & APIs

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

Anonymous — Sat, 16 Nov 2024 08:04:00 GMT

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 — Wed, 25 Jul 2018 09:53:30 GMT

Hello Peter,

Did you try LINEST function ?

Regards

BalaBhaskar_Qlik — Wed, 25 Jul 2018 12:51:09 GMT

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))

BalaBhaskar_Qlik — Wed, 25 Jul 2018 12:51:42 GMT