topic GetSelectedValues in VBScript limited to 100 Values? in QlikView

GetSelectedValues in VBScript limited to 100 Values?

Mon, 21 Feb 2011 09:16:26 GMT

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?

GetSelectedValues in VBScript limited to 100 Values?

Anonymous — Mon, 21 Feb 2011 09:50:15 GMT

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.

GetSelectedValues in VBScript limited to 100 Values?

Anonymous — Mon, 21 Feb 2011 09:51:39 GMT

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

Example:

getSelectedValues(200)

GetSelectedValues in VBScript limited to 100 Values?

suniljain — Mon, 21 Feb 2011 09:57:59 GMT

you can use following logic

If(getSelectedValue(FieldName) >100)

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

Else

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

Endif

GetSelectedValues in VBScript limited to 100 Values?

Mon, 21 Feb 2011 10:16:11 GMT

try following vb script,

set fld=ActiveDocument.GetField("Number")

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

GetSelectedValues in VBScript limited to 100 Values?

Mon, 21 Feb 2011 10:28:09 GMT

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

GetSelectedValues in VBScript limited to 100 Values?

Mon, 21 Feb 2011 10:42:35 GMT

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