topic Add minichart column via VB macros in QlikView https://community.qlik.com/t5/QlikView/Add-minichart-column-via-VB-macros/m-p/468084#M699412 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Could you please help me with setting up a minichart column via VB Macros? </P><P></P><P>Here is a code I'm trying to use:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13566185215489451" jivemacro_uid="_13566185215489451"><P>set chart = ActiveDocument.GetSheetObject("CH55")</P><P>set p = chart.GetProperties</P><P>set exps = p.Expressions</P><P>set expItem = exps.Item(0).Item(0).Data.ExpressionVisual</P><P>expItem.Label.v = "Trend line"</P><P>exps.Item(0).Item(0).Data.ExpressionData.UsePartialSum = false ' no totals</P><P>expItem.MiniChartCellSettings.Dimension(0).Name="time_id"</P><P>expItem.MiniChartCellSettings.Dimension(0).Type=1 </P><P>chart.SetProperties p</P></PRE><P></P><P>expItem.MiniChartCellSettings.Dimension(0).Name="time_id" produces an error "Invalid procedure call or argument".</P><P></P><P>In fact, I can refer to expItem.MiniChartCellSettings.Dimension(0).Name if I already set up minichart manually via GUI but that is not the case I need. </P><P></P><P>Any references and examples are greatly appreciated.</P><P>Thanks in advance</P></BODY></HTML> Thu, 27 Dec 2012 14:35:19 GMT 2012-12-27T14:35:19Z Add minichart column via VB macros https://community.qlik.com/t5/QlikView/Add-minichart-column-via-VB-macros/m-p/468084#M699412 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Could you please help me with setting up a minichart column via VB Macros? </P><P></P><P>Here is a code I'm trying to use:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13566185215489451" jivemacro_uid="_13566185215489451"><P>set chart = ActiveDocument.GetSheetObject("CH55")</P><P>set p = chart.GetProperties</P><P>set exps = p.Expressions</P><P>set expItem = exps.Item(0).Item(0).Data.ExpressionVisual</P><P>expItem.Label.v = "Trend line"</P><P>exps.Item(0).Item(0).Data.ExpressionData.UsePartialSum = false ' no totals</P><P>expItem.MiniChartCellSettings.Dimension(0).Name="time_id"</P><P>expItem.MiniChartCellSettings.Dimension(0).Type=1 </P><P>chart.SetProperties p</P></PRE><P></P><P>expItem.MiniChartCellSettings.Dimension(0).Name="time_id" produces an error "Invalid procedure call or argument".</P><P></P><P>In fact, I can refer to expItem.MiniChartCellSettings.Dimension(0).Name if I already set up minichart manually via GUI but that is not the case I need. </P><P></P><P>Any references and examples are greatly appreciated.</P><P>Thanks in advance</P></BODY></HTML> Thu, 27 Dec 2012 14:35:19 GMT https://community.qlik.com/t5/QlikView/Add-minichart-column-via-VB-macros/m-p/468084#M699412 2012-12-27T14:35:19Z