Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro

Hi Guys

I am adding the expression dynamically usng macro in a bar chart now i want to set the property "valuesondatapoints"

can anyone please help me with this?????

3 Replies
Not applicable
Author

Use the below:

Set chart = ActiveDocument.GetSheetObject("CH01")

Set p = chart.GetProperties

Set expr = p.Expressions.Item(0).Item(0).Data.ExpressionVisual

expr.ShowAsTextInChart = TRUE'FALSE to hide

Kiran Rokkam.

Not applicable
Author

Thanks for the reply but if  i want it to do for 2 expressions

Not applicable
Author

Item(0) indicates the first expression. Use line 3 twice, once for each expression.

Kiran Rokkam.