topic Re: Show/Hide chart title via VB Macro in QlikView

Show/Hide chart title via VB Macro

fineasfalco — Fri, 19 Oct 2018 10:20:47 GMT

Hi,

I have the need to show/hide the chart caption via macro.

The layout of the chart title is controlled by a check box (Show Caption) in Caption tab .

I have added a button to run a macro to check/uncheck this control

A possible VB sub routine:

SUB ShowHide_TITLE
set chart = ActiveDocument.GetSheetObject("CH29")

set Prop = chart.GetProperties
' ????? Prop.???????=true
chart.SetProperties Prop

END SUB

is there a way for achieving this?

Re: Show/Hide chart title via VB Macro

m_woolf — Fri, 19 Oct 2018 19:03:18 GMT

This is from the API Guide:

set myobj = ActiveDocument.GetSheetObject("CO01")

prop = myobj.GetProperties

prop.Layout.Frame.ShowCaption = true

myobj.SetProperties prop

Re: Show/Hide chart title via VB Macro

m_woolf — Fri, 19 Oct 2018 19:50:22 GMT

Since Macros are Bad, I should suggest another method:

You could clone your chart and remove the caption on the close. Then you could use an action to show/hide the charts based on a variable or a field selection. No macros required.

Re: Show/Hide chart title via VB Macro

fineasfalco — Mon, 22 Oct 2018 10:02:00 GMT

Thank you very much for your support and prompt reply.

I'll use your suggestion.

I have another question, Where can I find the API Guide?

Re: Show/Hide chart title via VB Macro

m_woolf — Mon, 22 Oct 2018 11:53:08 GMT

If any of the replies solved your problem, please mark as Correct. If any were Helpful, please mark as Helpful.

Re: Show/Hide chart title via VB Macro

fineasfalco — Mon, 22 Oct 2018 16:21:32 GMT

Tks for the guide.

the solution to use a variable to show or not the cloned table can be the right idea.

In order to the macro, I have used your code but It's not run.

I'm using a pivot tables.

You say right about the macro (Macro are bad), but I have need to understand because the code is not right.

Your help is always precious.

Regards

Fineas

Re: Show/Hide chart title via VB Macro

m_woolf — Mon, 22 Oct 2018 16:44:29 GMT

This code should work for a pivottable:

set mybox = ActiveDocument.GetSheetObject("CH07")

set fr = mybox.GetFrameDef

fr.ShowCaption = true

mybox.SetFrameDef fr

Re: Show/Hide chart title via VB Macro

fineasfalco — Mon, 22 Oct 2018 17:02:27 GMT

Tkank you,

now the code is right.

Best Regards

Fineas