topic Linest_M, calculating the slope in QlikView https://community.qlik.com/t5/QlikView/Linest-M-calculating-the-slope/m-p/1077793#M637125 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I need to calculate the slope of the trend per product/Department for 5 months in my script.</P><P>This wil be used later on in a dashboard to indicate if formentioned combination has a positive or negative trend.</P><P></P><P>The script I've thusfar is:</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/118053_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>2 Questions:</P><P>1. is it necessary to generate all combinations of Product/department/Dates with Amnt = 0 when they do not exist</P><P>2. Will the coding be appropriate in order to calculate the correct slope for the combinations...</P><P></P><P>thx in advance!</P></BODY></HTML> Tue, 15 Mar 2016 13:25:34 GMT 2016-03-15T13:25:34Z Linest_M, calculating the slope https://community.qlik.com/t5/QlikView/Linest-M-calculating-the-slope/m-p/1077793#M637125 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I need to calculate the slope of the trend per product/Department for 5 months in my script.</P><P>This wil be used later on in a dashboard to indicate if formentioned combination has a positive or negative trend.</P><P></P><P>The script I've thusfar is:</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/118053_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>2 Questions:</P><P>1. is it necessary to generate all combinations of Product/department/Dates with Amnt = 0 when they do not exist</P><P>2. Will the coding be appropriate in order to calculate the correct slope for the combinations...</P><P></P><P>thx in advance!</P></BODY></HTML> Tue, 15 Mar 2016 13:25:34 GMT https://community.qlik.com/t5/QlikView/Linest-M-calculating-the-slope/m-p/1077793#M637125 2016-03-15T13:25:34Z Re: Linest_M, calculating the slope https://community.qlik.com/t5/QlikView/Linest-M-calculating-the-slope/m-p/1077794#M637127 <HTML><HEAD></HEAD><BODY><P>sum is obsolete in the Linest_M statement</P></BODY></HTML> Wed, 16 Mar 2016 09:11:17 GMT https://community.qlik.com/t5/QlikView/Linest-M-calculating-the-slope/m-p/1077794#M637127 2016-03-16T09:11:17Z