https://community.qlik.com/t5/QlikView/Qlikview-Macro/m-p/1761693#M591824 <P>Hi <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/118655">@Gatter</a>&nbsp;,&nbsp; If in the GUI there are some values selected, you just have to use this :</P><P><BR />ActiveDocument.Fields("<SPAN>SMRY_SUPERVISOR_NAME_MHKO</SPAN>").SelectExcluded</P> Fri, 13 Nov 2020 20:34:20 GMT QFabian 2020-11-13T20:34:20Z https://community.qlik.com/t5/QlikView/Qlikview-Macro/m-p/1709147#M591823 <P>I sure could use some help with a QlikView macro problem I have.&nbsp; The macro in the "Edit Module" section of QlikView and the macro is written based off of "VBScript".</P><P>Within my macro I have lines like below:</P><P>ActiveDocument.Fields("SMRY_SUPERVISOR_NAME_MHKO").Select "SUPERVISOR NAME_1"</P><P>ActiveDocument.Fields("SMRY_SUPERVISOR_NAME_MHKO").ToggleSelect "SUPERVISOR NAME_2"</P><P>The above works perfect and&nbsp;I am getting what I need for both of these supervisors selected.</P><P>&nbsp;</P><P>My Problem:</P><P>What I need is say that I want all supervisors from this field EXCEPT for a few selected supervisors.</P><P>Thanks,</P><P>Jeff</P> Mon, 08 Jun 2020 19:03:40 GMT https://community.qlik.com/t5/QlikView/Qlikview-Macro/m-p/1709147#M591823 Gatter 2020-06-08T19:03:40Z https://community.qlik.com/t5/QlikView/Qlikview-Macro/m-p/1761693#M591824 <P>Hi <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/118655">@Gatter</a>&nbsp;,&nbsp; If in the GUI there are some values selected, you just have to use this :</P><P><BR />ActiveDocument.Fields("<SPAN>SMRY_SUPERVISOR_NAME_MHKO</SPAN>").SelectExcluded</P> Fri, 13 Nov 2020 20:34:20 GMT https://community.qlik.com/t5/QlikView/Qlikview-Macro/m-p/1761693#M591824 QFabian 2020-11-13T20:34:20Z