topic Re: Variables and Macro in QlikView

Variables and Macro

Fri, 23 Nov 2012 20:04:28 GMT

Hi Guys

How can i access the Name of the variables that has been created in variable overview in macro.

I am using Following Macro Script but it is giving me name of the variables apart from i have created.

Set Vars = ActiveDocument.GetVariableDescriptions

For k = 0 to vars.Count - 1

Set v = vars.Item(k)

MsgBox(v.Name)

Guys Please help .....

Re: Variables and Macro

Gysbert_Wassenaar — Sat, 24 Nov 2012 09:51:13 GMT

I haven't found a property to distinguish a user defined variable from a system variable. The only thing I can think of is starting at 25 to skip the system variables: For k = 25 to vars.Count - 1

Re: Variables and Macro

IAMDV — Sat, 24 Nov 2012 12:05:27 GMT

Hi Manish,

Gysbert is right... there is no inherit property to distinguish whether it's User or Sytem variables. However, if you can follow a standard naming convention while creating the variables then you can use string/ pattern search to identify whether its User or System variable. And this is good practice when you have more than handful of variables. I always follow a standard naming convention, something like this:

Generic Variables:

v_HideShow

v_MyString

v_ConcatFieldValue

Expression Variables:

v_Exp_TotalSales

v_Exp_AvgSales

v_Exp_MonthlySales

Colour Variables:

v_Colour_Primary_01

v_Colour_Primary_02

....

Once you follow the standard naming convention then you easily call your variables by using below script.

Sub VariableNames

Set Vars = ActiveDocument.GetVariableDescriptions

For k = 0 to vars.Count - 1

Set v = vars.Item(k)

IF Left(v.Name, 2) = "v_" Then

MsgBox(v.Name)

Else

End if

Next

End Sub

I hope this helps!

Good luck!

Cheers,