Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
JoshPark
Contributor III
Contributor III

Dynamic/Responsive Y-Axis of Line Chart

Hi Everyone, 

My Qlik Sense line chart composes of each customer's daily stock-on-hand.

It has much scattered value that the min and max values are far different from each other. So when I select a customer who has small value, the Y-axis is too high that I can barely see the line of that customer.

Is there anyway to make Y-axis responsive with the corresponding value?

 

Here are some screenshots:

All Customers:

JoshPark_0-1689127773628.png

Selected Customer with small value

JoshPark_1-1689127846794.png

 

Labels (2)
1 Solution

Accepted Solutions
JoshPark
Contributor III
Contributor III
Author

With the help of Qlik Support Agent (Vicky Z) to find others' similar problem, one solution is to set the expression for min and max value of the axis:

 

min(aggr(Sum(Sales),YearMonth))
max(aggr(Sum(Sales),YearMonth))

 

Source: https://community.qlik.com/t5/App-Development/Dynamic-axis-Min-Max-range-in-Qliksense-combo-chart/td...

Similar idea for who seek QV's solution: https://community.qlik.com/t5/QlikView-App-Dev/Scaling-dynamic-axes-on-a-chart/td-p/182780

Thank you @lironbaram ! 

View solution in original post

1 Reply
JoshPark
Contributor III
Contributor III
Author

With the help of Qlik Support Agent (Vicky Z) to find others' similar problem, one solution is to set the expression for min and max value of the axis:

 

min(aggr(Sum(Sales),YearMonth))
max(aggr(Sum(Sales),YearMonth))

 

Source: https://community.qlik.com/t5/App-Development/Dynamic-axis-Min-Max-range-in-Qliksense-combo-chart/td...

Similar idea for who seek QV's solution: https://community.qlik.com/t5/QlikView-App-Dev/Scaling-dynamic-axes-on-a-chart/td-p/182780

Thank you @lironbaram !