Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
I just read my reply and it sounds a little confusing.
Example:
getSelectedValues(200)
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.
I just read my reply and it sounds a little confusing.
Example:
getSelectedValues(200)
you can use following logic
If(getSelectedValue(FieldName) >100)
...........................
Else
............................
Endif
Hi
try following vb script,
set fld=ActiveDocument.GetField("Number")
msgbox("The field has "& fld.GetValueCount(1) &" selected values")
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
Thank you so much for the answers, that solved my problem!!