topic Cluttered Y-Axis in QlikView

Cluttered Y-Axis

Wed, 19 May 2010 17:41:38 GMT

Here is my problem:

I need to have a static step of 1 in order to prevent decimals from being shown on my axis, for my particular data set decimals don't make sense.

Thus, I have the static step box checked and set to one.

When I view the graph initially it has a step size of 5,000 ranging from 0 to 25,000. This all fits very well and the y-axis is uncluttered.

When I drill in, it becomes a step size of 1000 ranging from 0-17,000 due to the size of the graph, this makes the Y-axis cluttered and the numbers almost overlap.

Is there a way to remove the clutter when I drill in?

I have tried adding

Min ( Aggr ( Sum ( valuefield ) ))

Max ( Aggr ( Sum ( valuefield ) ))

To the static min and max fields, and this gives me the reverse problem. Now, my normal view is cluttered while the zoomed in view is uncluttered.

Any help you have on the subject is greatly appreciated.

Cluttered Y-Axis

Wed, 19 May 2010 18:26:02 GMT

a bit hard to follow your explanations, can you make the value an integer using floor, ceil or round?

Juerg

Cluttered Y-Axis

Wed, 19 May 2010 19:25:19 GMT

Hey,

If you are a little bit more specific about what is confusing I can try to explain it better.

As far as flooring it goes, are you talking about somehow flooring my static step?

Thank you!

Cluttered Y-Axis

Thu, 20 May 2010 08:30:16 GMT

Hi Hannah

I might have read your question wrong.

Is it correct that you get too many labels on the Y-axis in one or the other drill level?

You could probably call a macro on change of selection that will set a resonable static step for the new data range?

Regards

Juerg

Cluttered Y-Axis

Thu, 20 May 2010 16:02:07 GMT

Yes, that is correct.

I've only been using Qlikview for a few days. Would it be possible for you to describe how to call the macro a little bit more?

Thank you.

Cluttered Y-Axis

jedgson — Thu, 20 May 2010 17:06:59 GMT

Hannah,

I have not tested this but you could try the following.

Create a variable with the following

Max ( Aggr ( Sum ( valuefield ), [X Axis Field Name] ))

Then in the static step use this

If( $(Variable) <= 10, 1, If( $(Variable) <=100, 10, if( $(Variable) <= 1000, 100, etc...)))

Its not 100% flexible but should do the trick

Cluttered Y-Axis

Thu, 20 May 2010 20:26:21 GMT

I'll give that a try thanks.