topic Re: Chart Properties Names in QlikView

Chart Properties Names

nickedw0 — Thu, 15 Mar 2018 15:55:28 GMT

I am trying to set the Presentation to Horizontal in a macro. Is there a published list of property references? After I use the GetProperties statement I do't know how to reference the Presentation > Horizontal property

Re: Chart Properties Names

tamilarasu — Thu, 15 Mar 2018 16:12:47 GMT

Hi Hanief,

set chart = ActiveDocument.GetSheetobject("CH01")

set p = chart.GetProperties

p.ChartProperties.Horizontal = true

chart.SetProperties p

Re: Chart Properties Names

nickedw0 — Thu, 15 Mar 2018 16:26:25 GMT

Thanks Tamil. That's seems to be correct. I am not getting any errors, but the straight table is not flipping when I run this.

Re: Chart Properties Names

tamilarasu — Thu, 15 Mar 2018 16:33:05 GMT

Ah got it.

set chart = ActiveDocument.GetSheetobject("CH01")

set cp = chart.GetProperties

cp.TableProperties.Horizontal = true

chart.SetProperties cp

'chart.SetPixWidths_Horizontal true,200

'chart.SetPixWidths_Horizontal false,150

Re: Chart Properties Names

nickedw0 — Thu, 15 Mar 2018 16:41:10 GMT

Thank you! The change from ChartProperties to TableProperties works.

Re: Chart Properties Names

tamilarasu — Thu, 15 Mar 2018 16:42:47 GMT

Great. Have a super day!