What’s new in QlikView September 2026?

Window script function enhancements

The syntax, functionality, and documentation of window functions have been enhanced to improve usability and flexibility. Window functions are commonly used for analytics and ML data preparation scenarios that require aggregations across different partitions without losing the grain of the input data.

Enhancements include:

• Added support for performing aggregations on data ordered by a specified sorting expression, enabling sorted sliding windows instead of relying on the default load order.

• Clarified documentation and improved behavior when handling optional parameters

• Fixed an issue where the WRank function returned incorrect values when nested inside another expression.

Window functions

Script-only variables and drop mapping tables

Mapping tables can now be dropped as soon as they are no longer needed, improving memory efficiency during reloads, particularly helpful for large mapping tables or iterative scripts.

Drop table

The load script now also supports script-only variables and explicit variable dropping, ensuring temporary variables do not appear in loaded data.

ScriptOnlyVariables

Drop variable

OAuth 2.0 authentication for sending email

QlikView now supports sending email through Microsoft 365 using OAuth 2.0 authentication and the Microsoft Graph API.

Enhancements include:

• Added support for OAuth 2.0 authentication in QlikView and Qlik Management Console.

• Added support for Microsoft Entra ID application registration for email authentication.

• Added encrypted storage for the tenant ID, client ID, and client secret.

Deprecations

The following functionality has been deprecated.