topic Inverse Exponential lines for a forecast are not mirrored in QlikView https://community.qlik.com/t5/QlikView/Inverse-Exponential-lines-for-a-forecast-are-not-mirrored/m-p/1121097#M463405 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>I am making 2 line chart objects that are inverses on one another. One is usage type A, % of total usage. The other is usage type B, % of total usage. Usage A + B = Total Usage. One is going up as the other goes down.</P><P></P><P>Within the Expressions tab, I have trendline 'Exponential' selected. Within the Axes tab, I have Forecast checked with the value of 36 entered (months). My X-Axis is year-months.</P><P></P><P>My question is, why are the exponential trend lines in the forecast area of the charts not mirror images? The increasing trend line looks like a normal trend line but the decreasing trend line looks like a straight linear trend line and is not nearly as pronounced.</P><P></P><P>My Actual value lines are mirror images and I checked that the data and my formulas are correct. Is this something to do with the Trendline formula going down?</P><P></P><P>Please note I have advanced Excel skills but am very new to Qlikview. Thank you for the help in advance.</P></BODY></HTML> Fri, 08 Jul 2016 18:55:23 GMT 2016-07-08T18:55:23Z Inverse Exponential lines for a forecast are not mirrored https://community.qlik.com/t5/QlikView/Inverse-Exponential-lines-for-a-forecast-are-not-mirrored/m-p/1121097#M463405 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>I am making 2 line chart objects that are inverses on one another. One is usage type A, % of total usage. The other is usage type B, % of total usage. Usage A + B = Total Usage. One is going up as the other goes down.</P><P></P><P>Within the Expressions tab, I have trendline 'Exponential' selected. Within the Axes tab, I have Forecast checked with the value of 36 entered (months). My X-Axis is year-months.</P><P></P><P>My question is, why are the exponential trend lines in the forecast area of the charts not mirror images? The increasing trend line looks like a normal trend line but the decreasing trend line looks like a straight linear trend line and is not nearly as pronounced.</P><P></P><P>My Actual value lines are mirror images and I checked that the data and my formulas are correct. Is this something to do with the Trendline formula going down?</P><P></P><P>Please note I have advanced Excel skills but am very new to Qlikview. Thank you for the help in advance.</P></BODY></HTML> Fri, 08 Jul 2016 18:55:23 GMT https://community.qlik.com/t5/QlikView/Inverse-Exponential-lines-for-a-forecast-are-not-mirrored/m-p/1121097#M463405 2016-07-08T18:55:23Z