Key Driver Analysis

Key Driver Analysis is a new capability in Qlik Cloud that leverages the power of Qlik AutoML to help people easily understand the most influential factors that are driving the outcomes in their analytics. Users can simply right click on any object to initiate a key driver analysis, specify a target measure and, and if desired, specific features they want to include. The AutoML engine will then generate an analysis that shows the fields in your data model that are most effecting the target measure, complete with visualizations and NLG.

You can see the key drivers ranked by importance, and can further select each one to get a breakdown and distribution of the values and their influence. With key drivers, users can better understand the reasons for historical results, not just the what but the why, providing deeper insight and supporting more meaningful action.

Uncovering the key influencers behind your data using key driver analysis

Custom SQL in Direct Query

Custom SQL in Direct Query is a new feature that many customers have been asking for. The custom SQL statements are added in the load script and can be combined with variables and dollar expansion. Custom SQL opens up a lot of possibilities, we can now utilize database specific features like time travel, create inline tables, do type-in SQL in the UI, emulate calculated dimensions, do cascaded filtering, and much more.

Accessing cloud databases directly with Direct Query

Improved reload landing tasks after critical failure

In addition to being able to reload individual tables it is now possible to reload the target for the entire Landing Task in the event of a critical failure, such as failure in reading/parsing a source database for Change Data Capture (CDC). Or if critical issues occur with log-based CDC like missing transaction/archive logs in a source database. Reloading the entire Landing Task will also automatically restart the CDC process, if enabled, and additional downstream storage tasks will correct the storage data on the next execution, ensuring changes are tracked for historical management (Type 2 data).

See also: Running a landing task with Change data capture (CDC) and Running a landing data task with Reload and compare.

New Direct Access gateway version

Direct Access gateway 1.6.2 resolves an issue that would sometimes cause the Connector Agent to crash when working in process isolation mode.

For upgrade instructions, see The upgrade procedure.