topic Re: Aligning grid lines for two y axes in QlikView

Aligning grid lines for two y axes

Mon, 12 Jan 2015 10:32:08 GMT

Hello,

I have a chart with two y axes. I would like to show grid lines for both, though these are not exactly aligned. Is there a way to force this alignment?

Chart with one set of grid lines (not ideal):

Chart with both grid lines, not aligned:

Thank you,

Re: Aligning grid lines for two y axes

Gysbert_Wassenaar — Mon, 12 Jan 2015 11:29:26 GMT

Yes, it's possible. You need to set the minimum, maximum and step values for the axes. See attached example.

Re: Aligning grid lines for two y axes

Tue, 13 Jan 2015 15:26:46 GMT

Hi Gysbert,

Thanks very much for this - this is certainly true. Do you know if this is possible to do if you didn't want static axes?

Thanks

Re: Aligning grid lines for two y axes

Gysbert_Wassenaar — Wed, 14 Jan 2015 08:28:01 GMT

Using these settings don't necessarily mean static axes. You can use expressions to calculate the values for these settings. But afaik know it is impossible to allign the grids without making sure they both get the same number of intervals of the same size using the minimum, maximum and step settings.