Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
By reading the Product Innovation blog, you will learn about what's new across all of the products in our growing Qlik product portfolio.
The Support Updates blog delivers important and useful Qlik Support information about end-of-product support, new service releases, and general support topics.
This blog was created for professors and students using Qlik within academia.
Hear it from your Community Managers! The Community News blog provides updates about the Qlik Community Platform and other news and important announcements.
The Qlik Digest is your essential monthly low-down of the need-to-know product updates, events, and resources from Qlik.
The Qlik Learning blog offers information about the latest updates to our courses and programs, as well as insights from the Qlik Learning team.
No scripting skills? No problem.
With Qlik Data Flow, our no-code data prep tools, we’re flipping the script on how analysts spend their time. Instead of drowning in data preparation—often taking up to 80% of your time—you can now focus on what really matters: uncovering insights. This shift means quicker, more impactful decision-making for your business.
Read the full announcement on our Qlik Innovation Blog.
Thank you for choosing Qlik,
Qlik Support
AI tools are revolutionizing learning analytics in education by automating tasks and personalizing learning experiences. They help educators efficiently analyze dashboards, grade open-ended responses, and tag discussions. An expert from the University of California, Berkeley, emphasizes AI’s role in translating complex data into actionable insights for both educators and students. However, ensuring its responsible deployment is crucial to strike a balance between innovation and accountability, with a strong focus on ethical use.
To explore more about how AI tools are changing “Learning Analytics,” check out the full article here.
To support these advancements, the Qlik Academic Program provides free resources, including software, self-paced training and other learning resources (including qualifications), enabling participants to enhance their data literacy and adopt ethical, impactful approaches to AI and analytics education. To learn how you can access free resources in data analytics as a student or educator, visit www.qlik.com/academicprogram.

Discover work done by your team. Prioritization of your backlog

Easy to Manage your Backlog Backlog Refinement and Analytics

Jira; Agile; DevOps

Using Qlik for backlog management in Jira allows you to visualize and analyze your backlog data, helping you identify trends, prioritize tasks, and make data-driven decisions. This integration enhances your ability to manage and optimize your workflow efficiently.
Qlik Cloud Reporting is just perfect. PixelPerfect.
PixelPerfect Report Authoring is a powerful new template designer enabling precise report authoring. It offers seamless integration with existing reports, data source connectivity, customization options, and collaborative features for creating high-fidelity, visually stunning reports.
In addition to PixelPerfect Authoring, we've put the finishing touches on our cloud reporting capabilities in Q4, introducing:
Thank you for choosing Qlik,
Qlik Support
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.
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.
Before creating the AutoML experiment, let’s define the core elements of our use case:
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)
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.
Now it’s time to visualize the predictions:
Load the Predictions:
Build the Dashboard:
You can experiment with different visualization types to explore the data from multiple perspectives.
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:
There is no doubt that Machine Learning applications have become ubiquitous in today’s world. From using it to solve critical healthcare problems to recommending music/products, we have seen the kind of impact it can have in our daily lives. However, there is a fair cost associated with building ML-based solutions specifically when -
Typically, an ML pipeline would look like this -
Each of these steps is complex and involves spending a crucial amount of time. Also, specific expertise(statistical, software engineering knowledge, etc.) is needed to be able to perform these tasks and ultimately productionize the models to be consumed by end-users. These factors have led to the possibility of automating the pipeline and helping cut down the manual costs.
Organizations today also need to be able to empower teams who are already data literate and leverage data for decision making. Consider a BI Engineer who is already part of the analytics process. Wouldn’t it be great if we can enable them to engineer the features, train & automatically select a robust model and help them deploy it without needing to rely on a team of data scientists & ML engineers? This has given rise to a new role called ‘Citizen Data Scientist’.
These are nascent steps towards the democratization of Machine Learning and can help organizations maximize their data & analytics strategy providing them with a matured analytics team. And this is where Qlik AutoML comes in!
Qlik AutoML is an automated machine learning platform for analytics teams used to generate models, make predictions, and test business scenarios using a simple, code-free experience. I had the opportunity to get my hands-on and the experience has only been promising. In this introductory blog, we will quickly walk through some of the features as part of the ML pipeline while solving a binary ‘classification’ problem.
For this use case, we will use the Breast Cancer Wisconsin (Diagnostic) dataset and our goal is to classify blood cells as ‘benign’ or ‘malignant’. First, we will create our project and load the dataset using the AutoML interface.
Qlik AutoML presents a nice overview of the dataset for exploratory data analysis with information about unique values, null values, min/avg/max, etc.
Since our label is the ‘diagnosis’ field, we will set it as target.
The interface automatically creates a pipeline which by default consists of the preprocessing steps applied by Qlik AutoML such as null value imputation, encoding of categorical values, feature scaling, k-fold cross-validation, etc.
It also presents the list of algorithms based on the selected target label and you will have the option to select/deselect from this list.
Additionally, you can add Hyperparameter optimization into the pipeline that would tell the system to perform a search optimization over multiple parameter settings & models to find the best ones.
To start our training and let Qlik AutoML do its job of finding the best algorithm(good F1 score criteria) we will click on Analyze. As the training process runs, the interface would look like this.
After the training is over, the best candidate is automatically selected by the AutoML system. In our case, Logistic Regression is selected as the best model with an F1 score of 0.951. The analysis results are presented for further drill down. There are 4 key components as seen below.
Let’s quickly take a look at each of these as they are crucial in helping citizen data scientists/analysts understand their model & features.
This view presents Permutation importance, i.e. how much the model performance depends on a feature, and SHAP importance, i.e. how each feature contributes to the predicted outcome.
Permutation importance can be beneficial in refining our model by dropping some of the less important features. In our case, we see that there are a lot of features(left image) that are not important, so will drop them later and refine our model to see if it improves performance.
Similarly, SHAP importance can help us understand the most important features. We know now that ‘texture_worst’, ‘radius_worst’, ‘concavity_mean’, etc. are some of the most important features that impact the decisions.
This view lets us know how each features are correlated to each other in 2 forms — correlation matrix & target correlations.
Fit shows how well Qlik AutoML performed in comparison to the historical data. In our case, looks like the model did pretty well with the predictions.
The final view lets a way to evaluate our model. In a classification problem, typically this can be done by analyzing a ROC curve and Confusion matrix. Qlik AutoML also presents the same plots.
For our Logistic Regression model, the ROC curve looks like below. Classifiers that give curves closer to the top-left corner indicate better performance and we know that our model does great from this.
Next, let’s look at the Confusion matrix.
For our use case, i.e. classifying diagnosis of cancer cells, it is imperative to know the false negatives (i.e. where the predictions incorrectly indicate the absence of a condition when it is actually present). We can see that 3 of them are FN.
If you would like to explore all the models used in the training pipeline, the Model Metrics screen presents all the details. You can also understand the hyperparameters used in a specific model by clicking on a specific model. Here is an example from our Logistic Regression model.
Now, let’s use this analysis and predict on unknown test data(not used in training the model) to see how it performs.
The Create Predictions section allows us to load a test dataset and predict.
Here’s our Prediction analysis.
One of the interesting views in this analysis is the Scenarios where you can modify(increase/decrease) your features and see how it impacts the predictions. Let’s try something in our use case — we will increase the ‘texture_worst’ value and see how the results look.
Qlik AutoML presents a nice visual comparison in the form of grouped bar charts to understand how this scenario change has changed the predictions. Looks like an increase in the ‘texture_worst’ feature leads to more ‘Malignant’ patients.
Once we are satisfied with both training and test analysis, the AutoML system allows us to easily deploy and make a production version of the model via an API(Prediction API) for inferences. You can now integrate this into any workflow or framework that allows you to make HTTPS POST Requests.
This brings us to the end of this introductory blog on Qlik AutoML. My personal experience using the system has been seamless. Here are some key takeaways:
In the next blog, we will deep dive into how to build, deploy and evaluate a Machine Learning model using Qlik AutoML and consume it in Qlik Sense to take advantage of augmented analytics.
~Dipankar, R&D Advocate
Qlik AutoML is a powerful tool that makes it easy for analytics teams to easily generate models, make predictions, and test business scenarios using a code-free experience.
In a previous introductory blog post by Dipankar, you can learn more about how to get started with AutoML and find out just how easy it is to navigate the interface and start training and evaluating ML models in a few steps.
Today, we will leverage the power of Qlik Server-Side Extension (SSE) to build a simple Scenario Analysis dashboard right into Qlik Sense.
“What-if scenarios” are a great way to plan for decisions and actions by testing different parameters while capitalizing on AutoML’s prediction API.
So what is SSE?
Server-side Extension protocol allows us to extend the Qlik built-in expression library with functionality from external calculation engines. In our case, we will use AutoML’s re-calculation of the prediction based on changes on variables to show the result in a KPI chart.
Let’s go through the process in a practical example. We will look at Employee Turnover Risk (dataset attached at the end of the post)
=endpoints.ScriptEvalEx('NNNNNNNSS','{"RequestType":"endpoint", "endpoint":{"connectionname":"Qlik_AutoML_Employee_Turnover","column":"probability_yes"}}',
vSatisfactionLevel AS satisfaction_level,
last_evaluation,
vNumberOfProjects AS number_project,
vAvgMonthlyHoursWorked AS average_montly_hours,
vTimeSpent AS time_spend_company,
Work_accident,
promotion_last_5years,
vDepartment AS sales,
vSalary AS salary)
And that’s all! You can now adjust the variables to trigger AutoML which automatically redistributes the data and re-predicts the outcome in order to understand the implication of any potential action.
Below, notice that Employee #2 has a high turnover %. Upon adjusting the “Avg Monthly Hours Worked”, “Number of Projects”, and “Salary” or a combination of these parameters, the % drops drastically.
Attached is the dataset used as well as the qvf.
I hope you found this post helpful!
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

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

Streamlines root cause analysis by delivering deeper insights straight away.

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

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) <<
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:
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.
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
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.
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.
Note: If you have the previous version installed, deactivate and delete it before installing the new one to avoid conflicts.
Before using the plugin, you'll need to set up OAuth impersonation in your Qlik Cloud tenant.
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)
https://your-tenant.region.qlikcloud.com.With the plugin configured, you can now embed Qlik Cloud content using Shortcodes.
Use the [qlik-embed-app] shortcode:
[qlik-embed-app appid="1234-c56a-4062-ac50-377bba443e85" sheetid="12345-698f-449f-9a17-dca17eeadb71"]
Parameters:
Use the [qlik-embed-object] shortcode:
[qlik-embed-object appid="1234-64317-8432" objectid="1234-5553-326432"]
Parameters:
Use the [qlik-embed-selections] shortcode:
[qlik-embed-selections appid="1234-c56a-4062-ac50-377bba443e85"]
Parameters:
Tip:
/sheet/
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!
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:
Click on this link to watch the recording.