topic Re: Static Min/Max Axes on Scatter Chart - even with selection in QlikView

Static Min/Max Axes on Scatter Chart - even with selection

Wed, 12 Mar 2014 12:00:37 GMT

Hello,

I have created a scatter chart with each axis representing a score of 0-5. I would like these axes to remain static, even when a selection is made, as the background image is static.

I have two issues at the moment:

1. As shown in the below image, the x-axis goes through 6 and the y-axis does not display the 5. How can I adjust this? Altering static min/max seems to have no effect. I've also tried to enter =max([field]) and =min([field]) with no luck.

2. When I select a certain point on the graph, the axes change, as shown in the below. I would also like the axes to remain static 0-5 when a selection is made (for the sake of the background image).

Thank you very much in advance for your input.

Melissa

Re: Static Min/Max Axes on Scatter Chart - even with selection

MK_QSL — Wed, 12 Mar 2014 12:04:09 GMT

can you share your sample file?

You can use

Min({1}Field)

Max({1}Field)

Re: Static Min/Max Axes on Scatter Chart - even with selection

Wed, 12 Mar 2014 12:43:15 GMT

I'm afraid I have created the dashboard in Personal Edition so I'm not sure if it would be helpful to upload it...? Do let me know if I'm wrong on this.

I tried your suggestion and again, to no avail. It does make sense though!

Do you know if there may be a way to create a dynamic background image, or to set benchmark colours that move with the moving axes?

Thanks again for your help

Re: Static Min/Max Axes on Scatter Chart - even with selection

MK_QSL — Wed, 12 Mar 2014 12:59:04 GMT

we have developers licence, so we can open your file.

We will reply back in writing...

Re: Static Min/Max Axes on Scatter Chart - even with selection

sunilkumarqv — Wed, 12 Mar 2014 13:32:57 GMT

1.For Remian static you can make go docment Properties -Alternate States Add A State then go to your chart

On genaral tab- see alternate state make it as A instead of inherited

one solution done

2.for other you probably supperss null value .

for more solution upload your sample file

Re: Static Min/Max Axes on Scatter Chart - even with selection

Thu, 13 Mar 2014 11:25:57 GMT

Thank you all for your advice.

In replicating the scatter chart in its own qvw file to post here, I realised the problem was my axes labels were too long - causing the x-axis to elongate and the y-axis to shorten.

A simple Static Min = 1 and Static Max = 5 with Forced 0 works like a charm.

It's nice when things are easier than you expected