I'm looking at the Linest() functions and used a Load script found on the Qlik website (attached). The Linest_b() function gives a different value to the intercept value on the trendline equation, but the Linest_b() value appears to be right.
My guess it that the lineair reference line stops at X=1 and therefore show the value at X=1 as the linest_b value. Whereas your linest expression correctly calculates and show the value for X=0
My guess it that the lineair reference line stops at X=1 and therefore show the value at X=1 as the linest_b value. Whereas your linest expression correctly calculates and show the value for X=0
I can only assume that this behaviour was created like it is to show e.g. trendlines for data over time in a more 'natural' way (in a sense that it is only looking at the data points available), since the zero point for dates is quite arbitrarily chosen anyway.
