topic ActiveDocument.GetCurrentSelections -> Selections converted to "7 of 34" when I select more... in QlikView

ActiveDocument.GetCurrentSelections -> Selections converted to "7 of 34" when I select more...

Anonymous — Fri, 19 Mar 2010 18:54:03 GMT

I thought I was getting a string of selections but at some point, my selection get converted into a string something like "7 of 34" instead of the list of selections. Can I overide this? There must be some string limit the the object does not give you all the selections...

set x = ActiveDocument.GetCurrentSelections

s = x.Selections

v = x.VarId

for i = lbound(s) to ubound(s)

msgbox v(i)&" = "&s(i)

next

ActiveDocument.GetCurrentSelections -> Selections converted to "7 of 34" when I select more...

Anonymous — Fri, 19 Mar 2010 20:23:59 GMT

So, this works for me. Instead of using GetCurrentSelections I use GetSheetObject and grab my list box. Here's the code snippet I adapted to fit this need.

set LB = ActiveDocument.GetSheetObject("LB02")

for i = lbound(boxvalues) to ubound(boxvalues)

msgbox(boxvalues(i))

next

***Note that the above also only enumerates through selected list box members. I was not expecting this behaviour but am pleasantly surprised because that is exactly what I was trying to achieve.