topic Re: How to add and remove expressions from line chart dynamically in QlikView https://community.qlik.com/t5/QlikView/How-to-add-and-remove-expressions-from-line-chart-dynamically/m-p/287077#M106802 <HTML><HEAD></HEAD><BODY><P>Trigger the below macros accordingly.</P><P></P><P>set chart = ActiveDocument.GetSheetObject("CH01")</P><P>chart.AddExpression "sum(sales)"</P><P></P><P>set chart = ActiveDocument.GetSheetObject("CH01")</P><P>chart.RemoveExpression "sum(sales)"</P><P></P><P>Regards,</P><P>Kiran.</P></BODY></HTML> Sat, 24 Sep 2011 04:05:16 GMT 2011-09-24T04:05:16Z How to add and remove expressions from line chart dynamically https://community.qlik.com/t5/QlikView/How-to-add-and-remove-expressions-from-line-chart-dynamically/m-p/287075#M106800 <HTML><HEAD></HEAD><BODY><P>How to add and remove expressions from line chart dynamically</P></BODY></HTML> Fri, 23 Sep 2011 20:03:05 GMT https://community.qlik.com/t5/QlikView/How-to-add-and-remove-expressions-from-line-chart-dynamically/m-p/287075#M106800 2011-09-23T20:03:05Z Re: How to add and remove expressions from line chart dynamically https://community.qlik.com/t5/QlikView/How-to-add-and-remove-expressions-from-line-chart-dynamically/m-p/287076#M106801 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>See the attached sample file how to use dynamic epression it will explain you.</P><P></P><P>Let me know about this </P><P></P><P></P><P>Rgds</P><P>Anand</P></BODY></HTML> Sat, 24 Sep 2011 03:35:26 GMT https://community.qlik.com/t5/QlikView/How-to-add-and-remove-expressions-from-line-chart-dynamically/m-p/287076#M106801 its_anandrjs 2011-09-24T03:35:26Z Re: How to add and remove expressions from line chart dynamically https://community.qlik.com/t5/QlikView/How-to-add-and-remove-expressions-from-line-chart-dynamically/m-p/287077#M106802 <HTML><HEAD></HEAD><BODY><P>Trigger the below macros accordingly.</P><P></P><P>set chart = ActiveDocument.GetSheetObject("CH01")</P><P>chart.AddExpression "sum(sales)"</P><P></P><P>set chart = ActiveDocument.GetSheetObject("CH01")</P><P>chart.RemoveExpression "sum(sales)"</P><P></P><P>Regards,</P><P>Kiran.</P></BODY></HTML> Sat, 24 Sep 2011 04:05:16 GMT https://community.qlik.com/t5/QlikView/How-to-add-and-remove-expressions-from-line-chart-dynamically/m-p/287077#M106802 2011-09-24T04:05:16Z