topic Re: Is it possible to create a document variable using vbs? in QlikView

Is it possible to create a document variable using vbs?

NikVladi — Mon, 23 Sep 2024 11:29:49 GMT

If yes, then how? Need something like this:

ActiveDocument.Variables.Create("myNewVariable")

Re: Is it possible to create a document variable using vbs?

NikVladi — Mon, 23 Sep 2024 23:36:01 GMT

ActiveDocument.CreateVariable("MyVariable")

https://help.qlik.com/en-US/qlikview-developer/May2024/Subsystems/Automation/Content/QV_Automation/APIGuide/QlikViewComApiGuide.zip

Re: Is it possible to create a document variable using vbs?

rwunderlich — Tue, 24 Sep 2024 15:25:29 GMT

For what it's worth, here's the standard bit of code I use in my QV Modules for setting, getting and creating Variables.

Rem *** Returns a Variables content as String
Function GetVariableString(varname)
  GetVariableString = GetVariable(varname).GetContent.String
End Function

Rem ** Gets a variable and creates it if it doesn't exist
Function GetVariable(varname)
  If typename(ActiveDocument.GetVariable(varname)) <> "Variable" Then
    ActiveDocument.CreateVariable(varname) 
    ActiveDocument.GetVariable(varname).SetContent "", True
  End If
  Set GetVariable = ActiveDocument.GetVariable(varname)
End Function ' GetVariable

Rem ** Sets a Variable's value
Sub SetVariable(varname, value)
  GetVariable(varname).SetContent value, False
End Sub

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com