topic Unable to set the variable name in QlikView

Unable to set the variable name

Thu, 03 Jun 2010 13:31:28 GMT

<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>

Unable to set the variable name

SunilChauhan — Thu, 03 Jun 2010 13:43:38 GMT

i thing variable will be access using

set v = ActiveDocument.Variables("vControl")

Unable to set the variable name

Thu, 03 Jun 2010 13:45:48 GMT

Try Using

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

Strongs,

Unable to set the variable name

Thu, 03 Jun 2010 14:03:44 GMT

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?

Unable to set the variable name

Thu, 03 Jun 2010 14:40:50 GMT

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