Qlik Sense June 2020

The Qlik Sense June 2020 release contains a whole host of  exciting new features including mini charts within tables, a new bullet chart, further customisation of tables, tooltip enhancements and more.

Let’s  take a further look at each of the new features!

Sparkline...

More

The Qlik Sense June 2020 release contains a whole host of  exciting new features including mini charts within tables, a new bullet chart, further customisation of tables, tooltip enhancements and more.

Let’s  take a further look at each of the new features!

Sparkline Charts

Sparkline charts are specific to straight tables. When adding a measure into a straight table, you now have the option of measuring this measure by a second dimension and representing it as one of four mini charts/sparkline charts.

Sparkline charts can be added by:

  1. Changing the representation of a measure in the chart properties

 

  

  1. Selecting a dimension to measure by, such as Month.

  

  1. Selecting a “Type” from Bars, Dots, Sparkline or Positive/Negative (Whiskers.)

  

  1. You are done! There are further customisation options that can be used, such as setting the Y-Axis to Global or Local. Local only considers the value range for the specific row, whereas global considers the value range for all rows. Colours can also be adjusted to highlight min/max/first/last values, and the line/bar colour.

 

Bullet Chart

The Bullet Chart was previously available in the Visualisation Extension Bundle, this has now been rebuilt from the ground-up. The original version from the Visualisation Extension Bundle is still available; but will be deprecated in a future release.

The bullet chart is designed to present KPIs in the most informative way possible. In a Bullet Chart, only one measure is needed at a minimum to determine the length of the bar.

A dimension can be added, which will create a separate bullet for each dimension value. Targets and segments can also be added.

 

Table Customisation

In addition to being able to use mini charts within straight tables, there are two  new customisation options added to both the straight table, and pivot table in order to improve readability.

The first new customisation  is  the ability to highlight rows on hover, which is extremely helpful on large tables. It is also possible to change the font colour on hover.

This option can be enabled under Presentation -> Styling.

 

The second customisation is the ability to change the scroll bar size. There are 3 new options, small, medium and large. This option can also be found under Presentation -> Styling in the chart properties.

 

 

Organisation Chart Enhancements

It is now easier to use organisation charts, with new functionality such as a home button, border colour options, and auto-resizing. Previously you had to manually zoom in after making a selection.

   

Filter Pane Enhancements

When adding a new filter pane, text can be aligned to the left, right or center – Qlik users can also copy values to their local clipboard directly from the filter pane.

The alignment can be changed via the Dimensions menu in the chart properties pane.

 

 

Number Formatting in Colour By Expressions

It’s now possible to set a format pattern on a colour by expression, this is supported on the Bar, Pie, Line and Map charts. The option can be found under Appearance -> Presentation -> Colours & Legend.

 

  

Custom Tooltip Enhancements

In addition to the tooltip enhancements in previous releases, several  new functionalities have been added.

It’s now possible to display a title and description, use tooltips on line charts, use dynamic titles with expressions, and there are no longer any expression restrictions – leaving you free to use the ALL/TOTAL qualifiers which previously weren’t supported.

 

Dynamic Views & ODAG Improvements

Dynamic views now provide additional information when refreshed and are more performant in the June 2020 release of Qlik Sense. The scripting required for both dynamic views and ODAG has been vastly simplified to utilise minimal code for simple operations such as passing selections.

Read more here: Creating an on-demand template app

Qlik Sense Desktop Authentication Against SaaS

As free access to Qlik Sense Desktop expires on the 30th June 2020, now is the time to authenticate your copy against your QSEoW or SaaS instance of Qlik Sense. Previously it was only possible to authenticate against QSEoW (Qlik Sense Enterprise on Windows.) From the 10th June, it is now possible for all SaaS Qlik users to authenticate Qlik Sense Desktop.

Read more here: Authenticating against Qlik Sense Cloud

Qlik Management Console Improvements

Bookmark capabilities have now been added to Qlik Sense June 2020. This allows administrators to create bookmarks of various resources, such as apps, tasks, objects and streams. Clicking these directly from the QMC landing page will take you to the specific resource and apply the filters that are configured. By default, you’ll have the below bookmarks:

  • My Tasks
  • Everyone
  • Monitoring Apps
  • My Apps
  • My App Objects
  • My Streams

New bookmarks can be added as below:

  1. Navigate to the resource specific page, such as apps and filter the table down on any of the columns.
  2. In my example, I’ve filtered the list down to just show the “What’s new” app.
  3. Select the new bookmark icon at the top right, this will display any filters relevant to the current resource type and have an option to add a new filter.

 

 

  1. Add a name for your new filter, and optionally a description. Then select the + icon. 

 

  1. Once added, you’ll see the bookmark added to the relevant list.

 

Sheet View

The Edit button is now located to the right of the sheet navigation arrows and has changed design slightly.

Another useful feature that has been hidden away is the ability to double-click on any “grab handle” at the corner of objects. This will fill any available space.

 

Qlik Sense SaaS Improvements

Qlik’s SaaS offerings now have capability for larger applications, up to 10GB (on disk) and 50GB (in-memory.)

Qlik’s SaaS offerings also allow users to export stories to PDF, which was previously only available in QSEoW (Qlik Sense Enterprise on Windows.)

 

Upgrading to Qlik Sense June 2020

If you are a Catalyst Cloud customer, we will take care of your upgrade over the coming weeks. Please contact your Account Manager for further upgrade options.

 

More on this latest release…

What’s New Qlik Data Analytics – June 2020: https://www.youtube.com/watch?v=TznEzvXe_ik

Close

Qlik Sense April 2020

Over the past few releases, Qlik Sense has slowly been filling the feature gap between itself and QlikView. The brand-new feature-packed Qlik Sense April 2020 release is no different, with multiple fan-favourite QlikView features appearing in Qlik Sense.

Read on for a full rundown of the new...

More

Over the past few releases, Qlik Sense has slowly been filling the feature gap between itself and QlikView. The brand-new feature-packed Qlik Sense April 2020 release is no different, with multiple fan-favourite QlikView features appearing in Qlik Sense.

Read on for a full rundown of the new features.

 

Organisation Chart

The visualisation bundle was originally included with the Qlik Sense February 2019 release, and many of us will have become accustomed to using these additional objects within our dashboards during the last year. Qlik have been adding additional objects into this bundle since its initial release, and the latest addition is a good one.

The new Org Chart extension allows you to show cards in a hierarchy, such as a company hierarchy, or a product range. Clicking on the numbers below, each card allows you to expand/collapse the additional cards further down in the hierarchy.

 

 

Ability to Share Bookmarks

Previously, users could create their own bookmarks within a published application; but these remained private. The only way users could see the same bookmarks was if the Developer added the bookmarks before publishing the application. This made sharing insights particularly cumbersome, with long emails of “select this, select that.”

But that’s not all! It’s now also possible to save the sheet location, which will take the user to the sheet the bookmark was created on, and also save the layout, which will save the layout of a pivot table if edited.

 

 

Once your bookmark is created, you will see it under “My Bookmarks”. You can right click on this bookmark and click “Publish.” This will allow all users of the application to see your bookmark. You can also copy the link and send this to another user directly.

 

 

Relative Modifier

The Qlik Sense February 2020 release brought us new modifiers for certain chart types. The Qlik Sense April 2020 release provides us with yet another new modifier, the relative modifier. This allows Qlik Users to quickly create a measure showing the percentage or share of a total.

The relative modifier is currently available for the Bar, Combo, Line and Table charts.

 

 

Sheet Triggers

Sheet triggers are one of the most requested features to be migrated from QlikView into Qlik Sense. For users unfamiliar with QlikView, sheet triggers allow you to add actions that are applied when a user navigates onto a specific sheet.

For example, a bookmark, variable, or selections may need to be set if a user navigates onto a specific sheet. The addition of sheet triggers into Qlik Sense drastically improves its guided analytics capability.

Within the sheet properties menu, while in edit mode, a new tab has been added to the accordion menu named “Actions.” Under this tab, you will see a wide array of actions such as applying a bookmark, setting a variable, clearing selections, setting values in a field and locking selections.

 

 

Pivot Improvements

The Pivot Table also has a selection of new improvements included within the April 2020 release.

The first is that it’s now possible to store the pivot table layout within a bookmark, this means that when the bookmark is applied, the current pivot table layout will change to the layout that was active when the bookmark was initially created. This helps avoid confusion if the pivot table is arranged differently across users.

The second improvement is a new sorting option. The pivot chart, by default, is sorted by dimensions. It is now possible to sort by the first measure, if this option is enabled, this will precede any other sorting options applied.

 

 

Table Improvements

As with the pivot table, there are two new improvements to the straight table chart in the Qlik Sense April 2020 release.

The first improvement is being able to search by label when using URLs within a table. Previously, you could change the representation of a URL to display the field (such as the Sales Order ID), but when trying to filter by these values, they would appear as URLs.

Now it is possible to choose whether to show the actual field value (the raw link), or the label.

 

The second improvement is the ability to freeze columns in a straight table. This is useful when using Qlik on a smaller device such as a phone, where you need to scroll across the table to view all field values. The ability to now freeze dimension columns makes viewing the data much easier.

 

KPI Improvements

There are new layout behaviours for KPI charts included within the April 2020 release. These help standardise font and measure sizes across multiple KPIs.

  • Fixed – This is a new addition, where the front will always be the same size, regardless of changes across number formatting or the size of the KPI chart
  • Fluid – This is also a new addition, where the font size depends on the size of the KPI. Make sure KPIs are the same size to ensure the same font size is used
  • Responsive – This is the default behaviour in older versions of Qlik Sense, where the font size depends on both the box size, and the length of the text

 

 

Chart Improvements

A selection of smaller chart improvements have also been rolled into the Qlik Sense April 2020 release. These include:

  • Number formatting of any “colour by” and “size by” measures in the map chart
  • Limit of items on point and area layers increased to 50,000
  • Exclude the Qlik logo on the map chart
  • Hide basic rows in custom tooltip, if disabled measures on the chart will be included in the tooltip, as well as any measures added against the tooltip. Enabling “hide basic rows” will remove the measures added to the chart, and only display measures added against the tooltip.

 

 

Dynamic Views

Dynamic Views are now also present in Qlik Sense Enterprise on Windows (Previously only available in cloud versions of Qlik Sense).

Dynamic views allow users to query and view subsets of big data sets in charts that can be dynamically refreshed as the user interacts with the app. This enables visualisations to stay up-to-date within fast-changing datasets, or datasets with large volumes.

To use dynamic views, you need to connect a base app to another app. Master visualisations from the app can then be used within the base app. This allows developers to use master visualisations from the template app as dynamic charts across multiple applications. There is no limit of dynamic views that can be added to a base application.

 

More on this latest release…

Close

NPGeoMap Version 3.1 Now Available

Multi-layer architecture, customisation features and more

NPGeoMap brings the power of geospatial analytics to your Qlik solutions.

This month saw its newest release, which incorporates several oft-requested features and a few other...

More

Multi-layer architecture, customisation features and more

NPGeoMap brings the power of geospatial analytics to your Qlik solutions.

This month saw its newest release, which incorporates several oft-requested features and a few other innovations. These include:

New multi-layer architecture

• Many new, highly customisable features

• Print and export maps, with headlines in any format

• Unlimited number of layers, which are easy to install

• High performance and flexibility

• Many boundary maps and coordinates

• Optimised for web, local and mobile clients

• Version for QlikView and Qlik Sense

• Unbeatable cost benefit ratio

• Free 30-day trial version available

Click here for an overview of NPGeoMap or contact us for more information.

Close