Functions Data

GlobalVariable

GlobalVariable() allows users to access variables configured by the administrator on a global level. These variables can be accessed from Reports, Custom Sources, Custom Functions, Data Feeds, Virtual Feeds, and other third-party applications such as Excel.


Syntax:

Qx.GlobalVariable(Name)
  • In Excel with Quintessence addin versions prior to 25.1, use: GlobalVariable()
  • In the Quintessence Editor (Studio) using Quintessence language, use: GlobalVariable()
  • In the Quintessence Editor (Studio) using Python language, use: Qx. GlobalVariable()
 See parameter descriptions

NameThe name of the global variable.

Examples:

> Example 1: Calling a Global Variable from Excel


Suppose the administrator has set up a global variable called Version. This variable returns the current version of Quintessence installed.

=Qx.GlobalVariable("Version")
  • If the variable is configured as sensitive, the function returns:
GlobalVariable(“Version”)
  • If the variable is not sensitive, the function returns the actual value of the variable, for example:
25.1.55