topic How to select a field with alternate state using a macro in QlikView https://community.qlik.com/t5/QlikView/How-to-select-a-field-with-alternate-state-using-a-macro/m-p/354272#M131490 <HTML><HEAD></HEAD><BODY><P>I want to select a field with alternate state using a macro.</P><P></P><P>The following statement works for the field with default state.</P><P></P><P style="padding-left: 30px;">ActiveDocument.Fields("Aisle").Select&nbsp; "Aisle1",true</P><P></P><P>I want to extend this to be used with an alternate state called "State1".</P><P></P><P>I tried the following but no luck so far;</P><P></P><P style="padding-left: 30px;">ActiveDocument.Fields("State1::Aisle").Select&nbsp; "Aisle1",true</P><P style="padding-left: 30px;">ActiveDocument.Fields("{State1}Aisle").Select&nbsp; "Aisle1",true</P><P></P><P>Can someone shed some light here pls.?</P></BODY></HTML> Fri, 15 Jun 2012 01:51:44 GMT 2012-06-15T01:51:44Z How to select a field with alternate state using a macro https://community.qlik.com/t5/QlikView/How-to-select-a-field-with-alternate-state-using-a-macro/m-p/354272#M131490 <HTML><HEAD></HEAD><BODY><P>I want to select a field with alternate state using a macro.</P><P></P><P>The following statement works for the field with default state.</P><P></P><P style="padding-left: 30px;">ActiveDocument.Fields("Aisle").Select&nbsp; "Aisle1",true</P><P></P><P>I want to extend this to be used with an alternate state called "State1".</P><P></P><P>I tried the following but no luck so far;</P><P></P><P style="padding-left: 30px;">ActiveDocument.Fields("State1::Aisle").Select&nbsp; "Aisle1",true</P><P style="padding-left: 30px;">ActiveDocument.Fields("{State1}Aisle").Select&nbsp; "Aisle1",true</P><P></P><P>Can someone shed some light here pls.?</P></BODY></HTML> Fri, 15 Jun 2012 01:51:44 GMT https://community.qlik.com/t5/QlikView/How-to-select-a-field-with-alternate-state-using-a-macro/m-p/354272#M131490 2012-06-15T01:51:44Z Re: How to select a field with alternate state using a macro https://community.qlik.com/t5/QlikView/How-to-select-a-field-with-alternate-state-using-a-macro/m-p/354273#M131491 <HTML><HEAD></HEAD><BODY><DIV><SPAN style="font-size: 8pt;"><DIV>...Better late than never.</DIV><DIV> </DIV><DIV>Either of the below lines should work for you:</DIV><DIV> </DIV><DIV><SPAN style="font-size: 8pt;">ActiveDocument.GetField("Aisle", "State1").Select "Aisle1", True</SPAN></DIV><DIV> </DIV><DIV>ActiveDocument.Fields("Aisle", "State1").Select "Aisle1", True</DIV></SPAN><DIV> </DIV></DIV><DIV> </DIV><DIV> </DIV></BODY></HTML> Tue, 07 Aug 2012 18:09:35 GMT https://community.qlik.com/t5/QlikView/How-to-select-a-field-with-alternate-state-using-a-macro/m-p/354273#M131491 Anonymous 2012-08-07T18:09:35Z Re: How to select a field with alternate state using a macro https://community.qlik.com/t5/QlikView/How-to-select-a-field-with-alternate-state-using-a-macro/m-p/354274#M131492 <HTML><HEAD></HEAD><BODY><P>Thank you a million times for this mchasse1, it worked.</P></BODY></HTML> Wed, 08 Aug 2012 22:59:28 GMT https://community.qlik.com/t5/QlikView/How-to-select-a-field-with-alternate-state-using-a-macro/m-p/354274#M131492 2012-08-08T22:59:28Z Re: How to select a field with alternate state using a macro https://community.qlik.com/t5/QlikView/How-to-select-a-field-with-alternate-state-using-a-macro/m-p/354275#M131493 <HTML><HEAD></HEAD><BODY><P>A late thank you mchasse!&nbsp; Really useful - why they can't put this in the documentation or at least the API Guide is beyond me!!</P></BODY></HTML> Thu, 08 Nov 2012 11:32:11 GMT https://community.qlik.com/t5/QlikView/How-to-select-a-field-with-alternate-state-using-a-macro/m-p/354275#M131493 nathanfurby 2012-11-08T11:32:11Z Re: How to select a field with alternate state using a macro https://community.qlik.com/t5/QlikView/How-to-select-a-field-with-alternate-state-using-a-macro/m-p/354276#M131494 <HTML><HEAD></HEAD><BODY><P>Thank you Mike.</P><P></P><P>Out of morbid curiosity, where would one locate this information in documentation??</P></BODY></HTML> Mon, 07 Apr 2014 13:52:01 GMT https://community.qlik.com/t5/QlikView/How-to-select-a-field-with-alternate-state-using-a-macro/m-p/354276#M131494 Anonymous 2014-04-07T13:52:01Z Re: How to select a field with alternate state using a macro https://community.qlik.com/t5/QlikView/How-to-select-a-field-with-alternate-state-using-a-macro/m-p/354277#M131495 <HTML><HEAD></HEAD><BODY><P>Thanks Mike, I will be able to sleep tonight now <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 15 Sep 2014 14:00:35 GMT https://community.qlik.com/t5/QlikView/How-to-select-a-field-with-alternate-state-using-a-macro/m-p/354277#M131495 2014-09-15T14:00:35Z