topic Zero line on a chart in QlikView

Zero line on a chart

Fri, 23 Apr 2010 09:33:41 GMT

Morning All,

I have a combo chart, bars and lines, with positive and negative values. I'd like to get a solid line across the chart at y=0. I don't really want the grid, with lines every 100 points or whatever. And I don't want to set the x axis at y=0 as my labels (dates) would just clutter up the chart.

Is this possible? Or is there a way to set the spacings on the grid so I get a line every 1000000000 points?

Many thanks,

Tony

Zero line on a chart

Fri, 23 Apr 2010 09:39:44 GMT

Tony

Go to the presentation tab, you will see Reference lines at bottom right side, go in there and just add one in with an expression value of zero.

Simples.....

Zero line on a chart

Fri, 23 Apr 2010 09:44:17 GMT

Nice one! Thanks Nigel.

Tony

Zero line on a chart

Fri, 23 Apr 2010 09:44:37 GMT

Hi,

If you want to add a line in Y axis (primary or secondary). I suggest you to use the reference lines (Graph / properties / Presentation / Reference line. Click an Add then in Expression, put =0 (if you want a line at 0 value).

If you want to space the grid every 100 points : open the Graph properties / axes tab. Check the 'static Step' and write 100 in it.

Hope it helps

Regards

Zero line on a chart

Fri, 23 Apr 2010 11:15:31 GMT

Got it. Thanks Bertrand.

Zero line on a chart

kji — Fri, 23 Apr 2010 11:22:25 GMT

The "more correct" way of doing it would be to go to the axis tab of chart properties and set the width of the expression axis to a value of 1 (it defaults to 0 for a cleaner look).

Zero line on a chart

Fri, 23 Apr 2010 11:56:19 GMT

That's the one, thanks Johan. I had actually done this with the Dimension axis but thinking about it I guess it does make more sense for the zero line to be related to the Expression axis.

cheers,

Tony