- 13 Dec 2023
- 1 Minute to read
- DarkLight
Set Datasource Variable
- Updated on 13 Dec 2023
- 1 Minute to read
- DarkLight
General
This type of action can be used to set the value of the variable of a Datasource.
Properties
This type of action has the following properties:
Name | Description |
---|---|
Datasource Variable | The datasource variable whose value shall be set. |
Value | An Expression that evaluates to the string (text) value to set the variable to. |
QlikView and Qlik Sense Considerations
When setting a variable in a QlikView or Qlik Sense Datasource, the value of the variable needs to be a string (text value) that contains the same QlikView or Qlik Sense expression you would enter in QlikView or Qlik Sense itself to define the variable.
Example 1: Numeric Value
The value expression needs to return the following string in order to set the variable to the numeric value 1:
=1
In order to achieve this return value, the Mail & Deploy expression could look like:
"=1"
Example 2: Text Value
The value expression needs to return the following string in order to set the variable to the text value Hello World:
='Hello World'
In order to achieve this return value, the Mail & Deploy expression could look like:
"='Hello World'"
Example 3: Date Value
The value expression needs to return the following string in order to set the variable to the date value January 3rd 2021:
=MakeDate(2021, 1, 3)
In order to achieve this return value, the Mail & Deploy expression could look like:
"=MakeDate(2021, 1, 3)"