topic curve fitting / best fit curve - least squares method ? in App Development https://community.qlik.com/t5/App-Development/curve-fitting-best-fit-curve-least-squares-method/m-p/1326163#M28762 <HTML><HEAD></HEAD><BODY><P>Hi dear community of Qlikers ! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P><P></P><P><EM>You'll find enclosed the excel table I'm referring for this issue, and the qlik sense app related.</EM></P><P></P><P>So ! As you will see, I have a quite simple table with three raws : Product type, Year and Sales. I draw on Qlik Sense the visualization showing the evolution of the sales per year and per Product type. So far, so good.</P><P>If you look carefully at the data, I don't have any Sales figure for product type D, in 2010. It's intentionnal. As we can see, the red curve of product D is quite similar to the blue curve of product A, but way different of the profiles of the curves for product B and C. </P><P></P><P>What i would like to do is finding a way in Qlik Sense to find which Product type has had the most similar Sales evolution to my product D (in our case, we can see it, it's product A). Secondly, if this is possible, I would like to "forecast" the evolution of product D, based on the evolution of this most similar curve.</P><P>I guess I will have to use like a least squares method or something, but I really don't figure out how to perform it...</P><P></P><P>I hope I have been clear in my description ! Don't hesitate to ask me more precisions if not.</P><P></P><P>And thanks so much in advance for your help.</P><P></P><P>Long life to Qlik comunity and the cooperation it brings !! </P></BODY></HTML> Tue, 04 Jul 2017 15:14:08 GMT 2017-07-04T15:14:08Z curve fitting / best fit curve - least squares method ? https://community.qlik.com/t5/App-Development/curve-fitting-best-fit-curve-least-squares-method/m-p/1326163#M28762 <HTML><HEAD></HEAD><BODY><P>Hi dear community of Qlikers ! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P><P></P><P><EM>You'll find enclosed the excel table I'm referring for this issue, and the qlik sense app related.</EM></P><P></P><P>So ! As you will see, I have a quite simple table with three raws : Product type, Year and Sales. I draw on Qlik Sense the visualization showing the evolution of the sales per year and per Product type. So far, so good.</P><P>If you look carefully at the data, I don't have any Sales figure for product type D, in 2010. It's intentionnal. As we can see, the red curve of product D is quite similar to the blue curve of product A, but way different of the profiles of the curves for product B and C. </P><P></P><P>What i would like to do is finding a way in Qlik Sense to find which Product type has had the most similar Sales evolution to my product D (in our case, we can see it, it's product A). Secondly, if this is possible, I would like to "forecast" the evolution of product D, based on the evolution of this most similar curve.</P><P>I guess I will have to use like a least squares method or something, but I really don't figure out how to perform it...</P><P></P><P>I hope I have been clear in my description ! Don't hesitate to ask me more precisions if not.</P><P></P><P>And thanks so much in advance for your help.</P><P></P><P>Long life to Qlik comunity and the cooperation it brings !! </P></BODY></HTML> Tue, 04 Jul 2017 15:14:08 GMT https://community.qlik.com/t5/App-Development/curve-fitting-best-fit-curve-least-squares-method/m-p/1326163#M28762 2017-07-04T15:14:08Z Re: curve fitting / best fit curve - least squares method ? https://community.qlik.com/t5/App-Development/curve-fitting-best-fit-curve-least-squares-method/m-p/1326164#M28763 <HTML><HEAD></HEAD><BODY><P>Up ! Help pleaaaaaase</P></BODY></HTML> Mon, 24 Jul 2017 14:49:52 GMT https://community.qlik.com/t5/App-Development/curve-fitting-best-fit-curve-least-squares-method/m-p/1326164#M28763 2017-07-24T14:49:52Z