Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I write a macro shows below.
sub test(varible)
msgbox varible
end sub
Now I want to transfer parameter from qlikview to macro. I create a qlikview button, and input macro name : test(hello). But when I click the button, no msgbox come out carry the hello word. Why? And what can i do next?
You cannot pass a variable in that way from a button to a macro. You should create a QlikView Variable that the macro can use, call just the macro "test" in the button and then in that macro recall the value of the QlikView variable. Something like the below example:
sub test
set v = ActiveDocument.Variables("Variable1")
msgbox(v.GetContent.String)
end sub
Regards.
You cannot pass a variable in that way from a button to a macro. You should create a QlikView Variable that the macro can use, call just the macro "test" in the button and then in that macro recall the value of the QlikView variable. Something like the below example:
sub test
set v = ActiveDocument.Variables("Variable1")
msgbox(v.GetContent.String)
end sub
Regards.
Thank you very much.