topic Re: VBA - Current Selection Box in QlikView

VBA - Current Selection Box

LaIs — Sat, 09 Jan 2021 10:49:23 GMT

Hello,

I'd need to have the selected field-selection pairs from the activesheets current selection box, however I could not manage to access to the CS boxes through ActiveDocument.Activesheet.GetCurrentSelections.

I tried the below in Qlik and got an "object required" error + in python with COM, the result was an empty tuple.

sub d

x = ActiveDocument.ActiveSheet.GetCurrentSelections // tried with set x too..
s = x.Selections
v = x.VarId
for i = lbound(s) to ubound(s)
msgbox v(i)&" = "&s(i)
next
end sub

Any help is appreciated,

thx,

Re: VBA - Current Selection Box

Frank_Hartmann — Sat, 09 Jan 2021 11:43:18 GMT

try this:

sub d x = ActiveDocument.GetCurrentSelections s = x.Selections v = x.VarId for i = lbound(s) to ubound(s) msgbox v(i)&" = "&s(i) next end sub

Re: VBA - Current Selection Box

LaIs — Sat, 09 Jan 2021 14:46:11 GMT

I tried, but the result is not the active sheets current selection box, but the first sheets selections. I suppose there is a reason why we have activesheet.getcurrentselection separately in the API guide?

Actually what I dont understand is why I get the object required error, as I have the same code as in the guide