topic Re: store looped values in a variable (macro) in QlikView

store looped values in a variable (macro)

Frank_Hartmann — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys

I have the following macrocode which returns activated objectIDs.

Sub getActiveObjectID

set s=ActiveDocument.ActiveSheet

objs=s.GetSheetObjects

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

if objs(i).IsActive then

var = right(objs(i).GetObjectId,4)

msgbox(var)

end if

next

End Sub

For example If I have CH01, CH02 and TX01 activated how can i store this as a string in a variable while executing the macro, like:

msgBox(Variable) = "CH01","CH02","TX01"

Any Ideas?

Re: store looped values in a variable (macro)

el_aprendiz111 — Tue, 11 Jul 2017 19:05:58 GMT

Hi,

Sub getActiveObjectID

set s=ActiveDocument.ActiveSheet

objs=s.GetSheetObjects

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

if objs(i).IsActive then

var = right(objs(i).GetObjectId,4)

msgbox(var)

end if

set v = ActiveDocument.Variables("MyVar")

v.SetContent var,true

End Sub

Re: store looped values in a variable (macro)

Frank_Hartmann — Tue, 11 Jul 2017 19:27:43 GMT

hi fer fer,

thank you for your answer

your piece of code only adds the last marked object to the variable.

In the below example i expect the output for MyVar to be :

MyVar = TX05,TX06,TX07

Re: store looped values in a variable (macro)

el_aprendiz111 — Tue, 11 Jul 2017 19:48:26 GMT

Hi,

Sub getActiveObjectID

set s=ActiveDocument.ActiveSheet

objs=s.GetSheetObjects

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

if objs(i).IsActive then

var = var & chr(34)& right(objs(i).GetObjectId,4) & chr(34) & chr(44)

msgbox(var)

end if

set v = ActiveDocument.Variables("MyVar")

v.SetContent var,true

End Sub

Re: store looped values in a variable (macro)

Frank_Hartmann — Tue, 11 Jul 2017 19:56:43 GMT

that works.

thank you very much!