Blogs

Qlik Academic Program boosting employment prospects

The Qlik Academic Program offers world class data analytics training, software, qualifications and certifications to students and educators. So far, students and educators from more than 3300 universities around the world, are a part of the program and getting trained in data analytics. Recently, we spoke to Radhika Rajendra who is an MBA from Christ University Bangalore and she had an interesting story to share. During Covid, when there was a ge... Show More

The Qlik Academic Program offers world class data analytics training, software, qualifications and certifications to students and educators. So far, students and educators from more than 3300 universities around the world, are a part of the program and getting trained in data analytics.

Recently, we spoke to Radhika Rajendra who is an MBA from Christ University Bangalore and she had an interesting story to share. During Covid, when there was a general freeze on job opportunities, she undertook training on the Qlik Academic Program and qualified as a Qlik Sense Business Analyst. While she had an interest in data analytics, she was more keen to secure a job for herself during those tough times. She met success with a top global consulting firm who hired her as a Qlik Sense Developer. Radhika continues to work on Qlik Sense in a different role even today and credits her success to the Qlik Academic Program.

To read more about Radhika's story, visit: https://www.qlik.com/us/solutions/customers/customer-stories/christ-university

To learn how you can access free training and qualifications on the Qlik Academic Program, visit: qlik.com/academicprogram

Show Less

0

21

Support Updates

Upgrade advisory for Qlik Sense on-premise November 2024: Required add-on upgrad...

Hello Qlik Admins and Developers, The next major Qlik Sense Enterprise on Windows release is scheduled for November 2024. The update will introduce changes that will have an impact on the following add-ons: Qlik Alerting (link) Qlik Sense Mobile client-managed (link) qlik-cli (link) Upgrade to v.2.25.0 or higher qlik/api (link) Upgrade to v1.12.0 or higher Qlik Sense .NET SDK (link) Upgrade to v16.8.0 or higher The changes affecting the add-ons... Show More

Hello Qlik Admins and Developers,

The next major Qlik Sense Enterprise on Windows release is scheduled for November 2024. The update will introduce changes that will have an impact on the following add-ons:

Qlik Alerting (link)
Qlik Sense Mobile client-managed (link)
qlik-cli (link) Upgrade to v.2.25.0 or higher
qlik/api (link) Upgrade to v1.12.0 or higher
Qlik Sense .NET SDK (link) Upgrade to v16.8.0 or higher

The changes affecting the add-ons are:

Extended CSRF protection to Websocket requests
Adding support for CSRF to add-on products

New versions of all affected add-ons will be available with the November 2024 release, and the associated Release Notes will provide detailed information on any improvements and changes.

Please plan your upgrade accordingly to prevent interruptions:

If you upgrade to Qlik Sense Enterprise on Windows November 2024, all listed add-ons must be upgraded as well.

Thank you for choosing Qlik,
Qlik Support

Show Less

8

8720

Explore Qlik Gallery

AI Splits for Impacts

AI Splits for Impacts AnyChart Auto-detect key impacts to accelerate root cause analysis — Showcasing the AI Splits feature (October 2024) alongside other key capabilities of the Decomposition Tree visual in Qlik Sense. Discoveries Instantly identifies the highest and lowest impact factors across multiple dimensions. Impact Streamlines root cause analysis by delivering deeper insights straight away. Audience Aiming to empo... Show More

AI Splits for Impacts

Auto-detect key impacts to accelerate root cause analysis — Showcasing the AI Splits feature (October 2024) alongside other key capabilities of the Decomposition Tree visual in Qlik Sense.

Discoveries

Instantly identifies the highest and lowest impact factors across multiple dimensions.

Impact

Streamlines root cause analysis by delivering deeper insights straight away.

Audience

Aiming to empower end users with the ability to instantly uncover critical factors affecting key metrics.

Data and advanced analytics

Features decomposition trees visualizing (fictional) sales data.

🔗 >> View Live or Download QVF <<

🔗 >> Learn More About AI Splits <<

🔗 >> Read “Visualizing Dimensional Relationships” by Dalton Ruer (Qlik) <<

Show Less

0

43

Design

Org Chart

With the Qlik Sense April 2020 release, the Org Chart was added to the Qlik Visualization bundle. The Org chart provides a way to visualize hierarchies in your data. In this blog post, I will review how easy it is to create an Org chart provided you have the hierarchical data structure in your data model. Below is a snapshot from an Excel file that was loaded. It has the employees within a company and who each person reports to.The things to note... Show More

With the Qlik Sense April 2020 release, the Org Chart was added to the Qlik Visualization bundle. The Org chart provides a way to visualize hierarchies in your data. In this blog post, I will review how easy it is to create an Org chart provided you have the hierarchical data structure in your data model. Below is a snapshot from an Excel file that was loaded. It has the employees within a company and who each person reports to.

The things to note in this file are:

Every employee has a unique Employee ID.
The Manager ID is the Employee ID of the employee’s manager.

This spreadsheet is designed to go 5 levels deep (EmpName 1 through EmpName5) but additional columns can be added or removed as needed. Other supporting employee data can also be added to the data model to use in the org chart or in other charts in the app.

To begin, add the Org chart to a sheet. The Org chart takes 2 dimensions and 1 measure. The first dimension added is EmployeeID. In the Org chart, each employee will have their own card. In the properties for the EmployeeID dimension, other information that you would like to show on the card for each employee can be added.

In this example, the card title has been set to EmployeeName, the sub-title to the employee’s title and the card description to the employee’s salary. There are some colors loaded in the data model so the field, Color2, was selected coloring the cards by the employee’s title. The second dimension added to the Org chart is the Reports To field. This field stores the EmployeeID of the employee’s manager like the ManagerID field. There is also the option to add a measure. In this example, a measure was not added. If a measure is added, it will be visible when you hover over a card. That’s it – that is all that needs to be done to add an Org chart to your Qlik Sense app.

Now, let’s take a look at the Org chart. By default, the Org chart will show 2 levels when you come to the sheet.

default view.png

If an employee is a manager, there will be a number under their card indicating the number of employees that report directly to them. Clicking on that number will open the cards of their direct report(s). When there is a plus sign (+) that means that there are cards that are not visible. Once the cards of a manager are opened, it will turn into a minus sign (-) to indicate that the card is opened. This is visible in the image below.

The Org chart provides an easy way to see the hierarchical structure within an organization. Users can zoom in and out in the chart as needed and Qlik Sense will handle closing cards if newly opened cards may overlap or get in the way. Check out this chart and other new features of the Qlik Sense April 2020 release in the resources listed below.

Demo: What's New - Qlik Sense April 2020
Video: What’s New – Qlik Sense April 2020
Video: April 2020 Feature Demonstration
Blog: Qlik Data Analytics Product Release - April 2020

Thanks,
Jennell

Show Less

2

9484

Support Updates

Qlik Sense Enterprise for Windows - New Security Patches Available Now

Edited December 5th: identified upgrades leading to complications with extensionsEdited December 6th: added workaround for extension complicationEdited December 10th: added CVEs (CVE-2024-55579 and CVE-2024-55580)Edited December 12th, noon CET: added new patch versions and visualization and extension fix details; previous patches were removed from the download site Hello Qlik Users, New patches have been made available and have replaced the orig... Show More

Edited December 5th: identified upgrades leading to complications with extensions
Edited December 6th: added workaround for extension complication
Edited December 10th: added CVEs (CVE-2024-55579 and CVE-2024-55580)
Edited December 12th, noon CET: added new patch versions and visualization and extension fix details; previous patches were removed from the download site

Hello Qlik Users,

New patches have been made available and have replaced the original six releases. They include the original security fixes (CVE-2024-55579 and CVE-2024-55580) as well as QB-30633 to resolve the extension and visualization defect.

If you continue to experience issues with extensions or visualizations, see QB-30633: Visualizations and Extensions not loading after applying patch.

Security issues in Qlik Sense Enterprise for Windows have been identified, and patches have been made available. Details can be found in Security Bulletin High Severity Security fixes for Qlik Sense Enterprise for Windows (CVE-2024-55579 and CVE-2024-55580).

Today, we have released six service releases across the latest versions of Qlik Sense to patch the reported issue. All versions of Qlik Sense Enterprise for Windows prior to and including these releases are impacted:

May 2024 Patch 9
February 2024 Patch 13
November 2023 Patch 15
August 2023 Patch 15
May 2023 Patch 17
February 2023 Patch 14

No workarounds can be provided. Customers should upgrade Qlik Sense Enterprise for Windows to a version containing fixes for these issues. November 2024 IR, released on the 26th of November, contains the fix as well.

November 2024 Initial Release
May 2024 Patch 10 or 11 (both valid)
February 2024 Patch 14 or 15 (both valid)
November 2023 Patch 16 or 17 (both valid)
August 2023 Patch 16 or 17 (both valid)
May 2023 Patch 18 or 19 (both valid)
February 2023 Patch 15 or 16 (both valid)

This issue only impacts Qlik Sense Enterprise for Windows. Other Qlik products including Qlik Cloud and QlikView are NOT impacted.

All Qlik software can be downloaded from our official Qlik Download page (customer login required). Follow best practices when upgrading Qlik Sense.

The information in this post and Security Bulletin High Severity Security fixes for Qlik Sense Enterprise for Windows (CVE-2024-55579 and CVE-2024-55580) are disclosed in accordance with our published Security and Vulnerability Policy.

The Security Notice label is used to notify customers about security patches and upgrades that require a customer’s action. Please subscribe to the ‘Security Notice’ label to be notified of future updates.

Thank you for choosing Qlik,
Qlik Global Support

Show Less

14

24896

Subprocessors List

Qlik and Talend Subprocessors General Data Protection Regulation (GDPR) - Versio...

Table of Contents Third party subprocessors for Qlik offeringsThird party subprocessors for Talend offeringsAffiliate Subprocessors for Qlik and Talend Version 5.7. Current as of: 20th January 2025 Qlik and Talend, a Qlik company, may from time to time use the following Qlik and Talend group companies and/or third parties (collectively, “Subprocessors”) to process personal data on customers’ behalf (“Customer Personal Data”) for purposes of pro... Show More

Table of Contents

Version 5.7. Current as of: 20th January 2025

Qlik and Talend, a Qlik company, may from time to time use the following Qlik and Talend group companies and/or third parties (collectively, “Subprocessors”) to process personal data on customers’ behalf (“Customer Personal Data”) for purposes of providing Qlik and/or Talend Cloud, Support Services and/or Consulting Services.

Qlik and Talend have relevant data transfer agreements in place with the Subprocessors (including group companies) to enable the lawful and secure transfer of Customer Personal Data.

You can receive updates to this Subprocessor list by subscribing to this blog or by enabling RSS feed notifications.

Third party subprocessors for Qlik offerings

Third party subprocessors for Qlik Cloud
Third Party	Location of processing (e.g., tenant location)	Service Provided/Details of processing	Address of contracting party	Contact
Amazon Web Services (AWS)	If EU region is chosen: Ireland (Republic of); & Paris, France (back-up); or Frankfurt, Germany; & Milan, Italy (back-up); or London, UK; & Spain (back-up). Qlik Anonymous Access: Stockholm, Sweden. If US region is chosen: North Virginia, US; & Ohio, US (back-up). If APAC region is chosen: Sydney, Australia; & Melbourne, Australia (back-up); or Singapore;& Seoul, S. Korea(back-up); or Tokyo, Japan;& Osaka, Japan(back-up); or Mumbai, India; Hyderabad, India (back-up).	Qlik Cloud is hosted through AWS	Amazon Web Services, Inc. 410 Terry Avenue North, Seattle, WA 98109-5210, U.S.A	AWS AWS Privacy
MongoDB	See Qlik Cloud locations above	Any data inputted into the Notes feature in Qlik Cloud	Mongo DB, Inc. 229 West 43rd St., New York, NY 10036 USA	MongoDB
Third party subprocessors for Qlik Support Services and/or Consulting Services The vast majority of Qlik’s support data that it processes on behalf of customers is stored in Germany (AWS). However, in order to resolve and facilitate the support case, such support data may also temporarily reside on the other systems/tools below.
Amazon Web Services (AWS)	Germany	Support case management tools	Amazon Web Services, Inc. 410 Terry Avenue North, Seattle, WA 98109-5210, U.S.A.	AWS AWS Privacy
Salesforce	UK	Support case management tools	Salesforce UK Limited Village 9 Floor 26 Salesforce Tower 110 Bishopsgate London, UK EC2N 4AY	Salesforce
Grazitti SearchUnify	United States	Support case management tools	Grazitti Interactive Plot 164 Industrial Area Phase 2 Panchkula, Haryana India 134113	Grazitti
Microsoft	United States	Customer may send data through Office 365	Microsoft Corporation One Microsoft Way, Redmond, WA 98052 USA	Chief Privacy Officer One Microsoft Way, Redmond, WA 98052 USA
Ada	Germany	Support Chatbot	Ada Support 371 Front St W, Unit 314 Toronto, Ontario M5V 3S8 CANADA	Ada
Persistent	India	R&D Support Services	2055 Laurelwood Road Suite 201 Santa Clara, California 95054 USA	Persistent
Atlassian (Jira Cloud)	Germany, Ireland (Back-up)	R&D support management tool	350 Bush Street Floor 13 San Francisco, CA 94104 United States	Atlassian
Altoros	United States	R&D Support Services	Altoros Americas, LLC 830 Stewart Drive, Suite 119 Sunnyvale, CA 94085 United States	Altoros
Ingima	Israel	R&D Support Services	Ha-Khilazon St 3, Ramat Gan, Israel	Mickey Peleg
Galil	Israel	R&D Support Services	Galil Software and Technology Services Ltd. Industrial Park, Mount Precipice, 2015 St, 1610102 Nazareth, Israel	Galil
Third party subprocessors for Qlik mobile device apps
Google Firebase	United States	Push notifications	Google LLC 1600 Amphitheatre Parkway Mountain View California United States	Google

Third party subprocessors for Talend offerings

Third party subprocessors for Talend Cloud
Third Party	Location of processing (e.g., tenant location)	Service Provided/Details of Processing	Address of contracting party	Contact
Amazon Web Services (AWS)	Talend Cloud AMERICAS: Virginia, US; & Oregon, US (backup). EMEA: Frankfurt, Germany; & Ireland (Republic of)(backup). APAC: Tokyo, Japan; & Singapore (backup); or Sydney, Australia; & Singapore (backup); or Singapore;& Seoul, S. Korea(back-up); Stitch AMERICAS: Virginia, US; & Oregon, US (backup). EMEA: Frankfurt, Germany; & Ireland (Republic of) (backup).	These Talend Cloud locations are hosted through AWS	Amazon Web Services, Inc. 410 Terry Avenue North, Seattle, WA 98109-5210, U.S.A.	AWS AWS Privacy
Microsoft Azure	United States: California; Virginia (backup)	These Talend Cloud locations are hosted through Microsoft Azure	Microsoft Corporation 1 Microsoft Way, Redmond, WA 98052, USA	Microsoft Enterprise Service Privacy Microsoft Corporation 1 Microsoft Way Redmond, Washington 98052 USA
MongoDB	See Talend Cloud locations above		Mongo DB, Inc. 229 West 43rd St., New York, NY 10036 USA	MongoDB

Third party subprocessors for Talend Support Services and/or Consulting Services: In order to provide Support and/or Consulting Services, the following third party tools may be used.
Sub-processor	Location of processing (e.g., tenant location)	Service Provided/Details of processing	Address of contracting party	Contact
Atlassian	France United States	Project management; support issue tracking	Atlassian Pty Ltd 350 Bush Street Floor 13 San Francisco, CA 94104 United States	Atlassian
Atlassian (Jira Cloud)	Germany, Ireland (Back-up)	R&D support management tool	Atlassian Pty Ltd 350 Bush Street Floor 13 San Francisco, CA 94104 United States	Atlassian
Microsoft	United States	Email provider, if the Customer sends Customer Personal Data through email.	Microsoft Corporation 1 Microsoft Way, Redmond, WA 98052, USA	Microsoft Enterprise Service Privacy Microsoft Corporation 1 Microsoft Way Redmond, Washington 98052 USA
Salesforce	United States	CRM; support case management	Salesforce UK Limited Floor 26 Salesforce Tower 100 Bishopsgate London EC2N 4AY	Salesforce

Affiliate Subprocessors for Qlik and Talend

Affiliate Subprocessors These affiliates may provide services, such as Consulting or Support, depending on your location and agreement(s) with us. Our Support Services are predominantly performed in the customer’s region: EMEA – France, Sweden, Spain, Israel; Americas – USA; APAC – Japan, Australia, India.
Subsidiary Affiliate	Location of processing (e.g., tenant location)	Service Provided/Details of Processing	Address of contracting party	Contact
QlikTech Netherlands BV, Talend Netherlands B.V.	Netherlands	These affiliates may provide services, such as Consulting or Support, depending on your location and agreement(s) with us. Our Support Services are predominantly performed in the customer’s region: EMEA – France, Sweden, Spain, Israel; Americas – USA; APAC – Japan, Australia, India.	Evert van de Beekstraat 1-122 Building B, 6th Floor 1118 CL Schiphol	DPO
QlikTech Netherlands BV (Belgian branch)	Belgium		Culliganlaan 2D 1831 Diegem
Blendr NV	Belgium		Bellevue Tower Bellevue 5, 4th Floor, Ledeberg 9050 Ghent Belgium
QlikTech UK Limited, Talend Ltd.	United Kingdom		1020 Eskdale Road, Winnersh, Wokingham, RG41 5TS United Kingdom
Qlik Analytics (ISR) Ltd.	Israel		1 Atir Yeda St, Building 2 7th floor 4464301, Kfar Saba Israel
QlikTech International Markets AB (DMCC Branch)	United Arab Emirates		AB (DMCC Branch) JBC 3 Building, Cluster Y 3rd Floor, Office 301 P.O. Box 120115 Jumeirah Lake Towers Dubai
QlikTech Inc.	United States		211 South Gulph Road Suite 500 King of Prussia, Pennsylvania 19406
QlikTech Corporation (Canada), Talend	Canada		1133 Melville Street Suite 3500, The Stack Vancouver, BC V6E 4E5 Canada
QlikTech México S. de R.L. de C.V.	Mexico		c/o IT&CS International Tax and Consulting Service San Borja 1208 Int. 8 Col. Narvate Poniente, Alc Benito Juarez 03020 Ciudad de Mexico Mexico
QlikTech Brasil Comercialização de Software Ltda.	Brazil		51 – 2o andar - conjunto 201 Vila Olímpia – São Paulo – SP Brazil
QlikTech Japan K.K., Talend KK	Japan		105-0001 Tokyo Toranomon Global Square 13F, 1-3-1. Toranomon, Minato-ku, Tokyo, Japan
QlikTech Singapore Pte. Ltd., Talend Singapore Pte. Ltd.	Singapore		9 Temasek Boulevard Suntec Tower Two Unit 27-01/03 Singapore 038989
QlikTech Hong Kong Limited	Hong Kong		Unit 19 E Neich Tower 128 Glouchester Road Wanchai, Hong Kong
Qlik Technology (Beijing) Limited Liability Company, Talend China Beijing Technology Co. Ltd.	China		51-52, 26F, Fortune Financial Center, No. 5 Dongsan Huanzhong Road, Chaoyang district, Pekin / Beijing, 100020 China
QlikTech India Private Limited, Talend Data Integration Services Private Limited	India		“Kalyani Solitaire” Ground Floor & First Floor 165/2 Krishna Raju Layout Doraisanipalya Off Bannerghatta Road, JP Nagar, Bangalore 560076
QlikTech Australia Pty Ltd, Talend Australia Pty Ltd.	Australia		McBurney & Partners Level 10 68 Pitt Street Sydney NSW 2000 Australia
QlikTech New Zealand Limited	New Zealand		Kensington Swan 40 Bowen Street Wellington 6011 New Zealand

In addition to the above, other professional service providers may be engaged to provide you with professional services related to the implementation of your particular Qlik and/or Talend offerings; please contact your Qlik account manager or refer to your SOW on whether these apply to your engagement.

Qlik and Talend reserve the right to amend its products and services from time to time. For more information, please see www.qlik.com/us/trust/privacy and/or https://www.talend.com/privacy/.

Show Less

5

41034

Support Updates

Join Us Live! Q&A with Qlik: Qlik Sense – Client Managed

January 28 at 10:00 EST / 16:00 CET

0

205

Japan

Iceberg を活用してお客様に成功をもたらすスケーラブルでオープンなデータソリューション

Qlik を代表して、Upsolver の買収について、また、この買収がどのようにお客様に新たな可能性を提供し、これまで手の届かなかった方法でお客様の目標達成を支援するかについて、いくつかの考えを共有できることを嬉しく思います。

0

105

Design

Predicting House Prices using Qlik AutoML Regression Model

If you have been learning about Qlik AutoML or looking for examples to get started, you might have only came across Binary Classification problems (such as Customer churn, Employee retention etc…). In this post, we will be solving a different type of problem with Qlik AutoML using a Regression model. What is Regression, and Why Does It Matter? Regression is a type of supervised learning used to predict continuous outcomes like housing prices, sal... Show More

If you have been learning about Qlik AutoML or looking for examples to get started, you might have only came across Binary Classification problems (such as Customer churn, Employee retention etc…). In this post, we will be solving a different type of problem with Qlik AutoML using a Regression model.

What is Regression, and Why Does It Matter?

Regression is a type of supervised learning used to predict continuous outcomes like housing prices, sales revenue, or stock prices. In industries such as real estate, understanding the factors driving prices can guide better decision-making. For example, predicting house values based on income levels, population, and proximity to the ocean helps realtors and developers target key markets and optimize pricing strategies.

In the upcoming sections, we go through how to build and deploy a regression model using Qlik AutoML to predict house prices using the common California Housing Dataset.

Step 1: Defining the Problem

Before creating the AutoML experiment, let’s define the core elements of our use case:

Trigger: New houses or listing entries are added to the dataset.
Target: Predict the house's value.
Features: Latitude, longitude, median age, total rooms, total bedrooms, population, households, median income, and proximity to the ocean.

Step 2: AutoML

The California Housing dataset is split into Training (historical) housing_train.csv and Apply (new) housing_test.csv data files.

Start by uploading these files to your Qlik Cloud tenant.

(The files are attached at the end of the blog post)

Creating the AutoML Experiment

Start a New Experiment:
- In your Qlik Cloud tenant, click on Create → ML Experiment
Select Your Dataset:
- Choose housing_train.csv as your dataset. AutoML will automatically identify columns as features and recommend their types.
Set the Target Variable:
- Choose median_house_value as the target for prediction.
- Ensure all relevant features are selected, and adjust any feature types if needed.
Run the Experiment:
- Click Run Experiment and let AutoML analyze the data. After a few minutes, you'll see the initial results, including SHAP values and model performance metrics.
- You can also take a look at the Compare and Analyze tabs for more advanced details.

Deploying the AutoML Model

Choose the top-performing model from the experiment results.
Click on Deploy

Creating Predictions

Once in the Deployment screen, add the Apply dataset, create a Prediction, and make sure to select SHAP and Coordinate SHAP as files to be generated. We will use these later on in our Qlik Sense Analytics app to gain explainability insights.

Screenshot 2025-01-17 163601.png

Step 3: Creating the Qlik Sense Analytics App

Now it’s time to visualize the predictions:

Load the Predictions:
- Navigate to the Catalog and locate the newly created Housing_test_Prediction.parquet file.
  Click Create Analytics App.
- Add additional data, including SHAP and Coordinate SHAP files as well as the apply dataset.
Build the Dashboard:
- Create visualizations such as:
  - A SHAP ranking to highlight the most influential features.
  - A histogram showing the distribution of predicted house values.
  - A map with gradient colors to visualize house prices by location.
You can experiment with different visualization types to explore the data from multiple perspectives.

Understanding the results:

Based on the Qlik AutoML model, we can clearly see how features like income levels and ocean proximity can influence housing prices.

For more inspiration on how you can use your predictions within your Qlik Sense Apps or in your embedded use cases, check out my previous blog posts:

Show Less

1

163

Design

Qlik Cloud WordPress Plugin: updated version using Qlik Embed

If you’ve came across the initial Qlik Cloud Wordpress plugin on the Qlik Community Design blog and gave it a try, you probably have run into some issues with it. Today, I’m going to share a new updated version of the Qlik Cloud WordPress plugin that brings a more efficient way to embed Qlik Cloud analytics into your WordPress websites. In this post, I'll walk you through the steps to install, configure, and use the new version of the plugin to b... Show More

If you’ve came across the initial Qlik Cloud Wordpress plugin on the Qlik Community Design blog and gave it a try, you probably have run into some issues with it. Today, I’m going to share a new updated version of the Qlik Cloud WordPress plugin that brings a more efficient way to embed Qlik Cloud analytics into your WordPress websites.

In this post, I'll walk you through the steps to install, configure, and use the new version of the plugin to bring your Qlik Cloud visualizations directly into your WP pages and posts.

Why the Update?

The previous version of our plugin relied on JWT tokens for auth, iframes (single integration API) and nebula.js for embedding, which worked but had limitations such as third-party cookies. Qlik Embed is the new embedding library and adopts better auth flows. In this version, I'm using OAuth impersonation to generate access token on the backend without need for users to interact with a login page.

Installation Steps

1. Install the Plugin

Log in to your WordPress Admin Dashboard.
Navigate to Plugins on the left sidebar.
Click on "Add New" at the top of the page.
Upload the zipped file (download it from GitHub here)
Locate the plugin and click "Install Now".
After installation, click "Activate".

Note: If you have the previous version installed, deactivate and delete it before installing the new one to avoid conflicts.

Configuring Qlik Cloud Wordpress Plugin

Before using the plugin, you'll need to set up OAuth impersonation in your Qlik Cloud tenant.

Create an OAuth Client

Log in to your Qlik Cloud tenant as an administrator.
Navigate to Management Console > Integrations > OAuth.
Click on "Create new" and fill in the required details:
- Name: Give a recognizable name like "WordPress Integration".
- Allowed Origins: Add your WordPress site's URL.
Select the right scopes to grant to the client from the Scopes list.
Check “Allow Machine-to-Machine (M2M)” and “Allow M2M user impersonation”
Change the consent method to Trusted
Save the client credentials (Client ID and Client Secret) to be used in WordPress Config.

Docs here: https://qlik.dev/authenticate/oauth/create/create-oauth-client-m2m-impersonation/

Make sure to read through the Guiding Principles of OAuth Impersonation: https://qlik.dev/authenticate/oauth/guiding-principles-oauth-impersonation

P.S: this method will create a number of anonymous users on your tenant and you need to implement a way to remove these users periodically (using a Qlik Application Automation / users API)

Configuring the Plugin

In your WordPress dashboard, go to Settings > Qlik Cloud Embed.
Fill in the required fields:
- Host: e.g., https://your-tenant.region.qlikcloud.com.
- Client ID: From the OAuth client you created.
- Client Secret: From the OAuth client.
Click "Save Changes".

Using the Plugin

Embedding Sheets and Visualizations

With the plugin configured, you can now embed Qlik Cloud content using Shortcodes.

1. Embed an Entire Sheet/App

Use the [qlik-embed-app] shortcode:

[qlik-embed-app appid="1234-c56a-4062-ac50-377bba443e85" sheetid="12345-698f-449f-9a17-dca17eeadb71"]

Parameters:

appid: App ID
sheetid: Sheet ID

2. Embed Individual Visualizations/Objects

Use the [qlik-embed-object] shortcode:

[qlik-embed-object appid="1234-64317-8432" objectid="1234-5553-326432"]

Parameters:

appid: App ID
objectid: Object ID

3. Embed Selections bar

Use the [qlik-embed-selections] shortcode:

[qlik-embed-selections appid="1234-c56a-4062-ac50-377bba443e85"]

Parameters:

appid: App ID

Tip:

Finding IDs in Qlik Cloud

Open your app in Qlik Cloud.
Navigate to the sheet or object you want to embed.
In the URL, find the sheet ID
- Sheet ID comes after /sheet/
For object, right click on the chart, click on Embed, and look for objectid under the chart preview.

You can download the plugin here: https://github.com/qlik-demo-team/wp-qlik-saas-plugin

P.S: this plugin is maintained by myself. If you find any bugs or issues, please report them to me or create an issue on Github and I'll do my best to resolve them quickly.

Thank you!

Show Less

4

1051

Design

Button + Reload Data or Button + Execute App Automation - which do I use?

Learn the differences between Qlik Sense button actions - Reload Data and Execute Automation - when you want to reload a Qlik Sense app, or have ANY user execute an automation.

12

6479

Community News

Fresh Look, Same Great Community: New Artwork on Qlik Community!

We’re excited to share a fresh update to the Qlik Community!

15

965

Qlik Academic Program

Empowering Education Through Data: Meet Your New EMEA Lead

I’m thrilled to introduce myself as the new EMEA Lead for the Qlik Academic Program. Let’s empower educators and students to thrive in a data-driven world!

3

77

Support Updates

Qlik Application Automation execution token changes

Hello Qlik Users, On January 13th 2025, Qlik will introduce breaking changes to the execution token functionality for triggered automations. Contents What does this mean for my triggered automation?How do I configure the Run Mode?Additional change: Execution tokens become header parameters (Q2 2025)Related improvement: custom parameter support for button-triggered automations What does this mean for my triggered automation? Triggered automa... Show More

Hello Qlik Users,

On January 13th 2025, Qlik will introduce breaking changes to the execution token functionality for triggered automations.

What does this mean for my triggered automation?

Triggered automations will require their Run Mode to be set to triggered to continue to work as expected. Past January 13th, it will no longer be possible to use the below endpoint to trigger an automation not explicitly configured with a triggered run mode:

api/v1/automations/{id}/actions/execute

How do I configure the Run Mode?

The run mode can be configured in the Start block of an automation:

Open the Automation
Select the Start Block
Open the Inputs tab
Select Triggered as the Run Mode

Additional change: Execution tokens become header parameters (Q2 2025)

An additional change to how execution tokens are used will be introduced at a later date. The change is planned for Q2 2025.

When triggering a triggered automation through the trigger URL (see the below endpoint) the execution token must be sent as a header parameter. Currently, it is possible to send the execution token as a query parameter. With Q2 2025, sending execution tokens as header parameters will eventually be enforced.

api/v1/automations/{id}/actions/execute

Related improvement: custom parameter support for button-triggered automations

When triggering an automation from a button in an app it is now possible to provide additional input parameters that are defined in the button configuration. More information can be found here: custom input parameters for the native button.

Don't hesitate to reach out if you have any questions or address our experts directly in the Qlik Application Automation forum.

Thank you for choosing Qlik,
Qlik Support

Show Less

3

2808

Qlik Academic Program

The Importance of Data Literacy in Education: Preparing Students for the Future

you don't want to miss this!

1

88

Explore Qlik Gallery

Sensibo - Temp and humity

Sensibo - Temp and humityPersonalDashboard based on the API of Sensibo.DiscoveriesMore insights into the temperature and humidity in a room. Historical information is also available, but only 1 day of history in the app.ImpactNo business impact, but it can be used for home automation.AudiencePersonal / Home automationData and advanced analyticsMore insight and historical data.

0

43

Support Updates

Techspert Talks - SAP Connection to Qlik Talend Cloud

Hi everyone, Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from Qlik experts. The Techspert Talks session from January looked at SAP Connection to Qlik Talend Cloud. But wait, what is it exactly?Techspert Talks is a monthly free webinar, where you can hear directly from Qlik Techsperts on topics relevant to Customers and Partners today. In this session... Show More

Hi everyone,
Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from Qlik experts.

The Techspert Talks session from January looked at SAP Connection to Qlik Talend Cloud.

But wait, what is it exactly?
Techspert Talks is a monthly free webinar, where you can hear directly from Qlik Techsperts on topics relevant to Customers and Partners today.

In this session, we cover:

Completing connection requirements
Setting up SAP connection to Qlik Talend Cloud Data Integration
SAP data best practices

Click on this link to watch the recording.

Show Less

4

595

Explore Qlik Gallery

Air Quality Monitor App

Air Quality Monitor AppSchneider ElectricThis app was created as a submission to the May 2024 Qlik Nation Dashboard Challenge, where it was named the winner. It maps various sources of air pollution globally and compares city-level air pollution data to regional averages. The app also examines the relationship between different air pollutant concentrations and asthma rates, utilizing historical data from the World Health Organization (WHO) as the... Show More

Air Quality Monitor App

This app was created as a submission to the May 2024 Qlik Nation Dashboard Challenge, where it was named the winner. It maps various sources of air pollution globally and compares city-level air pollution data to regional averages. The app also examines the relationship between different air pollutant concentrations and asthma rates, utilizing historical data from the World Health Organization (WHO) as the primary data source.

Discoveries

Users can explore historical air pollution levels in major cities worldwide, comparing them to regional averages. The app reveals trends in air quality over time and helps identify cities with the highest and lowest pollution levels. By analyzing the concentration of specific air pollutants, such as PM2.5 and NOx, users can discover correlations between air quality and asthma rates in different regions. This app also provides insights into the impact of urbanization and industrialization on air quality, allowing users to understand the potential health risks associated with varying pollution levels. Additionally, it highlights the progress made in reducing air pollution in certain areas, offering a comprehensive view of global air quality trends.

Impact

The app has significantly impacted public health awareness by providing easy access to critical data on air pollution and its effects on respiratory health. It has enabled health professionals, policymakers, and the general public to make informed decisions about air quality management and mitigation strategies, ultimately contributing to efforts in reducing pollution-related health risks.

Audience

The audience for this app includes: 1. Public Health Professionals: Researchers and healthcare providers interested in studying the effects of air pollution on health, particularly respiratory conditions like asthma. 2. Policymakers and Government Agencies: Officials who develop regulations and policies to improve air quality and public health. 3. Environmental Organizations: Groups focused on environmental protection and advocacy, using the app to support initiatives for cleaner air. 4. Urban Planners and City Officials: Professionals involved in urban development who need data on pollution levels to make informed decisions about infrastructure and zoning. 5. Educational Institutions and Researchers: Students and academics studying environmental science, public health, or urban planning. 6. General Public: Individuals concerned about air quality and its impact on health, looking for information about pollution levels in their cities or regions.

Data and advanced analytics

The app leverages comprehensive data analytics to visualize and compare air pollution levels across different regions and times. By utilizing advanced analytics, it provides actionable insights into pollution trends and their correlation with health outcomes, enabling more targeted and effective public health interventions.

Show Less

3

632

Design

Conditional Aggregations

Often you need to create conditional aggregations in QlikView, e.g. when you want to create a graph that shows this year’s numbers only, also if there are several years possible. There are basically three ways to do this A conditional expression outside the aggregation function, e.g. If(<Condition>, Sum(<Expression>)) A conditional expression inside the aggregation function, e.g. Sum(If(<Condition>,<Expression>)) Set Analysis, e.g. Sum( {<S... Show More

Often you need to create conditional aggregations in QlikView, e.g. when you want to create a graph that shows this year’s numbers only, also if there are several years possible.

Image1 count.png

There are basically three ways to do this

A conditional expression outside the aggregation function, e.g. If(<Condition>, Sum(<Expression>))
A conditional expression inside the aggregation function, e.g. Sum(If(<Condition>,<Expression>))
Set Analysis, e.g. Sum( {<Set Expression>} <Expression> )

If you choose a conditional expression outside the aggregation function, you will have a condition that is evaluated once per dimensional value. Further, all three parameters of the If() function are aggregations, so you need to use aggregation functions, also in the condition, otherwise the expression will not be evaluated the way you want to.

So - don’t use naked field references!

If( ShippingDate >= vReferenceDate, Sum( Amount ) ) // Incorrect !

If( Min( ShippingDate ) >= vReferenceDate, Sum( Amount ) ) // Correct

If you instead put the conditional expression inside the aggregation function, you will have a very different situation: First, the condition will be evaluated on the record level of the source data. In other words: You may get performance problems if you have large data amounts.

Sum( If( ShippingDate >= vReferenceDate, Amount ) )

Secondly, the aggregation function now contains an expression based on several fields (in the above example, ShippingDate and Amount), possibly from several source tables. This means that QlikView will aggregate over the Cartesian product of the included source tables. Normally this is not a problem, but in some odd cases, you will have results different from what you expect.

For instance, if the record with Amount has several shipping dates associated with it, the amount will be counted several times, once per shipping date, and you will get a result that you probably consider incorrect. There is usually a way to get around this problem by writing the expression differently, but if you can’t find one, you should use Set Analysis instead.

The conditional expression can be written in several ways:

String comparison: If( Field = ‘string’, Amount )
Numeric comparison: If( Field = number, Amount )
Boolean condition: If( Flag, Amount ) e.g. Sum( If( IsThisYear, Amount ) )
Multiplication: Flag * Amount e.g. Sum( IsThisYear * Amount )

The two first examples contain comparisons, whereas the two last contain flags - Boolean fields created in the script. All four ways work fine, but I would recommend avoiding comparisons altogether. Use flags instead. See e.g. Year-over-Year Comparisons for more on flags.

Finally, you can choose to use Set Analysis. This is slightly different from other conditional expressions in that it uses the QlikView selection metaphor for the analysis: First, the Set Expression is interpreted as a selection, whereupon the aggregation is evaluated given this selection.

Sum( {$<ShippingDate = {">='$(vReferenceDate)'"}>} Amount )

Sum( {$<IsThisYear = {1}>} Amount )

This means that Set Analysis often is faster than using a conditional expression inside the aggregation. It also means that it calculates what you expect, as opposed to a case where an inside condition creates an unwanted Cartesian product.

However, a drawback with the Set Analysis is that it needs to be performed before QlikView performs the aggregation – you cannot have a Set Expression that evaluates to different values for different rows. The work-around is to calculate the condition in the script and store it in a flag.

Bottom line: Define flags in the script. And use Set Analysis.

HIC

Dissecting the New UI: Analytics

In this blog, we take a look at the second section of the new UI: Analytics.

0

539

Recent Blog Posts

Discoveries

Impact

Audience

Data and advanced analytics

Third party subprocessors for Qlik offerings

Third party subprocessors for Talend offerings

Affiliate Subprocessors for Qlik and Talend

What is Regression, and Why Does It Matter?

Step 1: Defining the Problem

Step 2: AutoML

Creating the AutoML Experiment

Deploying the AutoML Model

Creating Predictions

Step 3: Creating the Qlik Sense Analytics App

Understanding the results:

Why the Update?

Installation Steps

1. Install the Plugin

Configuring Qlik Cloud Wordpress Plugin

Create an OAuth Client

Configuring the Plugin

Using the Plugin

Embedding Sheets and Visualizations

1. Embed an Entire Sheet/App

2. Embed Individual Visualizations/Objects

3. Embed Selections bar

Finding IDs in Qlik Cloud

Contents

What does this mean for my triggered automation?

How do I configure the Run Mode?

Additional change: Execution tokens become header parameters (Q2 2025)

Related improvement: custom parameter support for button-triggered automations

Discoveries

Impact

Audience

Data and advanced analytics