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

Qlik Sense November 2019

 

The November Qlik Sense is packed full of new enhancements. Expanded cloud connectivity,...

More

 

The November Qlik Sense is packed full of new enhancements. Expanded cloud connectivity, SOC 2 Type 2 certification and mobile offline support for Android. On top of that are the exciting new visualisation capabilities.

Mekko charts are now incorporated, giving a great new option to capture all aspects of a given measure. Additionally, there is now an accumulation option to help see progress across a dimension and a whole suite of new table styling options giving even more flexibility over look and feel. 

More details on all the new features can be found here.

Close

Alerting for Qlik Sense - New partnership with RoxAI

We are excited to announce our new partnership with RoxAI. RoxAI leverage smart technologies like AI, machine learning, natural language processing and blockchain to help organisations increase productivity. This makes them a perfect fit for our mission to help customers achieve...

More

We are excited to announce our new partnership with RoxAI. RoxAI leverage smart technologies like AI, machine learning, natural language processing and blockchain to help organisations increase productivity. This makes them a perfect fit for our mission to help customers achieve more with their data.

We are particularly enthusiastic about RoxAI product Ping, which offers Enterprise Alerting for Qlik Sense. With Ping, QlickiT are able to provide you with a new way to leverage the power of Qlik Sense. Now, you can experience an analytics dashboard that is always working; telling you the data changes that are most important to you as they change and straight to any device.   

Its seamless integration into Qlik Sense makes it an exciting new way to leverage the power of your data and we are thrilled to be joining RoxAI for this journey. Read more about Ping and how it can enhance your Qlik Sense solution with Enterprise Alerting here.

Close

New Qlik Sense version - Feb 2019

Greater mobile support. Advanced visualisations. Fast exploration of large data sets. Enhanced admin control. Increased security. The latest version of Qlik Sense is a big one!

This five minute video is a good overview of the main details: 

For those wanting a little more detail, this blog post has a great summary and for the truly information hungry amongst you, Qlik run a quarterly Qlik Insider Webinar where the new Qlik Sense release will be a hot topic. Register for that here. 

For more details on this release register for the Qlik Insider Webinar here.

Close

Qlik Sense November 2018 Now Available

Cognitive machine learning, light authoring, comparative analysis

 November sees some big new features for Qlik Sense!

The insight advisor keeps getting better and better, offering smarter, more relevant and contextual suggestions...

More

Cognitive machine learning, light authoring, comparative analysis

 November sees some big new features for Qlik Sense!

The insight advisor keeps getting better and better, offering smarter, more relevant and contextual suggestions owing to Qlik's cognitive machine learning capability. This makes it even easier for those who are not experts in data to benefit from the power of Qlik's analytics.

Supporting this is the light authoring amendment to Insight Advisor, giving users flexible suggestions on the types of visualisations best suited to their data.

Comparative analysis, allowing side-by-side analysis of alternate states is a much requested feature that we are delighted to see included in this release.

Those are just some of the improvements, this video will give you a more comprehensive view. Enjoy!

Read a more detailed analysis of the new additions here or try them yourself, with a free Qlik Sense Desktop download.

Close

Qlik Sense September 2018 Now Available

Augmented Intelligence, Advanced Authoring and more

 September saw another comprehensive update for Qlik Sense.

The June update brought us exciting AI innovation, with the addition of the new insight advisor.

This time,...

More

Augmented Intelligence, Advanced Authoring and more

 September saw another comprehensive update for Qlik Sense.

The June update brought us exciting AI innovation, with the addition of the new insight advisor.

This time, the AI theme expands and is accompanied by greater levels of customisation and control, across various user types and design elements.

Read a more detailed analysis of the new additions here or try them yourself, with a free Qlik Sense Desktop download.

Close