Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

GetSelectedValues in VBScript limited to 100 Values?

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?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

Example:

getSelectedValues(200)

View solution in original post

6 Replies
Anonymous
Not applicable
Author

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
Not applicable
Author

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

Example:

getSelectedValues(200)

suniljain
Master
Master

you can use following logic

If(getSelectedValue(FieldName) >100)

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

Else

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

Endif

Not applicable
Author

Hi

try following vb script,

set fld=ActiveDocument.GetField("Number")

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



Not applicable
Author

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

Not applicable
Author

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