topic Re: Assign QV variable value in Macro in QlikView

Assign QV variable value in Macro

Mon, 21 Dec 2015 14:15:19 GMT

Hi Friends,

I want to assign the QV variable value inside Macro and call the macro using button click.

Below is the coding I have used:

Sub Procedure

dim strValueToDisplay

set strValueToDisplay = ActiveDocument.Variables("V_AMID_Macro").GetContent().String

msgbox("The value of ""vValueToDisplay"" is: " & strValueToDisplay)

END Sub

But when I click the button it is taking to the edit module page instead of displaying the message box.

Please help to solve the issue.

Thanks.

marcus_sommer — Tue, 22 Dec 2015 00:57:45 GMT

Change it into:

Sub Procedure

dim strValueToDisplay

strValueToDisplay = ActiveDocument.Variables("V_AMID_Macro").GetContent.String

msgbox("The value of ""vValueToDisplay"" is: " & strValueToDisplay)

END Sub

- Marcus

tamilarasu — Tue, 22 Dec 2015 01:38:38 GMT

Or try,

Sub Procedure

Set var = ActiveDocument.Variables("V_AMID_Macro")

MsgBox("The value of ""vValueToDisplay"" is: " & var.GetContent.String)

End Sub

jagan — Tue, 22 Dec 2015 02:50:51 GMT

Hi,

The message box expression should be

msgbox("The value of vValueToDisplay is: " & strValueToDisplay)

Is vValueToDisplay is a variable in macro? If yes also create a variable for this.

Check this link for more macro samples