topic Re: Too many values on Chart Axis in QlikView

Too many values on Chart Axis

Thu, 11 Jul 2013 20:25:18 GMT

Hi,

I have a couple of bubble charts that have ~200-300 values for the x-axis. Qlikview shows all the numbers on the axis, using up half of the chart space just for labeling the axis.

Is there a way to reduce the number of values shown on the axis without reducing the granularity in the chart? I know I could reduce the number by using a dimension expression like round(x/10)*10 but this also reduces the detail in the graph. I want to show only every 10th number on the axis, for instance, but have all x values in the chart.

Thank You!

Marco

Re: Too many values on Chart Axis

Thu, 11 Jul 2013 22:07:43 GMT

In another post I found a reference to Chart Properties > Presentation > Dimension Limitations but I do not see this section in the preferneces for my chart, only some of these settings such as "Show x-axis Scrollbar". (I did set up advanced editing in the user preferences)

My best guess would be to use the axis scale settings und Chart Properties > Axes, this is how I do something like this in Excel, but in QlikView these settings are greyed out and can't be selected. 😞

I can imagine that these setting were disabled because bubble charts are mostly used with categorical variables but why limit to that? I have a lot of uses where I want to use these charts with interval data.

Message was edited by: marcokiesewetter

Re: Too many values on Chart Axis

paulyeo11 — Thu, 11 Jul 2013 23:31:16 GMT

me too like to know where to set , as it happen to my chart once .

Re: Too many values on Chart Axis

Anonymous — Mon, 30 Sep 2013 09:08:44 GMT

Hi,
have you eventually found a solution? I'm having the exact same problem...
Thank you
Andrea

Re: Too many values on Chart Axis

Mon, 27 Jan 2014 21:01:17 GMT

Axis -> dimension axis -> uncheck "stagger labels"

it worked for me!

Re: Too many values on Chart Axis

Mon, 17 Feb 2014 15:24:46 GMT

Hi,

try to use the class() function as a calculated dimension!

=class([field],50,'field')

Replace field with your field name.

This will give you ranges of 50 (e.g.) 1-50, 50-100, 100-150, etc. Changing the 50 will change this range!

Greetings,

Lucas