topic Set multi values to field via macro in QlikView

Set multi values to field via macro

Wed, 22 Dec 2010 15:44:54 GMT

Hi,

Does anyone know how to set multi values to a specific field via a macro VBScrip?

I want to create a macro that will select the values "Dad" and "Mom" at the field named "Pos".

I'v tried:

SUB SET_POS

ActiveDocument.Fields("Pos").Select "Dad", "Mom"

END SUB

But it won't do.

Set multi values to field via macro

Wed, 22 Dec 2010 15:50:40 GMT

Select only allows one value and it deselects all other values. You need ToggleSelect. ToggleSelect will select a value and keep the current selections. If the value is already selected, it will unselect it.

ActiveDocument.Fields("Pos").Select "Dad"
 ActiveDocument.Fields("Pos").ToggleSelect "Mom"

Set multi values to field via macro

Wed, 22 Dec 2010 16:09:34 GMT

Thanks, this is what I was looking for.