GetSelectedValues in VBScript limited to 100 Values?

[#1]

Hello everybody,

i tried to get the selected Values via VB Script.
To me it seems, that GetSelectedValues is limited to 100.

Find an example attached.

If you select up to 100 Values from the Listbox and press "Count", the Script show the correct number.
If you select more than 100 values, the Counter always shows 100 - even if you selected more.

Any idea how to solve this?

[Anonymous]

GetSelectedValues has a default limit of 100, use a second paramater to set it to a higher value if needed.

See the APIGuide.qvw in the QlikView\Documentation folder for further info.

[Anonymous · Accepted solution]

I just read my reply and it sounds a little confusing.

Example:

getSelectedValues(200)

[suniljain]

you can use following logic

If(getSelectedValue(FieldName) >100)

...........................

Else

............................

Endif

[#5]

Hi

try following vb script,

set fld=ActiveDocument.GetField("Number")

msgbox("The field has "& fld.GetValueCount(1) &" selected values")

[#6]

Hi dj-kalle,

May u have to use this ..

sub count
set selection = ActiveDocument.getField("Number").getSelectedValues(300)
msgbox(selection.Count)
end sub

You have to specifies the range like 300 in your scripting.

Regards ,

Yogesh

[#7]

Thank you so much for the answers, that solved my problem!!