topic How can I make this selection using macro? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-make-this-selection-using-macro/m-p/355528#M131975 <HTML><HEAD></HEAD><BODY><P>I´m using Macro cause I wanna an initial selection automatically</P></BODY></HTML> Wed, 18 Apr 2012 12:06:04 GMT rcandeo 2012-04-18T12:06:04Z How can I make this selection using macro? https://community.qlik.com/t5/QlikView/How-can-I-make-this-selection-using-macro/m-p/355524#M131971 <HTML><HEAD></HEAD><BODY><P>I have this expression in a macro:</P><P></P><P>ActiveDocument.GetField("Customer").Select. "29957"</P><P></P><P>But I wanna select the Customer excluded in real. </P><P>I wanna all the customers, except 29957.</P><P></P><P>Wich is the command in VBScript please?</P></BODY></HTML> Tue, 17 Apr 2012 14:36:37 GMT https://community.qlik.com/t5/QlikView/How-can-I-make-this-selection-using-macro/m-p/355524#M131971 rcandeo 2012-04-17T14:36:37Z Re: How can I make this selection using macro? https://community.qlik.com/t5/QlikView/How-can-I-make-this-selection-using-macro/m-p/355525#M131972 <HTML><HEAD></HEAD><BODY><P>After select, use .SelectExcluded</P></BODY></HTML> Tue, 17 Apr 2012 14:45:19 GMT https://community.qlik.com/t5/QlikView/How-can-I-make-this-selection-using-macro/m-p/355525#M131972 2012-04-17T14:45:19Z How can I make this selection using macro? https://community.qlik.com/t5/QlikView/How-can-I-make-this-selection-using-macro/m-p/355526#M131973 <HTML><HEAD></HEAD><BODY><P>not worked as it should. The result was different than select the customer and check select excluded in application.</P><P>Thanks</P></BODY></HTML> Tue, 17 Apr 2012 18:49:35 GMT https://community.qlik.com/t5/QlikView/How-can-I-make-this-selection-using-macro/m-p/355526#M131973 rcandeo 2012-04-17T18:49:35Z How can I make this selection using macro? https://community.qlik.com/t5/QlikView/How-can-I-make-this-selection-using-macro/m-p/355527#M131974 <HTML><HEAD></HEAD><BODY><P>why even use macro? There is an action for Select in Field and then select excluded</P></BODY></HTML> Tue, 17 Apr 2012 19:00:33 GMT https://community.qlik.com/t5/QlikView/How-can-I-make-this-selection-using-macro/m-p/355527#M131974 2012-04-17T19:00:33Z How can I make this selection using macro? https://community.qlik.com/t5/QlikView/How-can-I-make-this-selection-using-macro/m-p/355528#M131975 <HTML><HEAD></HEAD><BODY><P>I´m using Macro cause I wanna an initial selection automatically</P></BODY></HTML> Wed, 18 Apr 2012 12:06:04 GMT https://community.qlik.com/t5/QlikView/How-can-I-make-this-selection-using-macro/m-p/355528#M131975 rcandeo 2012-04-18T12:06:04Z How can I make this selection using macro? https://community.qlik.com/t5/QlikView/How-can-I-make-this-selection-using-macro/m-p/355529#M131976 <HTML><HEAD></HEAD><BODY><P>There are triggers for on open that you can attach a select from field. I currently use one so when the document is opened it selects the most recent date. In another I have it set to select a regional sales manager based on the current user then locks the field.</P></BODY></HTML> Wed, 18 Apr 2012 12:15:48 GMT https://community.qlik.com/t5/QlikView/How-can-I-make-this-selection-using-macro/m-p/355529#M131976 2012-04-18T12:15:48Z