topic expressions available in table form for slope and y-intercept? in QlikView https://community.qlik.com/t5/QlikView/expressions-available-in-table-form-for-slope-and-y-intercept/m-p/708098#M1073244 <HTML><HEAD></HEAD><BODY><P>I'm working with data that needs to be in straight table format, and am trying to create a couple of expressions that so far I haven't found available in the list of mathematical operators.&nbsp; Specifically, I'm looking for a way to show the slope and y-intercept based on a set of numerical values.</P><P></P><P>Another way of putting that is I'm trying to replicate the data analysis regression function that I use in Excel, but figure out how to do it in QlikView instead.&nbsp; Any ideas?&nbsp; Thanks!</P></BODY></HTML> Tue, 19 Aug 2014 18:16:47 GMT 2014-08-19T18:16:47Z expressions available in table form for slope and y-intercept? https://community.qlik.com/t5/QlikView/expressions-available-in-table-form-for-slope-and-y-intercept/m-p/708098#M1073244 <HTML><HEAD></HEAD><BODY><P>I'm working with data that needs to be in straight table format, and am trying to create a couple of expressions that so far I haven't found available in the list of mathematical operators.&nbsp; Specifically, I'm looking for a way to show the slope and y-intercept based on a set of numerical values.</P><P></P><P>Another way of putting that is I'm trying to replicate the data analysis regression function that I use in Excel, but figure out how to do it in QlikView instead.&nbsp; Any ideas?&nbsp; Thanks!</P></BODY></HTML> Tue, 19 Aug 2014 18:16:47 GMT https://community.qlik.com/t5/QlikView/expressions-available-in-table-form-for-slope-and-y-intercept/m-p/708098#M1073244 2014-08-19T18:16:47Z Re: expressions available in table form for slope and y-intercept? https://community.qlik.com/t5/QlikView/expressions-available-in-table-form-for-slope-and-y-intercept/m-p/708099#M1073245 <HTML><HEAD></HEAD><BODY><P>a sample data set may be helpful. but in qlikview, open help and search for regression functions. qlikview has quite a few statistical functions that should help with your requirement.</P><P></P><P>you may be able to find some very useful threads and other resources using search on this page. i just pasted a few links that may be helpful to you:</P><P><A href="https://community.qlik.com/message/320058">How to calculate regression line, slope ?</A></P><P><A href="https://community.qlik.com/message/16477">Linear regression</A></P><P><A href="https://community.qlik.com/message/16477">Linear regression</A> </P></BODY></HTML> Tue, 19 Aug 2014 18:24:43 GMT https://community.qlik.com/t5/QlikView/expressions-available-in-table-form-for-slope-and-y-intercept/m-p/708099#M1073245 Anonymous 2014-08-19T18:24:43Z