Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Macro

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

Re: Macro

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

Not applicable

Re: Macro

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

Kiran Rokkam.