topic Selecting multiple values in a field using a macro in QlikView

Selecting multiple values in a field using a macro

Wed, 30 Mar 2011 09:11:42 GMT

Hi,

I would like to create a macro which is triggered when a variable is changed through an inputbox. Therefore I have created the following simple macro.

Sub SwitchFieldSelection set vVariable = ActiveDocument.Variables("v_Switch") IF vVariable.GetContent.String = "Yes" THEN set objField = ActiveDocument.Fields("Type") set objFieldValues = objField.GetNoValues objField.Unlock objFieldValues.Add objFieldValues.Add objFieldValues(0).Text = "Type1" objFieldValues(0).IsNumeric = false objFieldValues(1).Text = "Type" objFieldValues(1).IsNumeric = false objField.SelectValues objFieldValues objField.Lock ELSE set objField = ActiveDocument.Fields("Type") objField.Unlock objField.Clear objField.Lock END IF End Sub

The problem is that only the second value is selected in the field, so in this case 'Type2'

Am I doing something wrong or is it simply not possible this way?

Regards

EDIT: Found the solution, was just a simple typo in the value which in want to select. So this is solved.

Selecting multiple values in a field using a macro

Anonymous — Wed, 30 Mar 2011 09:53:02 GMT

Maybe you can use the toggleselect function.
I used it and it works for me:

Here is an example of what I used:

sub NameSub

set FIELDNAME = activedocument.fields("FIELDNAME")

FIELDNAME.select "20200" ' clears all in FIELDNAME and selects 20200

FIELDNAME.toggleselect "50300" ' selects 50300

FIELDNAME.toggleselect "60200" ' selects 60200

end sub

Selecting multiple values in a field using a macro

Anonymous — Wed, 30 Mar 2011 10:34:29 GMT

See my response closer to the end of this: http://community.qlik.com/forums/t/43234.aspx
Very simple macro, also with toggleselect, as from Dennis.