Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

add dimension on macro at 9.0

Does not work chart.AddDimension script on updated 9.0 from 8.5. It was OK if described AddExpression followed by AddDimension on 8.5. But niether order expression and dimension does not work on 9.0. Is there any new API example to solve this chart property setting?

Tags (2)
3 Replies
Not applicable

add dimension on macro at 9.0

in 9.0, it's not possible to access/modify a sheet object which doesn't belong to the active sheet, nor a minimized one

also, some methods do not fail when trying to do that, but return wrong values (for example GetRowCount, GetTableAsText behave this way)

Not applicable

add dimension on macro at 9.0

Thank you for your advice.

still works on adding expressions for expample

set chart2 = ActiveDocument.ActiveSheet.CreateStraightTable
chart2.AddExpression "SUPPLIERNAME"

You mean no more support on CreativeStraigntTable ?

Not applicable

add dimension on macro at 9.0

You should be able to add a dimension to your straight table box if it is in the currently active sheet

adding expression is possible even if the sheet isn't the active one