topic Macro in QlikView https://community.qlik.com/t5/QlikView/Macro/m-p/351147#M702273 <HTML><HEAD></HEAD><BODY><P>Hi Guys </P><P></P><P>I am adding the expression dynamically usng macro in a bar chart now i want to set the property "valuesondatapoints"</P><P></P><P>can anyone please help me with this?????</P></BODY></HTML> Mon, 16 Jul 2012 03:13:32 GMT 2012-07-16T03:13:32Z Macro https://community.qlik.com/t5/QlikView/Macro/m-p/351147#M702273 <HTML><HEAD></HEAD><BODY><P>Hi Guys </P><P></P><P>I am adding the expression dynamically usng macro in a bar chart now i want to set the property "valuesondatapoints"</P><P></P><P>can anyone please help me with this?????</P></BODY></HTML> Mon, 16 Jul 2012 03:13:32 GMT https://community.qlik.com/t5/QlikView/Macro/m-p/351147#M702273 2012-07-16T03:13:32Z Re: Macro https://community.qlik.com/t5/QlikView/Macro/m-p/351148#M702274 <HTML><HEAD></HEAD><BODY><P>Use the below:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13424118413406119" jivemacro_uid="_13424118413406119"><P>Set chart = ActiveDocument.GetSheetObject("CH01")</P><P>Set p = chart.GetProperties</P><P>Set expr = p.Expressions.Item(0).Item(0).Data.ExpressionVisual</P><P>expr.ShowAsTextInChart = TRUE'FALSE to hide</P></PRE><P></P><P>Kiran Rokkam.</P></BODY></HTML> Mon, 16 Jul 2012 04:10:39 GMT https://community.qlik.com/t5/QlikView/Macro/m-p/351148#M702274 2012-07-16T04:10:39Z Re: Macro https://community.qlik.com/t5/QlikView/Macro/m-p/351149#M702275 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply but if&nbsp; i want it to do for 2 expressions</P></BODY></HTML> Mon, 16 Jul 2012 04:14:56 GMT https://community.qlik.com/t5/QlikView/Macro/m-p/351149#M702275 2012-07-16T04:14:56Z Re: Macro https://community.qlik.com/t5/QlikView/Macro/m-p/351150#M702277 <HTML><HEAD></HEAD><BODY><P><CODE class="jive-code jive-sql">Item(0) indicates the first expression. Use line 3 twice, once for each expression.<BR /></CODE></P><P></P><P>Kiran Rokkam.</P></BODY></HTML> Mon, 16 Jul 2012 04:17:41 GMT https://community.qlik.com/t5/QlikView/Macro/m-p/351150#M702277 2012-07-16T04:17:41Z