Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
anonymous1
Contributor III
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? 

Labels (3)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

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
Lisa_P
Employee
Employee

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