topic Re: How to calculate the Linest in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-the-Linest/m-p/624004#M1112706 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/96544">Gysbert Wassenaar</A> and <A href="https://community.qlik.com/qlik-users/120618">Manish Kachhia</A> can u please help in this. REALLY important for me and sure you can solve it <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 25 Feb 2014 07:14:29 GMT 2014-02-25T07:14:29Z How to calculate the Linest https://community.qlik.com/t5/QlikView/How-to-calculate-the-Linest/m-p/624003#M1112705 <HTML><HEAD></HEAD><BODY><P>I have the following Excel sheet:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="169" style="width: 469px; height: 143px;"><TBODY><TR><TD class="xl77" height="17" width="98">Facility</TD><TD class="xl78" style="border-left: none;" width="107">Q1</TD><TD class="xl78" style="border-left: none;" width="103">Q2</TD><TD class="xl78" style="border-left: none;" width="89">Q3</TD><TD class="xl78" style="border-left: none;" width="65">Q4</TD><TD class="xl78" style="border-left: none;" width="70">2013 Average</TD><TD class="xl79" style="border-left: none;" width="47">Target</TD><TD class="xl80" width="53">Trend</TD></TR><TR><TD class="xl72" height="17" style="border-top: none;">Bateen</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">92%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">90%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">89%</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">91%</TD><TD align="right" class="xl73" style="border-top: none; border-left: none;">89%</TD><TD class="xl74" style="border-top: none;">Decreasing</TD><TD align="right" class="xl76" style="border-left: none;">-0.0099</TD></TR><TR><TD class="xl72" height="17" style="border-top: none;">Khaleej</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">92%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">94%</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">93%</TD><TD align="right" class="xl73" style="border-top: none; border-left: none;">89%</TD><TD class="xl75" style="border-top: none;">Increasing</TD><TD align="right" class="xl76" style="border-top: none; border-left: none;">0.00766</TD></TR><TR><TD class="xl72" height="17" style="border-top: none;">Etihad</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">98%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">94%</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">96%</TD><TD align="right" class="xl73" style="border-top: none; border-left: none;">89%</TD><TD class="xl74" style="border-top: none;">Decreasing</TD><TD class="xl76" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl72" height="17" style="border-top: none;">Rawda</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">92%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">92%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">95%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">92%</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">92%</TD><TD align="right" class="xl73" style="border-top: none; border-left: none;">89%</TD><TD class="xl75" style="border-top: none;">Increasing</TD><TD align="right" class="xl76" style="border-top: none; border-left: none;">0.00362</TD></TR><TR><TD class="xl72" height="17" style="border-top: none;">Zafarana</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">86%</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">88%</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">85%</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">84%</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">86%</TD><TD align="right" class="xl73" style="border-top: none; border-left: none;">89%</TD><TD class="xl74" style="border-top: none;">Decreasing</TD><TD align="right" class="xl76" style="border-top: none; border-left: none;">-0.0089</TD></TR></TBODY></TABLE><P></P><P>=IF(LINEST(B40:E40)&gt;0,"Increasing",IF(LINEST(B40:E40)&lt;0,"Decreasing","Stable"))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt; is used to calculate the Increase Decrease</P><P></P><P>= Avg(MeanTotal)&nbsp;&nbsp;&nbsp;&nbsp; =&gt; this is the percentage shown</P><P></P><P></P><P></P><P>how can i apply this in Qlikview ( as formula ) to get if it increase or decrease in each Quarter</P></BODY></HTML> Mon, 24 Feb 2014 16:38:25 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-Linest/m-p/624003#M1112705 2014-02-24T16:38:25Z Re: How to calculate the Linest https://community.qlik.com/t5/QlikView/How-to-calculate-the-Linest/m-p/624004#M1112706 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/96544">Gysbert Wassenaar</A> and <A href="https://community.qlik.com/qlik-users/120618">Manish Kachhia</A> can u please help in this. REALLY important for me and sure you can solve it <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 25 Feb 2014 07:14:29 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-Linest/m-p/624004#M1112706 2014-02-25T07:14:29Z