topic hiding chart title by VB macro in QlikView

hiding chart title by VB macro

fineasfalco — Fri, 19 Oct 2018 09:59:28 GMT

Hi,

I have the need to hide the chart title by a macro.

The layout of the chart title is controlled by check box "Show Caption".

Can I uncheck this control by VB Macro?

I have added a button to run a macro

i.e

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

set Prop = chart.GetProperties
??? Prop.????=false
chart.SetProperties Prop

end sub

Is there a way for achieving this?

Re: hiding chart title by VB macro

m_woolf — Fri, 19 Oct 2018 19:04:24 GMT

This is from the API Guide:

set myobj = ActiveDocument.GetSheetObject("CO01")

prop = myobj.GetProperties

prop.Layout.Frame.ShowCaption = true

myobj.SetProperties prop

Re: hiding chart title by VB macro

m_woolf — Fri, 19 Oct 2018 19:49:43 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.