The Qlik Sense Enterprise on Windows November 2023 release introduced Data window functions in the engine load script. See What's New. The feature enables complex calculations on data tables in the Qlik load script to perform aggregation on different partitions without losing the granularity of the data.
The feature is not switched on by default in the November 2023 release. This article documents how to enable it.
Resolution
Qlik Sense Server
- Stop the Qlik Sense Engine and Qlik Sense Service Dispatcher services on all nodes with engines.
- Navigate to Settings.ini file
By default, it is located under C:\ProgramData\Qlik\Sense\Engine\Settings.ini
- Open the file as an administrator.
- Add this parameter
EnableWindowScriptFunction=1
- Save the file.
- Start the Qlik Sense Engine and Qlik Sense Service Dispatcher services on each node.
Qlik Sense Desktop
- Navigate to Settings.ini file
By default, it is located under C:\Users\<username>\Documents\Qlik\Sense\Settings.ini
- Open the file as an administrator.
- Add this parameter
EnableWindowScriptFunction=1
- Save the file.
The feature will be automatically enabled in future releases and service releases.
Internal Investigation ID(s):
QB-23790
Related Content
What's New Nov 2023
How to modify Qlik Sense Engine's Settings.ini
Environment
Qlik Sense on Windows Nov 2023 IR