topic Hiding the Y axis using macro in QlikView

Hiding the Y axis using macro

brian_booden — Tue, 14 Aug 2012 12:11:12 GMT

I have written a small macro to hide the X-axis on a (bar) chart when a button is pushed, as per below:

sub HideXAxis

set chart = ActiveDocument.GetSheetObject("CH111")

set p = chart.GetProperties

p.ChartProperties.XAxis.Show = false

chart.SetProperties p

end sub

I also want to be able to hide the Y-Axis at the same time, but cannot find the syntax to do it. Is this possible, and if so, how?

Regards,

Brian

Re: Hiding the Y axis using macro

brian_booden — Wed, 12 Sep 2012 08:49:20 GMT

Can anyone make any suggestions on this? I have had another good sift through the API Guide and cannot find equivalent Y-Axis properties.

I have a manual workaround currently where i can set the the font colour of the Y-Axis to the colour of the background, effectively hiding it, using a variable as a toggle. But i am not keen on embedding expressions into every font colour of Y-Axis objects through my application. I would rather trigger the properties through a macro, similar to my previous post.

Any suggestions would be really appreciated.

Regards,

Brian

Re: Hiding the Y axis using macro

Wed, 12 Sep 2012 14:17:03 GMT

He Brian,

Why don't you make two different graphs. One graph with an y-axis and one graph without an y-axis.

Then show the graphs conditionally, dependent of the value of a variable.

You can create a button to change the value of the variable.

For eg:

Make a button wich sets the variable vShow to 0. And one button to set the variable vShow to 1.

If vShow=0 you show the graph with the y-axis. If vShow=1 you show the graph without the y-axis.

This way you don't need a macro and you can use a trigger which will still work with ajax client.

Hope that helps.

gr.

Frank

Re: Hiding the Y axis using macro

rustyfishbones — Wed, 15 Oct 2014 15:47:26 GMT

Hi Brian,

Did you ever figure this out?

Regards

Alan