topic Re: Calculate the linest in QlikView https://community.qlik.com/t5/QlikView/Calculate-the-linest/m-p/588146#M1112270 <HTML><HEAD></HEAD><BODY><P>It gives exactly the values i need but when i apply it to my file it gave different values. See the data</P><P></P><P>first i wrote a script to get the table values as i gave it to u</P><P><IMG alt="1.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54592_1.PNG.png" /></P><P></P><P>And in the table view values look like this</P><P></P><P><IMG alt="2.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54593_2.PNG.png" style="width: 620px; height: 370px;" /></P><P>and i apply the pivot table to make sure values match which gave me this</P><P></P><P><IMG alt="4.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54594_4.PNG.png" style="width: 620px; height: 590px;" /></P><P>which match the table values i gave you and then i did the slope and the values i got different. I feel its something to do with <STRONG style="text-decoration: underline;">percentage.</STRONG> </P></BODY></HTML> Sun, 09 Mar 2014 17:35:06 GMT 2014-03-09T17:35:06Z Calculate the linest https://community.qlik.com/t5/QlikView/Calculate-the-linest/m-p/588144#M1112268 <HTML><HEAD></HEAD><BODY><P>I Need to calculate the linest (Slope) for each given location so i can know if the trend is up or down.</P><P>In EXcel i used the formula&nbsp; = linest( range) which be bigger or less than zero</P><P></P><P></P><P>I attached the excel sheet. Please help me </P></BODY></HTML> Sat, 01 Mar 2014 11:53:49 GMT https://community.qlik.com/t5/QlikView/Calculate-the-linest/m-p/588144#M1112268 2014-03-01T11:53:49Z Re: Calculate the linest https://community.qlik.com/t5/QlikView/Calculate-the-linest/m-p/588145#M1112269 <HTML><HEAD></HEAD><BODY><P>Linest_m won't work with categorical values. So your x-axis values need the be numeric too. This can be done by for example creating Quarter as a dual field. See attached qvw.</P></BODY></HTML> Sun, 02 Mar 2014 19:15:41 GMT https://community.qlik.com/t5/QlikView/Calculate-the-linest/m-p/588145#M1112269 Gysbert_Wassenaar 2014-03-02T19:15:41Z Re: Calculate the linest https://community.qlik.com/t5/QlikView/Calculate-the-linest/m-p/588146#M1112270 <HTML><HEAD></HEAD><BODY><P>It gives exactly the values i need but when i apply it to my file it gave different values. See the data</P><P></P><P>first i wrote a script to get the table values as i gave it to u</P><P><IMG alt="1.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54592_1.PNG.png" /></P><P></P><P>And in the table view values look like this</P><P></P><P><IMG alt="2.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54593_2.PNG.png" style="width: 620px; height: 370px;" /></P><P>and i apply the pivot table to make sure values match which gave me this</P><P></P><P><IMG alt="4.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54594_4.PNG.png" style="width: 620px; height: 590px;" /></P><P>which match the table values i gave you and then i did the slope and the values i got different. I feel its something to do with <STRONG style="text-decoration: underline;">percentage.</STRONG> </P></BODY></HTML> Sun, 09 Mar 2014 17:35:06 GMT https://community.qlik.com/t5/QlikView/Calculate-the-linest/m-p/588146#M1112270 2014-03-09T17:35:06Z Re: Calculate the linest https://community.qlik.com/t5/QlikView/Calculate-the-linest/m-p/588147#M1112271 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Attached is my solution. Please let me know if this is what you meant to do.</P><P></P><P>/LC</P></BODY></HTML> Sat, 26 Jul 2014 19:11:47 GMT https://community.qlik.com/t5/QlikView/Calculate-the-linest/m-p/588147#M1112271 2014-07-26T19:11:47Z