News Since Qlik Sense 1.0
News Since Qlik Sense 1.0
News Since Qlik Sense 1.0
0
Qlik Sense®
June 2019
Copyright © 1993-2019 QlikTech International AB. All rights reserved.
HELP.QLIK.COM
© 2019 QlikTech International AB. All rights reserved. Qlik®, Qlik Sense®, QlikView®, QlikTech®, Qlik Cloud®, Qlik
DataMarket®, Qlik Analytics Platform®, Qlik NPrinting ®, Qlik Connectors®, Qlik GeoAnalytics®, Qlik Core®,
Associative Difference®, Lead with Data ™, Qlik Data Catalyst™, Qlik Associative Big Data Index™ and the QlikTech
logos are trademarks of QlikTech International AB that have been registered in one or more countries. Other
marks and logos mentioned herein are trademarks or registered trademarks of their respective owners.
Contents
1 What’s new in Qlik Sense June 2019? 9
1.1 Advanced Authoring 9
Copy value to clipboard 9
Grid layout on mobile devices 9
Native container object 9
1.2 Visualizations and Mapping 9
New charts for the Visualization Bundle 9
Improved bar chart 9
Exploration menu for maps 10
1.3 Qlik Sense Mobile 10
Push notifications to Qlik Sense Mobile 10
1.4 Multi-Cloud 10
1.5 Qlik Connectors 10
1 What’s new in Qlik Sense April 2019? 11
1.6 Augmented Intelligence 11
Associative insights 11
1.7 Visualizations and Mapping 11
Maps enhancements 11
Visualization Bundle 11
1.8 Multi-Cloud 11
1.9 Qlik Sense Mobile 12
Qlik Sense Mobile for BlackBerry 12
1.10 Qlik Connectors 13
1 What’s new in Qlik Sense February 2019? 14
1.11 Usability Improvements 14
Single page application flow 14
1.12 Advanced Authoring 14
Dollar-sign expansion preview 14
1.13 Visualizations and Mapping 14
Visualization Bundle 14
Dashboard Bundle 14
Support for WMS in map background layers 15
1.14 Qlik Sense Mobile 15
1.15 Qlik Connectors 15
Integrated Single Sign On Support (SSO) 15
1 What’s new in Qlik Sense November 2018? 16
1.1 Advancements to Augmented intelligence 16
Precedent based learning 16
Insight advisor light authoring 16
1.2 New advanced authoring features 16
Alternate states 16
Exposed set analysis 16
Set expression improvements 16
With the release of the native container object, current applications using the existing extension objects will
continue to work as before but the two Container Object extensions available in the Dashboard bundle will no
longer be listed as new object options for applications.
System notifications and System notification policies features are available only on Qlik Sense Enterprise on
Windows installations licensed with a signed key
1.4 Multi-Cloud
The following capabilities are now available for Qlik Sense Enterprise on Cloud Services(SaaS) and Qlik Sense
Enterprise on Kubernetes deployments:
Associative insights helps users discover and understand the significance of values in the data that are not
selected. Look for Associative insights in the selections tool.
Maps enhancements
It is now possible to set a default map background for all new map charts. Enabling further customization of
backgrounds, now users can choose to set their own predefined background instead of using the Qlik standard
background. This feature provides better support for handling geographic considerations such as disputed
regions with politically sensitive boundaries.
In addition, you will find the following feature enhancements for mapping:
l The ability to include new lines in labels, with an improved look of labels in background maps (also
added to Qlik GeoAnalytics).
l New size legends for map point layers.
l The capability to insert images in map background layers. This is suitable for simple images such
drawings, floor plans, etc.
Visualization Bundle
Two new charts in the visualization bundle
l Bar & Area chart: a bar chart with transition effects, connectors and labels on tacked bars.
l Bullet chart: a bar chart ideally used for tracking towards a goal, showing target, or actual and bands
for good/bad/average.
1.8 Multi-Cloud
With Qlik Sense April 2019 we have introduced a standalone SaaS deployment option for Qlik Sense Enterprise
(QSE), with the ability to create, reload, and consume Qlik Sense apps entirely on Qlik’s hosted cloud. This
release also enables parity between Qlik Sense Enterprise on Windows and Qlik Sense Enterprise on Kubernetes
The following capabilities are now available for Qlik Sense Enterprise deployed on Qlik Cloud Services (SaaS)
and Kubernetes:
l Create apps
l Connect to data sources
l Store/Use QVDs / Files
l Schedule app reloads
l Team Co-development of apps
l Personal and shared spaces
l Role-based access control
l Share sheets/bookmarks
Granting access to sheets, bookmarks, and stories
l Upload / export apps
l Console for management
Management console
l License integration
l Bundled extensions
l Custom extensions (only on Qlik Sense Enterprise on Kubernetes)
l Mashups (only on Qlik Sense Enterprise on Kubernetes)
l ODAG
l API (reload only)
l Usage auditing
Events
l Link to QlikView documents (available both in Qlik Cloud Services and Qlik Sense Enterprise on
Kubernetes)
Targets.WebHelpOnly">Expression editor
Dashboard Bundle
One extension added to the existing bundle:
l Share button: creates sharable app links with current sheet and selection.
Maps
the Qlik offering, Qlik will maintain and ensure the quality and performance of these objects upon version
upgrades. These extension objects are fully functional, but do not maintain other product standards such as
accessibility, multi-language, and RTL.
l Date range picker: allows users to quickly and easily select dates and ranges.
l Navigation button: lets users quickly navigate to sheets, stories, and websites. Can also trigger actions like
selections and set variables.
l On-Demand reporting: generation of Qlik NPrinting reports is now possible from inside apps.
l Tabbed container: ability to switch between visualizations with tabs.
l Show/hide container: similar to tabbed containers, but now with show conditions.
l Variable input: users can set values with buttons, drop-downs, sliders, and input boxes.
Dashboard bundle
This feature is currently available only in Qlik Cloud Services and Qlik Sense Enterprise for elastic deployments.
Multi-Cloud Developments
Qlik’s multi-cloud offering now offers simplified configuration options using self-signed JSON Web Tokens
(JWTs). This means components can be connected without requiring specific features of an IdP. In addition, Qlik
Cloud Services can now integrate with ADFS as the identify providers allowing customers with Active Directory
infrastructure to authenticate their users.
1.6 Accessibility
Accessible list boxes, keyboard navigation, and screen reader capabilities for list box access.
App customization
App developers can disable responsive layout for sheets and set a custom size in pixels. Your dashboard will be
presented to users exactly as you create it. This feature is not supported in mobile device mode.
Map improvements
l Adaptive pixel zoom and pan to optimize performance when browsing dense maps.
l Default colors for added layers. Each new layer has an independent color picked from palette.
l KML files with geographic line data can now be loaded and rendered.
l Field labels for size and width make legends and pop-ups easier to read.
2.4 Management
Improvements to back end work flow
Multiple apps can be moved between streams in the QMC. This builds on the functionality released in the Qlik
Sense Enterprise April 2018, where single apps could be moved between streams.
Open source front end framework upgraded to version 1.6.9, which provides better stability and compatibility.
2.5 Mobile
Access to Qlik Sense Enterprise is now supported in AirWatch EMM (Enterprise Mobile Management)
environments using the Safari, Chrome or VMware browser.
l Native connectivity added to MS Azure QSL DB, with tested and supported integration.
l The JIRA connector is released to GA from beta.
JIRA
l Enhanced security for LDAP authentication, which is built into the Qlik ODBC Connector. This improves
customer experience and time to value, with industry recognized encryption and authentication
standards.
Accelerated self-service
l Alternative chart suggestions: Qlik Cognitive engine now provides a number of alternative charts in the
property panel to complement the initial recommendation.
l Switch dimensions and measures: you can now switch dimensions and measures in the property panel
with a simple drag and drop.
l You can now quickly change between common aggregation methods using a drop-down menu in the
property panel.
Advanced authoring
l Qlik Sense sheets can now be extended vertically to a scrollable mode.
l Grid size can now be changed in sheets with existing objects.
l Fields: create statistical aggregation functions based on field data. Two check boxes allow you to
independently insert Distinct and Total clauses in statistical aggregation functions.
l Functions: use this control to enter general Qlik Sense functions into an expression.
l Variables: use this control to insert variables into an expression. When a variable is selected, a preview of
its definition and value appears.
l You can now show and hide specific columns in a straight table using expression conditions.
l The mini graph used for scrolling can now be turned off for line charts, bar charts, and combo charts.
l You can now republish an app that you have already published, from the hub. Create a duplicate of your
published app first, make your changes, and then republish it back to the same stream as the published
app. The stream will be automatically selected from the system based on the app name.
l A new dedicated section for published apps has been added to the hub. Within this section you can still
create an app duplicate and then use the new Republishing an app from the hub capability to publish
your changes back to your users.
l The app owner can now approve community sheets of a published app and add them to the list of base
sheets. The app owner can also decide to unapprove base sheets to the Community section.
Accessibility
To further improve Qlik Sense accessibility, the following features have been implemented:
l Users can now navigate and interact with the help site using keyboard keys and shortcuts.
l UI elements, text, search on, and images support zooming, resizing and screen magnifiers.
l Text, icons and images are compliant with accessibility standards for contrast and readability.
For an appropriate license and detailed information, please contact your Qlik representative or Qlik Support.
3.3 Mobile
Support for BlackBerry Access browser.
With Qlik SenseJune 2018, you can now access Qlik Sense and consume apps from a mobile device that uses a
BlackBerry Access browser. A BlackBerry Dynamics deployment must be set up by an administrator for your
users. For information about how to set up and use BlackBerry Access to connect to Qlik Sense, see the support
article Connecting to Qlik Sense using BlackBerry Access.
l Presto: the PrestoDB Connector enables you to create connections that query all the data sources in an
environment that have been configured with Presto.
l Apache Drill: the Apache Drill Connector provides access to non-relational data stores.
l Apache Phoenix: the Apache Phoenix Connector provides access to relational data stores.
l Apache Spark: the Apache Spark Connector is used for direct SQL and HiveQL access to Apache
Hadoop/Spark distributions.
l MongoDB: the MongoDB Connector gives access to MongoDB, which is a NoSQL database program.
l Grid size of an app sheet can now be customized with three different sizes: small, medium or large.
l You can now set custom abbreviations in the load script. For example, you can choose to use Billions
instead of G.
l When clicking the Edit button of a linked visualization, a new shortcut redirects you to editing the Master
visualization item.
l New keyboard shortcuts for selection back/forward have been added.
original presentation. As a result, user experience is improved and context is provided when interacting with the
app.
4.2 Deploy
Deployment improvement
From Qlik Sense April 2018 it is no longer necessary to use port 4244 as the authentication port. If you are using
SSL to protect your environment, you can use port 443 as an external facing port for the Qlik Sense Proxy service
(QPS).
4.3 Administer
Allocations for new license types
Customers who have purchased Qlik Sense with support for the new Professional and Analyzer license types can
now configure the allocation of these licenses in the QMC.
Load
Styling an app
l Oracle
Oracle
l PostgreSQL
PostgreSQL
Configuring single sign (SSO) with Microsoft SQL Server (MS SQL Server)
You can download the new Qlik Sense Mobile app to your supported iOS device, and then connect to a Qlik Sense
Enterprise server. You can download Qlik Sense apps, and then view those apps when you are not connected to a
server.
Centralized logging
With the introduction of shared persistence, all nodes now have direct access to a common database and file
system. The Qlik Logging Service centralizes the logging by collecting all the messages and inserting them into a
PostgreSQL database. This feature is optional but is enabled by default.
New visualizations
You can now use these additional chart types to visualize distribution and range of your data.
The box plot is suitable for comparing range and distribution for groups of numerical data. Data is visualized
by a box with whiskers, and a center line in the middle.
The distribution plot is suitable for comparing range and distribution for groups of numerical data. Data is
plotted as value points along an axis.
The histogram is suitable for visualizing distribution of numerical data over a continuous interval, or a
certain time period. The data is divided into bins.
The Summary card enables you to view a summary of data in a table's field. In addition, the Summary card
enables you to view different possible data interpretations, such as viewing the field's data as a dimension or
measure, enabling different potential transformation options.
The Replace card enables you to select one or more values from a field and replace them with another value.
The Set nulls card enables you to select values from a table field and then manually set them as null.
The Order card enables you to apply a custom order to values in a dimension field.
The Split card enables you to split content from a field into multiple fields.
The Bucket card enables the grouping of measure field data into ranges, creating a new field with the specified
groupings.
You can also now assign individual colors to a dimension's values, ensuring that individual values are colored
consistently across visualizations when coloring by dimension.
8.2 Administer
Single sign-on to Cloudera Impala
You can now set up SSO connections to Cloudera Impala.
You set up single sign-on by establishing a trusted connection to Cloudera Impala, and then setting the ODBC
connection to use the Qlik Sense credentials.
Analytic connections
With the analytic connections you can configure a server side extension to extend the Qlik Sense expression
library and support calls to third-party engines.
8.3 History
This PDF contains all the news and updates since the first release of Qlik Sense.
9.2 Deploy
Shared persistence
You can now deploy a multi-node site with shared persistence. This means that nodes share a single repository
database and a single network folder for the application files. You can either share the central node repository,
or set up a high availability database cluster as the repository database. This allows for higher volumes of
changes, such as reloads, and removes delays caused by synchronization.
9.3 Administer
Desktop authentication
Qlik Sense Desktop users can now authenticate against their Qlik Sense Enterprise server. The Qlik Sense
Enterprise administrator configures an authentication link in the Qlik Management Console, and distributes it to
users.
QlikView converter
The QlikView converter simplifies the work associated with converting elements from a QlikView document into
master items in a Qlik Sense app. Visualizations, expressions, dimensions, and variables can be selected for
conversion. The tool is available from the Dev Hub.
Scroll alignment
You can now set the position of the chart scroll bar to start at the end of the data.
Navigation
You can now choose to show or hide the navigation menu in the hub.
10.2 Administer
Qlik Management Console
The QMC now has an engine setting: Create search index during reload, which improves the first search
experience for a user.
l The Qlik REST Connector 1.1 enables Qlik Sense to efficiently load data into a Qlik Sense app from a REST
data source. The QlikREST Connector is a generic connector. That is, it is not tailored to a specific REST
data source.
l The Qlik Salesforce Connector 14.0 enables Qlik Sense to efficiently load data into a Qlik Sense app from
a Salesforce.com data set. Salesforce.com data is available to users with a Salesforce.com account and
current access credentials.
l The Qlik database connectors in the ODBC Connectors Package 1.1 enable Qlik Sense to efficiently load
data into a Qlik Sense app from databases accessed through supported ODBC (Open Database
Connectivity) drivers. When using one of the database connectors in the Qlik ODBC Connectors Package,
you do not need to create a DSN connection before connecting to the ODBC database.
You set up single sign-on by establishing a trusted connection to SAP HANA, and then setting the
ODBC connection to use the Qlik Sense credentials.
When data is loaded from a Qlik DataMarket data set, it is allocated to multiple individual tables. These tables
are associated by generated key fields. Measures and time periods from the data set are consolidated in one
table that is assigned the name of the data set. Dimension fields are allocated to individual tables.
Publishing apps
You can now publish your apps from Qlik Sense. In previous versions, you could only publish of apps from the
Qlik Management Console.
Publishing an app
Apps now support bidirectional reading order, for languages such as Arabic and Hebrew.
App styling
You can now apply styling to your app to customize the app based on your company standards.
Time-aware charts
You can now use a continuous scale on the x-axis in a line chart to get a accurate view of time-based data.
Qlik NPrinting reports can now be distributed to the Qlik Sense hub.
Additional changes
Geopoints, which you use in map visualizations, can be created automatically from latitude and longitude data.
You can now open a dialog with user information from the hub.
You can add and attach multiple data files to your app in one go, using drag and drop.
11.2 Deploy
IPv6
Qlik Sense now supports IPv6.
11.3 Administer
Monitoring apps in QMC updated
The Monitoring apps now include alternative dimensions and measures for increased customization.
The Operations Monitor app includes basic metadata about users, tasks, apps, and app objects.
The License Monitor app reports token usage compared with allocated and available tokens and shows token
usage by stream in addition to app. Basic metadata about users and apps is also available in the app.
Qlik DataMarket
New DataMarket packages are available for global weather, currencies, and stock markets.
l Licensed and free data sets are separated into clearly marked categories.
l Hierarchical data sets are structured to facilitate selection.
Data storytelling
Data storytelling has been improved.
l You can now take a snapshot of a visualization when you hover over the visualization.
l You can now choose to create an annotation when you take a snapshot of a visualization. The
annotation is displayed in the snapshot library and helps you to distinguish between your snapshots.
l When you add a snapshot to a story slide, the snapshot now snaps to grid.
l When you play a story, a tool tip now appears when you hover over data points.
12.2 Deploy
Qlik Sense Proxy Service metrics
A new metric, PrintingLoadBalancingDecisions, is available for the Qlik Sense Proxy Service (QPS).
Cloning sites
The Qlik Deployment Console (QDC) can be used to clone entire Qlik Sense sites.
12.3 Administer
New license option
The capacity-based license gives you the flexibility to configure the number of cores to use on a CPU.
Attach data files You can now upload and attach data files to an app on a server.
Variables overview You can now get an overview of all the variables in an unpublished app, and
create, edit, and delete variables.
Media library You can view all images in an app, and upload new images.
Visual exploration You can now edit some visualization properties through the new
exploration menu.
Editable range selection It is now possible to input exact values and do more precise selections.
Repository Snapshot The Repository Snapshot Manager (RSM) can be used to automate the
Manager backup and restore procedures.
13.1 Create
Managing data
Attach data files
You can now upload data files to an app on a server. The file is attached to the app, and you can load and select
data to use in the app.
Managing images
Media library
You can now find all the images you can use in the app in the media library.
Upload image
You can now upload images to the media library.
13.2 Discover
Interacting with visualizations
Visual exploration
The new exploration menu makes it possible to change some properties while analyzing. The menu is accessible
when viewing a visualization in full-screen mode. It is available for line chart, bar chart, pie chart, and scatter
plot. It is a simplified version of the properties panel, with the purpose of making data exploration faster and
more easily accessible.
13.3 Collaborate
Data storytelling
Exporting a story
A story can be exported as a PowerPoint presentation.
13.4 Deploy
Planning Qlik Sense deployments
Backing up and restoring a site
The Repository Snapshot Manager (RSM) can be used to automate the backup and restore procedures.
13.5 Administer
Monitoring a Qlik Sense site
l The Monitoring apps now handle incomplete or malformed logs without failing during reload.
l The Monitoring apps now generate simple logs for tracking their own reload history.
l The QMC change history contains a more complete and detailed list of changes tracked by the
Monitoring apps.
l The Operations Monitor ’s Errors and Warnings table is updated to allow more timely access to other log
entries associated with an error or warning.
l The Operations Monitor reports aborted reload tasks as well as successful and failed reloads.
l The Operations Monitor library includes two new heat map visualizations that can be used on customized
sheets for performance monitoring.
Qlik DataMarket The DataMarket service enables you to add data from external sources
from directly within Qlik Sense. Data from a wide range of frequently-
updated sources is available.
Data manager A new tool for smart loading of data. The data manager uses a new, visual
data profiling and modeling capability to make it easier to integrate data
from multiple sources without the need to learn a scripting language.
App creation and Enhancements and improvements to visualizations include: improved map
visualization functionality and map data usage; smoother use of dimensions in pivot
enhancements tables; calculation conditions can be added to most visualizations; scatter
plots can use compressed data; various user interface enhancements.
Export You can export and print visualizations and sheets as images or to PDF.
Qlik DataMarket
You can now add data from external sources with Qlik DataMarket. Qlik DataMarket offers an extensive
collection of up-to-date and ready-to-use data from external sources accessible directly within Qlik Sense. Qlik
DataMarket provides current and historical weather and demographic data, currency exchange rates, as well as
economic and societal data.
Calculation condition
You can add a calculation condition to most objects (not Filter pane or Text & image). A calculation condition
is set as an expression in the properties panel. The object is calculated only when the expression is fulfilled.
l The setting for conditional colors in KPI objects has been improved and now also updates in real time.
l The gauge visualization now has an arrow indicator for values that are outside of the defined range.
l Column content in table visualizations can now be aligned left, right, or automatically. You can change
the setting in the properties panel.
l Improved functionality when making selections in range legends.
l Styling updates to tables and pivot tables.
l You can now convert KPI objects to/from other object types.
Managing apps
Duplicate apps
You can now duplicate any app you have access to on the hub. You can then work on your own copy, without
changing the original, for example.
Delete apps
You can now delete any unpublished app from the hub.
Exporting a visualization
You can export a visualization as an image or to a PDF file.
Port added
Port 4239 has been added.
Modifying
The Rim node type can be switched to another type: Proxy, Engine, or Scheduler. Individual features can no
longer be added or removed.
Uninstalling
Options have been added so you can remove all data and certificates during Qlik Sense uninstallation.
Updating
An update option is now available when Qlik Sense has been previously installed and a service release (version
x.x.x) of the software is available to update the installation. A service release primarily includes software updates
and fixes which are then applied to the existing version. Updates are installed without the need to remove earlier
updates or the baseline program itself.
Uninstalling an update
Updates can also be uninstalled, in which case the updated version will be reverted back to either the previous
service release version or major release version of Qlik Sense, whichever is applicable.
Platform support
The Microsoft Windows Server 2012 R2 platform is now supported for the Qlik Deployment Console (QDC).
Firewall rule
A firewall rule, WINRM, has been added in the Security group rules for the Amazon Web Service (AWS) plug-in.
Timeout setting
A timeout setting, Time to wait for a free machine, has been added. The setting is used when the VMware
vSphere plug-in is used with a machine pool.
Search
You can now perform searches in almost all tables in the QMC. Search criteria can be arranged into subgroups
and combined with column filtering.
Operations Monitor
The Operations Monitor provides a more comprehensive and comprehensible view of reload tasks, user sessions
and app usage. New Key Performance Indicators (KPI) make it easy to identify conditions and trends. New sheets
and links between sheets make it easier to navigate and locate relevant data.
KPI
You use the KPI to track performance. The KPI shows a main value, and, optionally, a complementary value.
Sheet thumbnails
You can change the thumbnail for a sheet to make it easier to find in the app overview.
Snapshots of maps
You can now take snapshots of maps.
Story thumbnails
You can change the thumbnail for a story to make it easier to find it in the app overview.
The libraries also include additional chart visualizations that can be added to custom sheets.