topic Re: Problems calculating Linest_b (way to high) in QlikView https://community.qlik.com/t5/QlikView/Problems-calculating-Linest-b-way-to-high/m-p/500916#M688959 <HTML><HEAD></HEAD><BODY><P>Got it:</P><P></P><P>b=Linest_M*min(x_Axis)+Linest_B</P></BODY></HTML> Thu, 28 Nov 2013 07:50:53 GMT Anonymous 2013-11-28T07:50:53Z Problems calculating Linest_b (way to high) https://community.qlik.com/t5/QlikView/Problems-calculating-Linest-b-way-to-high/m-p/500915#M688958 <HTML><HEAD></HEAD><BODY><P>Hello </P><P></P><P>I'm calculating a regression function for a chart. Im not using the integrated Forecast-Line as it is not calculated correctly due to a bug.</P><P>Linest_M = -0.039 and it seems correct. But Linest_B where x and y are chosen exactly the same way as in Linest_M is way to high = 1640 (and should be 7)</P><P></P><P>Am I doing sth terribly wrong?</P><P></P><P><IMG alt="Linest_B_1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/49631_Linest_B_1.png" style="width: 620px; height: 370px;" /></P><P><IMG alt="Linest_B_2.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/49632_Linest_B_2.png" /></P><P>= Linest_M _ Linest_B _ Linest_R2 </P><P></P><P>y= Value</P><P>x= TimeAxis</P><P></P><P>Apropos, in the chart b seems to be correct...</P><P></P><P>Any suggestions?</P><P>Thx in advance!</P><P></P><P>//chesterluck</P></BODY></HTML> Wed, 27 Nov 2013 15:51:53 GMT https://community.qlik.com/t5/QlikView/Problems-calculating-Linest-b-way-to-high/m-p/500915#M688958 Anonymous 2013-11-27T15:51:53Z Re: Problems calculating Linest_b (way to high) https://community.qlik.com/t5/QlikView/Problems-calculating-Linest-b-way-to-high/m-p/500916#M688959 <HTML><HEAD></HEAD><BODY><P>Got it:</P><P></P><P>b=Linest_M*min(x_Axis)+Linest_B</P></BODY></HTML> Thu, 28 Nov 2013 07:50:53 GMT https://community.qlik.com/t5/QlikView/Problems-calculating-Linest-b-way-to-high/m-p/500916#M688959 Anonymous 2013-11-28T07:50:53Z