Help needed with SelectExcluded in Macro. It clears existing selection.

[#1]

Hi,

I have a macro in my Qlikview app where i loop through a listbox values. In the macro i select a value in listbox and use the function SelectExcluded to select all values excluding the one selected first.

The problem i have is that SelectExcluded force clears my existing selections to select literally all values except the one. I want it to only select excluded values from  my current selection.

Any help on this will be appreciated. Thanks a lot in advance.

[tamilarasu]

Hi Sunny,

Could you post a sample file that demonstrates the problem?

[m_woolf · Accepted solution]

You might lock you other fields before the Select Excluded and then Unlock after.

[#4]

Thank you m w..!!