topic Selecting all values except a cetain in QlikView

Selecting all values except a cetain

Thu, 12 May 2011 15:31:52 GMT

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

Selecting all values except a cetain

nagaiank — Thu, 12 May 2011 16:27:47 GMT

Try the following lines in the macro.

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

ActiveDocument.Fields("Field1").SelectExcluded

This worked for me.

Selecting all values except a cetain

Fri, 13 May 2011 04:53:07 GMT

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

Re: Selecting all values except a cetain

nagaiank — Fri, 13 May 2011 07:18:01 GMT

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.