topic Expression count in macro in QlikView https://community.qlik.com/t5/QlikView/Expression-count-in-macro/m-p/1203950#M879759 <HTML><HEAD></HEAD><BODY><P>I'm writing a macro to toggle showing or hiding values on data points. It works for a chart with a single expression using</P><P></P><P>Expressions.Item(0), but I'd like to use it for charts with multiple expressions. In my macro, how can I get a count of how many expressions are in my chart so I can cycle through them with a FOR clause?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Expression count in macro https://community.qlik.com/t5/QlikView/Expression-count-in-macro/m-p/1203950#M879759 <HTML><HEAD></HEAD><BODY><P>I'm writing a macro to toggle showing or hiding values on data points. It works for a chart with a single expression using</P><P></P><P>Expressions.Item(0), but I'd like to use it for charts with multiple expressions. In my macro, how can I get a count of how many expressions are in my chart so I can cycle through them with a FOR clause?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-count-in-macro/m-p/1203950#M879759 2020-11-25T16:16:04Z Re: Expression count in macro https://community.qlik.com/t5/QlikView/Expression-count-in-macro/m-p/1203951#M879760 <HTML><HEAD></HEAD><BODY><P>Hello Len,</P><P></P><P></P><P>set chart = ActiveDocument.GetSheetObject("CH21")<BR /> set cp = chart.GetProperties<BR /> n = cp.Expressions.Count</P></BODY></HTML> Thu, 06 Oct 2016 05:25:31 GMT https://community.qlik.com/t5/QlikView/Expression-count-in-macro/m-p/1203951#M879760 zhadrakas 2016-10-06T05:25:31Z Re: Expression count in macro https://community.qlik.com/t5/QlikView/Expression-count-in-macro/m-p/1203952#M879761 <HTML><HEAD></HEAD><BODY><P><STRONG>Macros Are not Good Tim. </STRONG></P><P></P><P>Len, Yes we can show. Please find attachment for Ref. Hope this helps</P></BODY></HTML> Thu, 06 Oct 2016 05:39:58 GMT https://community.qlik.com/t5/QlikView/Expression-count-in-macro/m-p/1203952#M879761 Anil_Babu_Samineni 2016-10-06T05:39:58Z Re: Expression count in macro https://community.qlik.com/t5/QlikView/Expression-count-in-macro/m-p/1203953#M879762 <HTML><HEAD></HEAD><BODY><P>Thanks, that worked. The Expressions.count was what I needed.</P></BODY></HTML> Thu, 06 Oct 2016 17:22:14 GMT https://community.qlik.com/t5/QlikView/Expression-count-in-macro/m-p/1203953#M879762 2016-10-06T17:22:14Z Re: Expression count in macro https://community.qlik.com/t5/QlikView/Expression-count-in-macro/m-p/1203954#M879763 <HTML><HEAD></HEAD><BODY><P>good to know. please dont Forget to mark this as answered.</P></BODY></HTML> Fri, 07 Oct 2016 04:44:37 GMT https://community.qlik.com/t5/QlikView/Expression-count-in-macro/m-p/1203954#M879763 zhadrakas 2016-10-07T04:44:37Z