Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.


Hiding the Y axis using macro

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?



Tags (4)
3 Replies

Re: Hiding the Y axis using macro

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.



Not applicable

Re: Hiding the Y axis using macro

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.



Honored Contributor II

Re: Hiding the Y axis using macro

Hi Brian,

Did you ever figure this out?