topic Re: Macro to Hide/Show chart object in QlikView

Macro to Hide/Show chart object

Kunkulis — Sat, 16 Nov 2024 03:38:29 GMT

Hi,

I am trying to get a macro that will adjust the Chart Properties -> Layouy -> Show Conditional to be 1=0 or a variable

This is the code I found, but it keeps failing at cp.Layout.Frame.Show.Always=false
If i comment it out it will fail at Expression.v

Sub HideIt Set Obj=ActiveDocument.GetSheetObject("CH421") Set cp=Obj.GetProperties cp.Layout.Frame.Show.Always = false cp.Layout.Frame.Show.Expression.v = "1=0" Obj.SetProperties cp End sub

Any idea how to solve this?

Re: Macro to Hide/Show chart object

marcus_sommer — Wed, 08 May 2019 13:34:26 GMT

I think there are better way to show/hide objects respectively parts of it than using macros. For example you could use a selection - from an extra field - or a variable which is controlled per inputbox or an action - directly included within the UI properties.

- Marcus

Re: Macro to Hide/Show chart object

Kunkulis — Wed, 08 May 2019 13:38:58 GMT

Hi,

Thank you for the response. I excluded some information, sorry.

I need the graph to be un-hidden for a macro that copies a number of charts to a PPT.
For the PPT I use the CH421, but for the people to view it before copying I have the same chart, but with legend, different size, etc.

The macro that does all the copy work, doesn't copy CH421 if it is hidden with expression 1=0, once it is unhidden, it works.

So the idea is to Unhide the CH421 as the macro starts and hide it as it finishes.

Re: Macro to Hide/Show chart object

marcus_sommer — Wed, 08 May 2019 13:47:42 GMT

Ok. In this case I would change the variable-value with the macro and not adjusting the chart-properties like:

ActiveDocument.Variables("varShowHide").SetContent 0, true

respectively

ActiveDocument.Variables("varShowHide").SetContent 1, true

- Marcus

Re: Macro to Hide/Show chart object

Kunkulis — Wed, 08 May 2019 14:07:27 GMT

You mean as the button is clicked it runs the macro and sets variable?

Or the ActiveDocument.Variables("varShowHide").SetContent 0, true is somehow implemented in the macro?

Sorry, I am fairy new in the QlikView. So If you could, please, explain as simply as possible.

Thank you in advance.

-Kunkulis

Re: Macro to Hide/Show chart object

marcus_sommer — Thu, 09 May 2019 06:54:38 GMT

I think using a second action/button has no benefit and therefore I would integrate it into the export-routine. Quite useful is also often to add a wait- an/or a sleep-statement between the various actions (show/hide, various selections, copy & paste per clipboard, opening/saving files and so on) to ensure that the objects are calculated/rendered respectively that the OS has enough time to perform these actions.

ActiveDocument.GetApplication.WaitForIdle

rem ** let QV sleep for 10 seconds **
ActiveDocument.GetApplication.Sleep 10000

Quite useful for all the macro-stuff is the APIGuide.qvw within your installation-folders (somewhere by automation) which provides a lot of backgrounds and examples.

- Marcus

Re: Macro to Hide/Show chart object

Kunkulis — Thu, 09 May 2019 10:34:39 GMT

I added the sleep in the initial macro, but it still failed.

None the less, I found the API Guide, which seems to be very promising, thank you for that, didn't know something like this exists.

Re: Macro to Hide/Show chart object

marcus_sommer — Thu, 09 May 2019 12:16:27 GMT

Maybe it wasn't clear enough. The variable "varShowHide" needs to be created and set within the visibility-properties before executing the macro.

The sleep-statement is for inter-acting with the OS and the wait-statement for the calculations in QV.

- Marcus