Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

anonymous1
New Contributor III

trendlines and dimensions

hi guys, 

i have a question regarding a forecasting chart.  I have a line chart that is forecasting future shipments, however i was wondering if there is some sort of method/expression that i could use to dynamically extend the y-axis dimension?

so the data i have imported only goes as far as august2019, however, when the trendline has been applied it extends off the chart with no y-axis applied to it. 

x-axis is sum(shipments), y-axis is master calendar showing monthyear.

any ideas on how to amend the dimension this from happening? 

1 Solution

Accepted Solutions
Employee
Employee

Re: trendlines and dimensions

On the Axes tab in the properties for the Dimension Axis Select the Forecast and in the expression box add either an expression or a fixed number to extend the axis by

View solution in original post

1 Reply
Employee
Employee

Re: trendlines and dimensions

On the Axes tab in the properties for the Dimension Axis Select the Forecast and in the expression box add either an expression or a fixed number to extend the axis by

View solution in original post