topic Re: Leverage polynomial trendlines in a script or expression in QlikView https://community.qlik.com/t5/QlikView/Leverage-polynomial-trendlines-in-a-script-or-expression/m-p/669696#M475620 <HTML><HEAD></HEAD><BODY><P>No, but thank's for asking.</P></BODY></HTML> Mon, 30 Nov 2015 16:10:16 GMT 2015-11-30T16:10:16Z Leverage polynomial trendlines in a script or expression https://community.qlik.com/t5/QlikView/Leverage-polynomial-trendlines-in-a-script-or-expression/m-p/669694#M475618 <HTML><HEAD></HEAD><BODY><P>The "Chart Properties: Expressions" contain a nice option of displaying the trendlines. For the linear trendline there is a corresponding linest family of statistical aggregation functions. However I have not found the way to do the same for other types of trendlines.</P><P>Do you know a way of getting Qlikview to calculate following trendline factors:</P><P><SPAN>Polynomial of 2nd degree, </SPAN><SPAN class="Bold">Polynomial of 3rd degree, </SPAN><SPAN class="Bold">Polynomial of 4th degree,</SPAN><SPAN>Exponential</SPAN></P><P>May be there is a way to leverage VBS or JavaScript to access that calculation?</P><P></P><P>What I need to do is to see which of my customers are deviating from the (e.g. <SPAN class="Bold">Polynomial of 3rd degree)</SPAN> forecast in most recent period. So in Qlikview there would be a chart with actual data vs trendline (this is already possible) and there will be a listbox with the calculated dimension "Deviation Flag".</P><P></P><P>The calculation of that Deviation Flag against forecast of <SPAN class="Bold">Polynomial of 3rd degree is what I need to create.<BR /></SPAN></P></BODY></HTML> Mon, 14 Jul 2014 12:35:59 GMT https://community.qlik.com/t5/QlikView/Leverage-polynomial-trendlines-in-a-script-or-expression/m-p/669694#M475618 2014-07-14T12:35:59Z Re: Leverage polynomial trendlines in a script or expression https://community.qlik.com/t5/QlikView/Leverage-polynomial-trendlines-in-a-script-or-expression/m-p/669695#M475619 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Did you find a solution for this?</SPAN></P></BODY></HTML> Mon, 30 Nov 2015 16:02:14 GMT https://community.qlik.com/t5/QlikView/Leverage-polynomial-trendlines-in-a-script-or-expression/m-p/669695#M475619 menta 2015-11-30T16:02:14Z Re: Leverage polynomial trendlines in a script or expression https://community.qlik.com/t5/QlikView/Leverage-polynomial-trendlines-in-a-script-or-expression/m-p/669696#M475620 <HTML><HEAD></HEAD><BODY><P>No, but thank's for asking.</P></BODY></HTML> Mon, 30 Nov 2015 16:10:16 GMT https://community.qlik.com/t5/QlikView/Leverage-polynomial-trendlines-in-a-script-or-expression/m-p/669696#M475620 2015-11-30T16:10:16Z Re: Leverage polynomial trendlines in a script or expression https://community.qlik.com/t5/QlikView/Leverage-polynomial-trendlines-in-a-script-or-expression/m-p/669697#M475621 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I hope I'm not too late.</P><P></P><P>You should see this website for the quadratic regression</P><P><A href="http://keisan.casio.com/exec/system/14059932254941" title="http://keisan.casio.com/exec/system/14059932254941">Quadratic regression Calculator - High accuracy calculation</A></P><P></P><P>You can create variables and easily calculate the coefficients.</P></BODY></HTML> Thu, 03 Mar 2016 21:07:19 GMT https://community.qlik.com/t5/QlikView/Leverage-polynomial-trendlines-in-a-script-or-expression/m-p/669697#M475621 2016-03-03T21:07:19Z