topic Macro - Select all but in QlikView

Macro - Select all but

camilo — Mon, 21 Sep 2009 20:31:28 GMT

Hi,

I´m Trying to make a macro that selects everything except one tipe of field.

Right now I know if I want to select that one field I have to use:

Sub Reempaque
ActiveDocument.Fields("Variedad").Clear
ActiveDocument.Fields("Variedad").Select("Reempaque")
end sub

But I want to select all the other fields but "Reempaque" what do I have to use?

Thanks,

Macro - Select all but

Mon, 21 Sep 2009 20:39:59 GMT

You can use ToggleSelect to unselect a selected value.

So if you use:

Sub Reempaque
 ActiveDocument.Fields("Variedad").SelectAll
 ActiveDocument.Fields("Variedad").ToggleSelect("Reempaque")
end sub

Macro - Select all but

disqr_rm — Mon, 21 Sep 2009 20:43:02 GMT

Sub AllOtherThenReempaque
ActiveDocument.Fields("Variedad").Clear
ActiveDocument.Fields("Variedad").Select("Reempaque")
ActiveDocument.Fields("Variedad").SelectExcluded

end sub

Macro - Select all but

camilo — Mon, 21 Sep 2009 21:05:04 GMT

Thanks very much Rakesh and Nmiller, I tried the SelectExcluded option and it does work perfectly!

Macro - Select all but

Sat, 10 Oct 2009 02:36:14 GMT

I tried just this below to create a macro. This selects all items in a the field. However I want to be able to just pick 1 item, any item in that field. However I cannot name a specific one because that will always be different. Any ideas on how to just get it to pick one, maybe the first in the list?

function

{

ActiveDocument.Fields(

"ResidentName").ToggleSelect("*")

}

Select()