Securely access SAP data behind firewalls

Qlik Data Gateway – Direct Access 1.2.0 now supports SAP SQL and SAP BW connectors, providing an encrypted connection to Qlik Cloud. This lets Analytics apps securely access and analyze SAP SQL and SAP BW data that resides behind your organization’s firewall, without compromising network security. To benefit from SAP support, upgrade to Qlik Data Gateway – Direct Access 1.2.0 today.

Upgrading the Direct Access data gateway installation

Qlik Data Gateway – Direct Access overview

SAP NetWeaver

Troubleshoot app reloads with new error messages

Five new reload events have been added to app reload notifications. Previously, users would be notified when reloads:

• Succeed

• Fail

• Exceeded_limit

Now you will also be notified when:

• Fail: An engine connection error prevents a reload.

• Fail: An issue with session fetching causes a reload to fail.

• Fail: Engine openDoc issue leads to a reload failure.

• Fail: Reload fails due to permission issues.

Notifications will no longer be sent when apps are reloaded in the Data load editor and Data manager. This removes unnecessary notifications when app developers work on their apps.

Reloading app data

New chart functions for custom app navigation

The new chart functions ObjectId() and InObject() enable creation of guided applications with custom navigation functionality. For example, you can use the functions in conditional expressions to create colored buttons to navigate between sheets in an app.

The functions give access to the hierarchy of objects in a Qlik Sense app. ObjectId() will return the ID of the object in which the expression is evaluated. The function takes one optional string parameter, which can specify the type of the object you’re looking for. ObjectId(‘sheet’) will return the ID for the sheet of the expression. InObject(ID) is true when evaluated inside an object with the specified ID.

InObject – chart function

ObjectId – chart function

New template in Application Automation: Store a simple multi-page PowerPoint report to Microsoft SharePoint

This template will generate a report based on an app, including all public sheets with no selections applied. Each generated report will then be saved as a PowerPoint file in Microsoft SharePoint. You can modify this automation by selecting a different destination connector for the cloud storage in the “Copy File” block.

You can also choose to only include a selection of sheets by setting Sheets mode to Custom in the “Create Report” block and adding an “Add Sheet To Report” block (under Qlik Reporting).

How to create simple multi-page PowerPoint report and store them to Microsoft SharePoint using Qlik Application Automation

Updated tutorial for Qlik AutoML

The Qlik AutoML tutorial has been updated with guides for creating ML deployments, predictions, and prediction apps. The tutorial now teaches how to work with the output generated from an AutoML prediction, including building a data model and creating charts to visualize SHAP and prediction data.

Tutorial – Using Qlik AutoML to create a prediction app

Tutorial for performing time series decomposition in Qlik Sense

A tutorial has been added to walk you through the process of performing time series decomposition in Qlik Sense. The time series decomposition chart functions STL_Trend, STL_Seasonal, and STL_Residual make it easy to separate seasonal patterns from general trend data. This tutorial shows you how to use them in chart expressions.

Tutorial – Time series decomposition in Qlik Sense