Qlik April 2020 release

What’s new in Qlik Sense April 2020?

Visualizations and dashboards

This release brings many new visualization features and styling options to Qlik Sense, letting you create more advanced and customized analytics. We have added an organization chart (Org chart) to the visualization bundle, and you can now add a relative modifier to bar charts, combo charts, line charts, and tables. In addition, we have made improvements to tables, pivot tables, KPIs, maps, and custom tooltips, and we have enhanced app navigation.

Visualizations

Organization chart

We have enhanced our visualization bundle by adding a new chart to represent organizations. The org chart lets you create organization charts from data with a tree structure. You can navigate through the hierarchy by expanding and collapsing the tree.

Search in tables

In addition to the standard search by a URL link, you can now search by a link label in a table. There is also the option to disengage native scroll on touch to enable first column freeze.

Pivot table improvements

There are two improvements to pivot tables:

  • You can now save your pivot table layout state. This lets you store expanded or collapsed nodes as a bookmark. This improvement is ideal for sharing views of large pivot tables with many nodes.

    Creating a bookmark with an expanded pivot table

  • You can now sort by first measure. This sorting method precedes all other sorting. This lets you sort categories differently, for example, sorting category by sales rather than by name.

    Sort by first measure

Map chart improvements

We have made several enhancements to map layer properties. Now, you have number formatting options in the map chart for color and size by measure. We have increased the limit of items on point and area map layers to 50,000, and you can exclude the Qlik logo from the map chart.

Relative modifier (percentages)

The relative modifier provides you with a quick way to display the relative percentage of a measure, without having to write expression syntax. You can use it to see the impact of specific selections, relative to the selection, relative to the total, or relative to other fields. This is available as a setting is available in bar charts, combo charts, line charts, and tables.

Dashboards and applications

Tooltip customization

You can now choose to exclude default measures in tooltips. You can also hide all or part of the tooltips from a visualization.

Sheet trigger

This feature lets you add actions that are triggered when a user opens a sheet. With this feature, you can enable more sophisticated navigation functionality. Actions include setting selections, field states, bookmarks, and variables.

Global Navigation

Global navigation provides you with a new approach to top-level navigation through drop-down lists in the Qlik Sense client.

Themes and styling

KPI font layout

You have new options when choosing the layout behavior for fonts in KPIs. You can choose a fixed layout (same text size always), fluid layout (text size depends on box size), or responsive layout (adapts to the size of the box and the length of text).

Advanced authoring

App distribution into spaces

In a multi-cloud deployment, you have additional controls over content distribution policies. You can now send staged apps from a Qlik Sense Enterprise on Windows environment directly to a managed space in Qlik Sense Enterprise SaaS, for broader consumption across the organization. These apps are also refreshed in the managed space after they are reloaded in the Windows environment.

Publishing to cloud hubs

Share bookmarks

To improve collaboration, we have added a new way to share bookmarks in published apps. You can copy a link to a community bookmark, which can then be shared in other channels such as email or Slack.

Sharing links to bookmarks in cloud hubs

Secure Scheduled reloads

You can now run secure scheduled reloads through the QMC, which improves protection and governance around data access. This includes single sign-on support across multiple domains.

Service cluster: Impersonation

What's new in Qlik NPrinting April 2020?

In Qlik NPrinting April 2020, you’ll have the ability to create dynamic recipient email distributions! Support for Windows 2019 has been added as well. Please review the release notes for more information on the new features and fixes.

The April 2020 releases are now available on the Qlik download site. As with all software, please follow best practices when upgrading by backing up your Qlik Sense or Qlik NPrinting environment and testing the patch in a QA environment first. For Qlik Sense upgrades, please check out the Qlik Sense Upgrade Guide for helpful tips.

What's new in Qlik Data Integration April 2020?

We are excited to announce our first synchronized release of Qlik’s Data Integration Platform products – all branded under the Qlik Data Integration Platform. This release includes many new enhancements that continue to streamline the process of providing analytics-ready data for faster business insights.

To begin, we have released the former Attunity Product Suite Version 6.6, now labeled the Qlik Data Integration Platform April 2020 product release. Included in this release is:

Kicking off the updates ring, Qlik Enterprise Manager April 2020 (formerly Attunity Enterprise Manager – AEM version 6.6) introduces support for Windows Server 2019 – which delivers high-value options for our customers based on industry standards. Also, we have added the convenience of SAML Single Sign-On authentication, which has been tested with both OKTA and Azure AD.

Qlik Replicate April 2020 (formerly Attunity Replicate version 6.6) brings a host of new features sure to extend the value of your investment in Qlik’s Data Integration Platform (or bring new reasons to expand deployment). This release delivers different methods of authentication to support the matrix alignment with industry standards and customer demands, providing further confidence that their data is secure, which is critical in providing DataOps for analytics. Examples of this are new authentication types for Kafka and Confluent Cloud targets, and connectivity via a proxy and authentication via Azure AD account on Windows. Also, we have added updates to further support operating system source and target endpoint versions to align with industry and customer demand. Examples of these new endpoints are SQL Server 2019, Oracle 19 and PostgreSQL as well as version updates for AWS RDS Oracle and Cloudera.

We have also made significant enhancements to existing endpoints such as Snowflake, MS SQL, SAP HANA, Google Big Query, and mainframes. Beyond that, we added many new high demand endpoints, such as Databricks on AWS, Oracle Cloud Autonomous DW target, DB2 LUW pure Scale source, and AWS Aurora PostgreSQL source

Qlik Compose for Data Lakes April 2020 (formerly Attunity Compose for Data Lakes version 6.6) delivers new ease-of-use and streamlined processes for eliminating the need to validate the configuration design at every step, further accelerating the pipeline design and setup phase, while improving performance. This release also includes new and updated certifications for existing platforms including Databricks 6.3, Dataproc 1.4, and Amazon EMR 5.29. With the new certification for Amazon EMR, we now provide customers the flexibility to either use Hive Metastore or AWS Glue Data Catalog to store metadata. Finally, this release is also available on Windows Server 2019.

We don’t stop there, as Qlik Compose for Data Warehouses April 2020 (formerly Attunity Compose for Data Warehouses version 6.6) contains several new capabilities around CSV support and certified platforms. Now Qlik Compose for Data Warehouses can export/import mappings from CSV files which provides more flexibility, productivity, and usability when working on projects. For example, when applying bulk changes to a project, such as adding a new column to multiple tables, mappings can be imported from a file instead of being manually defined via the GUI. Also, we have added new version certifications for new data warehouse platform targets, such as Oracle 19, SQL Server 2019, and Azure Synapse. And finally, the Qlik Compose for Data Warehouses is now certified on Windows Server 2019.

The Qlik Data Catalyst April 2020 release includes new high-value capabilities including expanded interaction with the Qlik Analytics Platform. Qlik Data Catalyst already had the ability to onboard QVD files into its searchable catalog with the ability to profile and tag data elements within a QVD file. Now, Qlik Data Catalyst includes the ability to take any dataset and publish it as a new QVD file. This capability means that any Qlik Sense or QlikView customer now has an additional method to create QVD files. Also, supporting the recent announcement around Qlik’s Analytics Modernization Program, Qlik Data Catalyst can now migrate on-premise QVD files and other data files to the Qlik’ cloud environment. This can help QlikView customers accelerate their migration to the Qlik Sense Enterprise SaaS offering. This release also includes other enhancements like improved XML Processing, ADLS support, and table meter support for subscription compliance needs. These are significant advancements for bridging Qlik’s Data Integration Platform with Qlik’s Analytics offering, delivering high-value capabilities to help accelerate business value from raw data to important business insights.