Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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?