topic Macro to select values in listbox in QlikView

Macro to select values in listbox

Wed, 18 Jan 2012 11:23:33 GMT

Hello,

i'm trying to select the values in a list box but i only get this message:

Type mismatch: 'ActiveDocument.Fields(...).Select'

My small macro only contains this code:

ActiveDocument.Fields("UNIT").Select ActiveDocument.Fields("UNIT").GetSelectedValues

Can someone help me, please?

Kind regards

Piskitta

Re: Macro to select values in listbox

Wed, 18 Jan 2012 12:27:28 GMT

Hi,

Use this code in ur macro..........

ActiveDocument.Fields("UNIT").Select "UNIT_VALUE"

Thanks & Regards,

Parag

Re: Macro to select values in listbox

Wed, 18 Jan 2012 12:54:33 GMT

Thanks for your answer Parag, but it's not what I was looking for.

My macro needs to select the value choosed by the user. But no matter what I try i keep getting the same error.

This is my last test, with no sucess sadly...

Sub SelectUnit

set UnitSelected = ActiveDocument.Fields("UNIT").GetSelectedValues

for i = 0 to UnitSelected.Count - 1

ActiveDocument.Fields("UNIT").Select(UnitSelected(i))

NEXT

End Sub

Best regards

Dulce

Macro to select values in listbox

jduenyas — Wed, 18 Jan 2012 17:49:36 GMT

Try this:

set UnitSelected=ActiveDocument.Fields("UNIT").GetselectedValues

   for i = 0 to val.Count-1
     ActiveDocument.Fields("UNIT").Select UnitSelected.Item(i).Text
   Next i

best regards

Re: Macro to select values in listbox

Thu, 19 Jan 2012 15:03:00 GMT

Hello,

thanks for the answer but mu problem keeps being the same.

I tried everything that i could find in the internet. But I had no luck.

Thanks,once again.

Kind regards

Dulce

Re: Macro to select values in listbox

jduenyas — Thu, 19 Jan 2012 17:43:53 GMT

I am puzzled by what it is that you are trying to achieve and why it did not work for you.

This works:

ArrayListOfNames = Array("Name","Name",Name"...)

SelectInListBox "<ListBoxName>", ArrayListOfNames

....

Example:

List box name = MyListBox

ArrayListOfNames = Array("piskitta","jduenyas")

SelectInLisBox "MyListBox", ArrayOfNames

(Replace "Name" with your variables, replace <ListBoxName> with your list box name)

The names must already exit in the listbox in order to be "selected"

Alternately you can iterate through the array with a For...Next

Best regards

Re: Macro to select values in listbox

rwunderlich — Thu, 19 Jan 2012 19:05:07 GMT

I'm confused as to what you are trying to do. You are trying to make selections in the field "UNIT" that the user has already made selections in?

Re your type mismatch error. GetSelectedValues returns an IArrayOfFieldValue object. The function that reads IArrayOfFieldValue is SelectValues, not Select.

Set x = ActiveDocument.Fields("y").GetSelectedValues

ActiveDocument.Fields("z").SelectValues x

-Rob

Macro to select values in listbox

Fri, 20 Jan 2012 07:11:44 GMT

Thanks Rob,

I didn't know what was going wrong here.

That fixed my problem.

Regards

Dulce

Re: Macro to select values in listbox

Tue, 18 Feb 2014 10:24:35 GMT

Hi Rob,

how can i add another value to object returned by the function getSelectedValues?

Thanks

Re: Macro to select values in listbox

Thu, 10 Jul 2014 16:55:02 GMT

Using SelectValues instead of select did not work for me.

Re: Macro to select values in listbox

Wed, 08 Jul 2015 15:11:48 GMT

Hi,

Can I put the ActiveDocument.Fields("UNIT").Select "UNIT_VALUE" right into my script editor? How to use this script.