Qlik updates 2023

Qlik Cloud is developing at a rapid pace and Qlik releases updates with great regularity. Our consultants, who work with Qlik Cloud on a daily basis, have compiled an overview of the most interesting updates of late.

Roadmap 2023

But before we look at what's new, let's look ahead. In the coming year, Qlik is going to extend the Report service by making it possible to send Microsoft XLS-formatted reports. APIs will then receive XLS report templates and produce report output. This will be enabled by a so-called Add in O365 XLS.

In addition, it is planned to create HTML reports with Qlik's Report service and Qlik Application automation. A connector will also be added in automations, making it easy to add visualisations when creating an html report. Functionality will also be added whereby a report can be generated on demand using triggers on certain selections.

Below is an overview of the most relevant updates made by Qlik in recent weeks.

Automatic token refresh for connectors

Some Qlik cloud connectors now automatically renew the verification token before it expires. Previously, verification had to be renewed manually every 90 days when the token expired. Connections created before November 2022 must be renewed once to activate the auto-renew feature. The following connectors support auto-renewal of tokens:

Azure Storage
Office 365 SharePoint
OneDrive
Azure Storage Metadata
Microsoft Dynamics CRM
Office 365 SharePoint Metadata
Outlook 365

Diagramanimations

Diagram animations are the gradual transitions in a visualisation from the old view to the new view after data has changed, for example after a selection has been made. Animations can be enabled and disabled in the app settings.

Animations can be used in the following chart types:

Bar charts
Pie charts
Scatter plots
Funnel diagrams
Grid charts
Sankey charts

GeoOperations

GeoOperations now includes three analytical links with necessary functions to generate GeoOperations scripts. These allow you to simplify geospatial calculations.

Qlik GeoOperations. Load and transform your geographic data using various operations.
Qlik GeoOperations GeoJSON. Load Geo JSON files into your app.
Qlik GeoOperations Shapefile. Load shape files into your app.

The new design features are a very valuable addition for Qlik.

Stas van den Braber

Qlik Consultant

App review in Qlik Application Automation

This new template performs an assessment for a Qlik Sense app and returns various measurements about the app's performance.

Managing loading script history in the editor

A new panel has been added in the data loading editor. This allows app developers to save and pass different versions of the loading script. Checks between different versions are thus enabled.

Custom tooltips for KPIs

It is now possible to add tooltips to KPI. Previously, tooltips could not be added to objects without dimension.

Qlik Web Connectors available in Qlik Sense Enterprise Client Managed

The Qlik Web Connectors below are now available in Qlik Sense Enterprise on Windows without the need to install Qlik Web Connectors separately:

Facebook Insights
Google Calendar
Google Search Console
Outlook 365
Mailbox IMAP
Microsoft Dynamics CRM V2
OData, Qualtrics
SMTP
SurveyMonkey
YouTube Analytics

Performance improvement of the ODBC database connector

ODBC data sources have improved performance when working with larger data sets. All new connections automatically use the Bulklezer feature.

Instead of loading data row by row, Bulklezer works with larger amounts of data in the iterations within a load. This can result in faster load times for larger datasets. To activate this feature in existing connections, open the connection properties window by selecting Edit and then clicking Save. No other connection properties need to be changed.

PowerPoint output - Subscriptions and report service

Qlik Cloud reporting capabilities now support PowerPoint output for report compositions. Both subscriptions and Qlik Application Automation reports can be generated in PowerPoint. This means reports can be edited after generation.

Spreadsheets can now have custom background images and colours, so your PowerPoint reports will automatically have the house style. App developers now have more control over object placement and sheet grid size to support advanced formatting for presentations.

Contact

Let us inform you

Want to know more about Qlik and the latest updates? Get in touch with our specialist. We will be happy to inform you.

10 new Qlik Cloud features

Update