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

[Anonymous]

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]

Hello Peter,

Did you try LINEST function ?

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/ChartFunctions/StatisticalAgg...

Regards

[balabhaskarqlik]

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]

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/NestedAgg...