topic Re: dynamic scale in QlikView

dynamic scale

Tue, 22 Apr 2014 09:00:29 GMT

It doesn't work the automatic scale. The lines go out of the chart. Can anyone help me? Thank you!

Re: dynamic scale

Gysbert_Wassenaar — Tue, 22 Apr 2014 09:56:24 GMT

Make sure there is no value set for the Static Max setting on the Axes tab for the expression axis.

Re: dynamic scale

Roop — Tue, 22 Apr 2014 10:07:30 GMT

Remove Static Min, Static Max and Static Step from the chart under the Axes tab. This should work.

If that doesn't work you can change the Static Max to be the largest value of your data set by using MAX() function and the Static Min by using the MIN() function.

Re: dynamic scale

Tue, 22 Apr 2014 10:23:40 GMT

The problem is that the automatic scale of some expression work well but in other not and I cant find the problem.

Re: dynamic scale

Tue, 22 Apr 2014 10:24:18 GMT

The Static Min, Static Max and Static Step from the chart under the Axes tab are removed

Re: dynamic scale

Roop — Tue, 22 Apr 2014 10:33:23 GMT

Try and create a MIN and MAX yourself by using MIN() and MAX() around your expressions, so if you have SUM(Sales), use MIN a MIN(Sales) and MAX as MAX(Sales).

Hope this helps

Re: dynamic scale

senpradip007 — Tue, 22 Apr 2014 10:35:30 GMT

You can use RangeMin() and RangeMax() for Static Min and Static Max scale respectively.

Re: dynamic scale

Tue, 22 Apr 2014 14:23:35 GMT

this is my problem. It works when I inhabilitate the year 2013 but when the three years are together the chart doesn´t work automatically. In the opction axis in the chart all the option are the same for the three years. So I can´t guess the problem. Thank you again

Re: dynamic scale

Roop — Tue, 22 Apr 2014 14:51:22 GMT

What happens if you remove a different year?

Are the year lines defined individually as calculated expressions? or are they just defined as a year field?

For this I think that you will definitely need a MIN value for the minimum axis .....