topic Re: Dynamic Y axis with smaller scale in QlikView

Dynamic Y axis with smaller scale

vsharma1 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Dynamic Y axis with smaller scale

Sergey_Shuklin — Mon, 10 Jun 2019 05:00:56 GMT

Hello!

You can scale values with QV tooltips:

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

Re: Dynamic Y axis with smaller scale

vsharma1 — Tue, 11 Jun 2019 00:27:26 GMT

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' .

Re: Dynamic Y axis with smaller scale

vsharma1 — Tue, 11 Jun 2019 02:10:51 GMT

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

Re: Dynamic Y axis with smaller scale

Sergey_Shuklin — Tue, 11 Jun 2019 04:55:32 GMT

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.

Re: Dynamic Y axis with smaller scale

vsharma1 — Tue, 11 Jun 2019 15:17:19 GMT

Thank you

Its working when I unchecked option 'Forced 0' ,

why I need to do split axis also?

Re: Dynamic Y axis with smaller scale

Sergey_Shuklin — Thu, 13 Jun 2019 05:32:32 GMT

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

Re: Dynamic Y axis with smaller scale

hectorgarcia — Mon, 27 Apr 2020 20:11:16 GMT

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

Re: Dynamic Y axis with smaller scale

Sergey_Shuklin — Tue, 28 Apr 2020 04:59:55 GMT

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?