Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
nickedw0
Creator
Creator

Chart Properties Names

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

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

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

View solution in original post

5 Replies
tamilarasu
Champion
Champion

Hi Hanief,

set chart = ActiveDocument.GetSheetobject("CH01")

set p = chart.GetProperties

p.ChartProperties.Horizontal = true

chart.SetProperties p

nickedw0
Creator
Creator
Author

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.

tamilarasu
Champion
Champion

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

nickedw0
Creator
Creator
Author

Thank you! The change from ChartProperties to TableProperties  works.

tamilarasu
Champion
Champion

Great. Have a super day!