Qlikview Macro

[Gatter]

I sure could use some help with a QlikView macro problem I have.  The macro in the "Edit Module" section of QlikView and the macro is written based off of "VBScript".

Within my macro I have lines like below:

ActiveDocument.Fields("SMRY_SUPERVISOR_NAME_MHKO").Select "SUPERVISOR NAME_1"

ActiveDocument.Fields("SMRY_SUPERVISOR_NAME_MHKO").ToggleSelect "SUPERVISOR NAME_2"

The above works perfect and I am getting what I need for both of these supervisors selected.

My Problem:

What I need is say that I want all supervisors from this field EXCEPT for a few selected supervisors.

Thanks,

Jeff

[QFabian]

Hi @Gatter ,  If in the GUI there are some values selected, you just have to use this :

ActiveDocument.Fields("SMRY_SUPERVISOR_NAME_MHKO").SelectExcluded