Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to calculate the Linest

I have the following Excel sheet:

FacilityQ1Q2Q3Q42013 AverageTargetTrend
Bateen92%93%90%89%91%89%Decreasing-0.0099
Khaleej92%93%93%94%93%89%Increasing0.00766
Etihad--98%94%96%89%Decreasing
Rawda92%92%95%92%92%89%Increasing0.00362
Zafarana86%88%85%84%86%89%Decreasing-0.0089

=IF(LINEST(B40:E40)>0,"Increasing",IF(LINEST(B40:E40)<0,"Decreasing","Stable"))      => is used to calculate the Increase Decrease

= Avg(MeanTotal)     => this is the percentage shown

how can i apply this in Qlikview ( as formula ) to get if it increase or decrease in each Quarter

1 Reply
Not applicable
Author

Gysbert Wassenaar and Manish Kachhia can u please help in this. REALLY important for me and sure you can solve it