Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Partner
Partner

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
Highlighted
Sergey_Shuklin
Valued Contributor

Re: Dynamic Y axis with smaller scale

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

6 Replies
Sergey_Shuklin
Valued Contributor

Re: Dynamic Y axis with smaller scale

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.

Partner
Partner

Re: Dynamic Y axis with smaller scale

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

Partner
Partner

Re: Dynamic Y axis with smaller scale

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

Highlighted
Sergey_Shuklin
Valued Contributor

Re: Dynamic Y axis with smaller scale

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

Partner
Partner

Re: Dynamic Y axis with smaller scale

Thank you 

 Its working when I unchecked option 'Forced 0' ,

why I need to do split axis also?

Sergey_Shuklin
Valued Contributor

Re: Dynamic Y axis with smaller scale

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