Unable to set the variable name - Qlik Community

Report Inappropriate Content · ‎2010-06-03

<body>Hi All, I am trying to set a variable with the sheet name and want to use that variable value in edit script to filter data set further. I doing this in the following steps: Step 1> Setting the variable name with the sheetname sub SheetSelection set vSheetName = ActiveDocument.ActiveSheet.GetProperties.Name end sub Step 2> Calling this macro at OnActivateSheet event. Step 3> On the basis of variable vSheetName, loading the following fields in the edit script and getting Error message at the time of loading data : <Field not found - vSheetName> Load <Field1>, <Field2>, <Field3> resident Directory where <Field4> = vSheetName; Please have a look and let me know where i am going wrong. Thanks in advance<vsheetname></vsheetname></body>

SunilChauhan · ‎2010-06-03

i thing variable will be access using

set v = ActiveDocument.Variables("vControl")

Sunil Chauhan

Report Inappropriate Content · ‎2010-06-03

Try Using

V = Activeocument.ActiveSheet.Variables('Variablename")

Strongs,

Report Inappropriate Content · ‎2010-06-03

Thanks for the reply. I used following expression

Load
<Field1>,
<Field2>,
<Field3>
resident Directory
where <Field4> = = ActiveDocument.Variables("vSheetName");
but it is giving following error,

ACTIVEDOCUMENT.VARIABLES is not a valid function.

Any other way?

Report Inappropriate Content · ‎2010-06-03

Hi mansi

A macro variable is not seen by QV load script.

Make sure your variable exists or create it first (Settings/Variable Overview)

In your macro use

set v = ActiveDocument.GetVariable("vSheetName")
v.SetContent "<sheetname>",true

check with Settings/Variable that you have the correct content in the variable.

In the load refer to the variable with $(vSheetName)

Good luck

Juerg