Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
vsharma1
Partner - Creator
Partner - Creator

Dynamic Y axis with smaller scale

i want to display small numbers on Y axis by keeping number change dynamically if I select values in listbox

I have large numbers on Y axis , attached is the sample data 

 

Capture.JPG

1 Solution

Accepted Solutions
Sergey_Shuklin
Specialist
Specialist

Hello!

You can split axes on half to half and uncheck "Forced 0" to make your data more  various.

I also hid axes because values are shown on the data points.

y_axis_scale_pic2.png

View solution in original post

8 Replies
Sergey_Shuklin
Specialist
Specialist

Hello!

You can scale values with QV tooltips:

y_axis_scale_pic.png

If I missed a point - please give me a feedback with more details of the issue.

vsharma1
Partner - Creator
Partner - Creator
Author

Sorry I could not provide more details in my previous post . Please find attached sample data

I have prepared Combo chart using sample data and Listbox of State . If I click on any State value in List Box then Line in Combo chart should show Ups and Downs (variation). This is not happening if I click on California , Texas and Washington

below is the screenshot of state 'California' .  

Capture.JPG

vsharma1
Partner - Creator
Partner - Creator
Author

Line appeared to be almost straight line , I want to show variations

Sergey_Shuklin
Specialist
Specialist

Hello!

You can split axes on half to half and uncheck "Forced 0" to make your data more  various.

I also hid axes because values are shown on the data points.

y_axis_scale_pic2.png

vsharma1
Partner - Creator
Partner - Creator
Author

Thank you 

 Its working when I unchecked option 'Forced 0' ,

why I need to do split axis also?

Sergey_Shuklin
Specialist
Specialist

Hello!
Actually you don't have to. It's only helps to read a line more clear (without bars crossing).
hectorgarcia
Partner - Creator III
Partner - Creator III

Thanks for your contribution sergei very helpfull.

Quick question I see in you qvw that the labels are located one on the side of the other one , how did you do that?  I  cannot do this 

Sergey_Shuklin
Specialist
Specialist

Hello, Hector!

You meant labels on data points - how they on the one line for the curve points and bars?

If so, that's because they have the same dimension - Year. If no - please, provide more information about your case. 

Or this is a question about legend labels?