What's new in Qlik Sense February 2022
This section provides Qlik Sense business users, analytic creators, and data integrators a summary of the features and improvements available in Qlik Sense Enterprise on Windows.
Qlik Sense administrators should review the What’s New section in the Qlik Sense for Administrators documentation set.
Qlik Sense developers should review the What’s New section in the Qlik Sense for Developers documentation set.
Augmented analytics
Period over period dashboards in Insight Advisor
Insight Advisor now returns more robust period over period analyses in the form of entire dashboards, when users select or search for applicable fields. Instead of a simple chart, you get one or more charts and KPIs, along with a filter pane, allowing you to make selections and further explore comparative performance.
Insight Advisor supports dollar-sign expansion
Insight Advisor can now recognize expressions contained in variables and use them when generating analytics. This allows users who manage expressions in variables to generate more relevant insights.
Business logic fine grain controls in Insight Advisor
Business logic allows you to define the default grain for a calendar period, such as a yearly, quarterly or monthly basis. When you create behaviors such as default calendar periods, you can now specify whether to use or ignore the grain for a particular analysis, providing more advanced fine grain controls.
New business logic options for customization in Insight Advisor
New parameters have been added to business logic that help refine the analysis generated by Insight Advisor. Options include setting trend direction and sort order for a measure, specifying favorite types of analyses to be used by the system, and specifying the overall aggregation type for complex expressions.
-
Favorable trends: Sets whether the desired trend for a measure is to increase or decrease.
-
Favorite: Identifies a measure of interest for Insight Advisor so that Insight Advisor will use the measure more often when generating visualizations without user queries or selections.
-
Overall aggregation: Helps Insight Advisor determine which aggregation to use for queries that involve master measures with complex expressions where the aggregation is not clear from the outset.
Visualizations and dashboards
Improvements to the grid chart
Improvements to the grid chart now let you show labels for each data point in the chart. Labels identify the value of the measure for the data point. In preparation for the deprecation of the Heatmap extension in this release, the grid chart now includes two layouts, Standard and the new Heatmap option. The heatmap layout adds the functionality of a heatmap chart to the grid chart. As of this release, the Heatmap chart extension will no longer be supported.
Improvements to managing variables
A top request through Ideation, the updated, flexible Variables dialog simplifies the management of chart variables. Displaying all variable elements, including name, description, value, and tags, it allows you to add, search, and duplicate variables. You can even delete multiple (up to 20) variables simultaneously. These capabilities alleviate manual work and help teams work more efficiently.
Connectors
Qlik Sense connector for Google Drive
Qlik Sense connector for Google Drive is included with Qlik Sense Enterprise Client-Managed. Now you can access data stored in Google Drive and load it directly into your Qlik Sense app.
Google Drive and Spreadsheets connector
The Qlik connector for Google Drive and Spreadsheets Metadata is now included with Qlik Sense Enterprise Client-Managed.
Snowflake connectivity enhancements
The Snowflake connector now supports the use of key pair authentication to allow you to use enhanced security measures when accessing Snowflake from Qlik Sense.
Support for AWS IAM credentials authorization with Amazon Redshift
New authentication support with the Amazon Redshift connector allows you to use AWS Identity and Access Management (IAM) credentials authorization. This will allow organizations to assign role-based access privileges in addition to designating access rights individually.
Data and platform
Formatted export to Excel
Formatting options are now supported when exporting straight tables to Excel. Exported tables now include totals and styling as they appear in Qlik Sense.
Add self-service task management
Users with the appropriate permissions can now easily start, stop, and view reload tasks in the hub.
Documentation improvements and additions
Scripting help improvements
Set expressions tutorial
Learn how to build set expressions for set analysis.
Chart expressions and load scripts
Many new examples of functions used in chart expressions and load scripts.