topic Prediction using Qlikview in QlikView https://community.qlik.com/t5/QlikView/Prediction-using-Qlikview/m-p/672586#M1087905 <HTML><HEAD></HEAD><BODY><P>Hi Seniors,<BR />I am new to Qlikview and trying to explore QV based on current project requirement.<BR />While working on one such request I came across analytical model that I have to implement using qlikview.<BR />It looks like Linear equation in the form of Y = B0 +B1.x&nbsp; ( Where B0and B1 calculated using below method)</P><P>X&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mean(x) (X-Mx)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Y-My)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (X-Mx) * (Y-My)<BR />2001&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5 <BR />2002&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 <BR />2003&nbsp; 16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>I am able to calculate Values in Tabular form, However I am not able to calculate these values in Variable using Sum as I want the Sum of above calculated columns. e.g. SUM(X-Mx) , Sum(Y-My) and Sum((X-Mx)*(Y-My)) and Sum of Squares of (X-Mx) values.<BR />I want these values so that I can calculate the coefficient and predict values of any Future X values and get its corrosponding Y values.</P><P>Please let me know in case if you need any further details from my side.</P><P>I know it much Tricky , however while going through your blogs it feels that you can help on this or atleaset guide me on this.</P><P>Appreciate your help and Thanks in advance.</P><P>Regards,<BR />Bhushan P</P></BODY></HTML> Fri, 13 Jun 2014 07:19:13 GMT 2014-06-13T07:19:13Z Prediction using Qlikview https://community.qlik.com/t5/QlikView/Prediction-using-Qlikview/m-p/672586#M1087905 <HTML><HEAD></HEAD><BODY><P>Hi Seniors,<BR />I am new to Qlikview and trying to explore QV based on current project requirement.<BR />While working on one such request I came across analytical model that I have to implement using qlikview.<BR />It looks like Linear equation in the form of Y = B0 +B1.x&nbsp; ( Where B0and B1 calculated using below method)</P><P>X&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mean(x) (X-Mx)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Y-My)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (X-Mx) * (Y-My)<BR />2001&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5 <BR />2002&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 <BR />2003&nbsp; 16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>I am able to calculate Values in Tabular form, However I am not able to calculate these values in Variable using Sum as I want the Sum of above calculated columns. e.g. SUM(X-Mx) , Sum(Y-My) and Sum((X-Mx)*(Y-My)) and Sum of Squares of (X-Mx) values.<BR />I want these values so that I can calculate the coefficient and predict values of any Future X values and get its corrosponding Y values.</P><P>Please let me know in case if you need any further details from my side.</P><P>I know it much Tricky , however while going through your blogs it feels that you can help on this or atleaset guide me on this.</P><P>Appreciate your help and Thanks in advance.</P><P>Regards,<BR />Bhushan P</P></BODY></HTML> Fri, 13 Jun 2014 07:19:13 GMT https://community.qlik.com/t5/QlikView/Prediction-using-Qlikview/m-p/672586#M1087905 2014-06-13T07:19:13Z