Sets a query parameter value of a Query Table.
Anaplan XL Reporting now includes a updated version of this feature. More information about which can be found in SQL Data Tables (Administrators).
Syntax
XL3QueryTableSetParam( SheetName, QueryTableName, ParameterName, Value )
Parameters
| Parameter | Description |
| SheetName | Name of the worksheet where the Query Table is located. |
| QueryTableName | Name of the Query Table. |
| ParameterName | The name of the parameter to set the value for. |
| Value | The new value to set. |
