Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Selected Customer with small value
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))
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 !
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))
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 !