topic Re: Computing Linest_M in QlikView https://community.qlik.com/t5/QlikView/Computing-Linest-M/m-p/658924#M475355 <HTML><HEAD></HEAD><BODY><P>It's correct for me.</P></BODY></HTML> Sun, 27 Jul 2014 07:28:06 GMT ecolomer 2014-07-27T07:28:06Z Computing Linest_M https://community.qlik.com/t5/QlikView/Computing-Linest-M/m-p/658923#M475354 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Attached is my solution for calculating the trend (slope) of business departments' sales revenue over a 6 months window.&nbsp; I like you to review my expression to make sure that (1) it is written correctly for the intent and (2) if there is a more efficient or more straight forward way of forming the aggregation / calculation. Thank you.</P><P></P><P>The data dimensions are as follow:</P><P></P><P>Business Unit = department</P><P>Client Number and Sub Analysis = customer and product</P><P>RevenueDate = sales date</P><P>#RevenueUSD = sales amount</P><P></P><P>The task is to calculate the revenue trend of each business unit over the set period.</P></BODY></HTML> Sat, 26 Jul 2014 19:36:12 GMT https://community.qlik.com/t5/QlikView/Computing-Linest-M/m-p/658923#M475354 2014-07-26T19:36:12Z Re: Computing Linest_M https://community.qlik.com/t5/QlikView/Computing-Linest-M/m-p/658924#M475355 <HTML><HEAD></HEAD><BODY><P>It's correct for me.</P></BODY></HTML> Sun, 27 Jul 2014 07:28:06 GMT https://community.qlik.com/t5/QlikView/Computing-Linest-M/m-p/658924#M475355 ecolomer 2014-07-27T07:28:06Z