Selecting all values except a cetain

[#1]

Hi

I would like to know how to select all values except a certain one.

Something like:

ActiveDocument.Fields("Field1").Select not("a")

so all values shall be selected but not "a". Is it possible in Qlikview macros?

Thank you, Lukas

[nagaiank]

Try the following lines in the macro.

ActiveDocument.Fields("Field1").Select "a"

ActiveDocument.Fields("Field1").SelectExcluded

This worked for me.

[#3]

H

Yes, this is working, but unfortunatelly for one value only. As soon as I try to excude multiple values it is not working as supposed. My problem is that I have a list containing blank values as well. I am trying to make them invisible it the user clicks a button. So I can not use the property of a table to hide zero values.

My "blanks" are shown as a smal "-" on the left. and I would like to create a button which will switch them off and on again. It shall work as the ToggleSelect.

I was also thinking about making a If condition and check if the values are greater then zero but this do not work for me.

Maybe someone had this problem and solved it somehow.

Thank you

[nagaiank]

The attached example has a listbox and a button to select excluded items. This does not use any macro. You may try something like this in your application.