0 Replies Latest reply: Jul 8, 2016 2:55 PM by Jordan Riggs RSS

    Inverse Exponential lines for a forecast are not mirrored

    Jordan Riggs

      Hello!

       

      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.

       

      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.

       

      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.

       

      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?

       

      Please note I have advanced Excel skills but am very new to Qlikview. Thank you for the help in advance.