Hear directly from Qlik employees in our ten unique blogs.
This forum was created for professors and students using Qlik within academia.
Learn about what's new across all of the products in our growing Qlik product portfolio.
Important and useful support information about end-of-product support, new service releases, and general support topics.
All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.
Updates about Qlik Community Platform as well as news and announcements.
On this forum you can access and follow the latest updates of our courses and programs with the Qlik Education team.
All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.
Information on all new product releases, connectors, beta programs, and technical product information.
Deep dives into specific back-end technologies which allow for the extension of Qlik to fit the needs of the enterprise.
All about Qlik's Voice of the Customer program and Customer Success initiatives
Learn about what's new in the Qlik Product Insight & Ideas forum.
Hello Qlik Users!
How can I track the usage of my Tenant over time? How are my entitled users using the Tenant?
How can I better understand the usage of Analyzer Capacity vs. Analyzer & Professional Entitlements?
These are a couple of the questions we frequently hear. To enable you to find better answers for those, we are happy to share with you the new Entitlement Analyzer for Qlik Sense Enterprise SaaS!
The Entitlement Analyzer will help answer those questions and more! The app provides insights on:
The Entitlement Analyzer uses a new API Endpoint to fetch all the required data and will store the history in QVD files to enable even better Analytics over time.
A few things to note:
The app as well as the configuration guide can be found at the bottom of this post. This app was created internally and will be supported by the developers of the app. They will be following this thread so be sure to post any questions or issues here so they can be addressed.
Be sure to subscribe to the Qlik Support Updates Blog by clicking the green Subscribe button to stay up-to-date with the latest Qlik Support announcements. Please give this post a like if you found it helpful!
Qlik Digital Support Team
For various and valid reasons, you might need to migrate your entire Qlik Sense environment, or part of it, somewhere else.
In this post, I’ll cover the most common scenario: a complete migration of a single or multi-node Qlik Sense system, with the bundled PostgreSQL database (Qlik Sense Repository Database service) in a new environment.
So, how do we do that?
Introduction and preparation
Let’s start with a little bit of context: Say that we are running a 3 nodes Qlik Sense environment (Central node / Proxy-Engine node / Scheduler node).
On the central node, I also have the Qlik shared folder and the bundled Qlik Sense Repository Database installed.
This environment has been running well for years but I now need to move it to a brand new hardware ensuring better performance. It’s not possible to reinstall everything from scratch because the system has been heavily used and customized already. Redoing all of that to replicate the environment is too difficult and time-consuming.
I start off with going through a checklist to verify if the new system I’m migrating to is up to it:
And then I move right over to…
Backup your old environment
The first step to migrate your environment in this scenario is to back it up.
To do that, I would recommend following the steps documented on help.qlik.com (make sure to select your Qlik Sense version top left of the screen).
Once the backup is done you should have:
Then we can go ahead and…
Deploy and restore the new central environment
The next steps are to deploy and restore your central node. In this scenario, we will also assume that the new central node will have a different name than the original one (just to make things a bit more complicated 😊).
Let’s start by installing Qlik Sense on the central node. That’s as straightforward as any other fresh install.
You can follow our documentation. Before clicking on Install simply uncheck the box “Start the Qlik Sense services when the setup is complete.”
The version of Qlik Sense you are going to install MUST be the same as the one the backup is taken on.
Now that Qlik Sense is deployed you can restore the backup you have taken earlier into your new Qlik Sense central node following Restoring a Qlik Sense site.
Since the central node server name has also changed, you need to run a Bootstrap command to update Qlik Sense with the new server name. Instruction provided in Restoring a Qlik Sense site to a machine with a different hostname.
The central node is now almost ready to start.
If you have changed the Qlik Share location, then the UNC path has also changed and needs to be updated.
To do that
At this point make sure you can access the Qlik Sense QMC and Hub on the central node. Eventually, check that you can load applications (using the central node engine of course). You can also check in the QMC -> Service Cluster that the changes you previously made have been correctly applied.
Troubleshooting tips: If after starting the Qlik Sense services, you cannot access the QMC and/or Hub please check the following knowledge article How to troubleshoot issue to access QMC and HUB
What about my rim nodes?
You’ve made it here?! Then congratulation you have passed the most difficult part.
If you had already running and configured rim nodes in your environment that you now need to migrate as well, you might not want to remove them from Qlik Sense to add the new ones since you will lose pretty much all the configuration you have done so far on these rim nodes.
By applying the following few steps I will show you how to connect to your “new” rim node(s) and keep the configuration of the “old” one(s).
Let’s start by installing Qlik Sense on each rim node like it was a new one.
The process is pretty much the same as installing a central node except that instead of choosing “Create Cluster”, you need to select “Join Cluster”
Detailed instruction can be found on help.qlik.com - Installing Qlik Sense in a multi-node site
Once Qlik Sense is installed on your future rim node(s) and the services are started, we will need to connect to the “new” Qlik Sense Repository Database and change the hostname of the “old” rim node(s) to the “new” one so that the central node can communicate with it.
To do that install PGAdmin4 and connect to the Qlik Sense Repository Database. Detailed instruction in Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinting knowledge article.
Once connected navigate to Databases -> QSR -> Schemas -> public -> Tables
You need to edit the LocalConfigs and ServerNodeConfigurations table and change the Hostname of your rim node(s) from the old one to the new corresponding one (Don’t forget to Save the change)
Once this is done, you will need to restart all the services on the central node.
When you have access back, login to the QMC and go to Nodes. Your rim node(s) should display the following status, “The certificate has not been installed”
From this point, you can simply select the node, click on Redistribute and follow the instruction to deploy the certificates on your rim node. After a moment the status should change and you should see the services being up and running.
Do the same thing on the remaining rim node(s).
Troubleshooting tips: If the rim node status is not showing “The certificate has not been installed” it means that either the central node cannot reach the rim node or the rim node is not ready to receive new certificates.
Check that the port 4444 is opened between the central and rim node and make sure the rim node is listening on port 4444 (netstat -aon in command prompt)
Still no luck?! You can completely uninstall Qlik Sense on the rim node and reinstall it.
Finalizing your migration
At this point, your environment is completely migrated and most of the stuff should work.
There is one thing to consider in this scenario. Since the Qlik Sense certificates between the old environment and the new one are not the same, it is likely that data connections with passwords will fail. This is because passwords are saved in the repository database with encryption. That encryption is based on a hash from the certs. When the Qlik Sense self-signed cert is rebuilt, this hash is no longer valid, and so the saved data connection passwords will fail. You will need to re-enter the passwords in each data connection and save. This can be done in the QMC -> Data Connections.
See knowledge article: Repository System Log Shows Error "Not possible to decrypt encrypted string in database"
Do not forget to turn off your old Qlik Sense Environment. As per your license agreement, you can only use one license per active Qlik Sense environment. Reach out to your account manager for more details.
Finally, don’t forget to apply best practices in your new environment:
Thank you for reading my blog post and I really hope it helps you. This is the first part of a post covering multiple migration scenarios. Coming soon, I will explain how to migrate your PostgreSQL Database from the bundled Qlik Sense Repository Database to a dedicated PostgreSQL Instance.
I’ll be watching for your questions, feedback or suggestions so please comment and share (and like if you liked 😊)!
Increasingly, students enrolled into the Qlik Academic Program have at their disposal various opportunities to forward their career. Students are securing internships and jobs within Qlik and with customers and partners of Qlik across the globe.
The academic program provides free resources in the form of online training, qualifications and certification to students and professors. The program offers structured pathways to become a Qlik Sense Business Analyst and Qlik Sense Data Architect after which students can appear for the exams and get their certifications. This program has been quite popular with more than 26,000 students from 2400+ Universities leveraging these free resources. Being industry developed makes it more relevant to the market demands.
Relationship between National University of Singapore ( NUS) has been thriving and students from National University of Singapore (NUS) have enrolled into the program quite regularly. The Singapore office of Qlik has recruited from the University which has resulted in a successful partnership between Qlik and NUS. The academic program continued to build engagement with NUS with various initiatives.
Another recent example is that of Sri Vishnu Educational Society ( SVES) in India which has more than 250 students and Professors enrolled into the Qlik Academic Program. Data analytics start up Diagonal wanted to recruit Qlik trained students for its expansion plans. The company consults technology clients in data analytics and for its projects and they wanted students who are up to speed in analytics and Qlik technologies so that they could be deployed on their projects immediately. The academic program was supportive of this initiative and facilitated the engagement between BVRIT and Diagonal.
Qlik has an R&D Centre in Bangalore and they have a continuous requirement of qualified candidates. Recently, they advertised their requirement for interns for their R&D projects. These projects are great opportunities for students to learn latest advancements in analytics technologies and fast forward their career. With the help of the academic program, the R&D team at Qlik are able to meet their requirements.
Many such opportunities are sprouting for students across the globe and the Qlik Academic Program continues to bridge the skills gaps for analytics trained resources. If you are a student or Professor and wish to know about the academic program and learn from its free resources, visit: qlik.com/academicprogram or email: email@example.com
Several years ago, I blogged about how I used IntervalMatch to create a profit and loss statement. Now that Qlik Sense has the P&L Pivot chart extension in the visualization bundle, I decided to test out the extension to see how it may help create a P&L report in Qlik Sense. This blog will review some of my findings and what was involved to create the P&L Pivot chart shown below.
The P&L Pivot chart extension provides a lot of properties that allow you to change the style and coloring in the chart. You can find a complete list of the properties here in Qlik Help. The chart above uses one dimension and 6 measures but I could have used up to 9 measures with my single dimension or used 2 dimensions and up to 8 measures. After loading the data into Qlik Sense, my next step was to create a style template that I could use to handle the formatting of the chart. Here is a snapshot of the template in Excel:
I added a header row so that I could easily see what options I could set but it is not required and can be omitted. In the styling template, Column A should include the data that is in the first dimension of the chart you will be applying the template to. Note that this data is case sensitive. The other columns have the various styles that can be modified via the template.
Here is an example of the same template in a CSV file.
If a template is used, it needs to be loaded via the script. Here is how you can load the Excel and CSV versions of the templates:
The key in both scripts is that the entire template needs to be loaded into one field which can later be selected from the Style template field drop down in the Properties window of the P&L Pivot chart. In the Excel script, the styles are concatenated into one field separated by semi-colons. In the CSV file, the file format is set to Fixed record to load all the data into one field. Note that the name that you give the field in the script will be the template name you select from the Style template field drop down.
Each row of the template should have this format:
Check Qlik Help to see the default and styling options that are available in the styling template.
There are many additional properties that can be set in the properties window of the P&L Pivot chart extension. I kept many of the defaults but here are some that I changed. In the Table Format section of the Properties, I checked Indent to indent the P&L Heading. The columns can be narrow so I moved the Column width slider all the way to the right, (for max width), and changed the Font family so that I could see as much of the numeric values in the chart as possible. I tweaked the header coloring in the Header format section. I opted not to color variances below 0% red because then I would lose some of my styling template changes. While I used a styling template in my example, you do not have to. The P&L Pivot chart extension can be styled via the Properties window without using a template.
The P&L Pivot chart extension provides a ton of styling options that can be used to easily make your profit and loss statement looks exactly the way you want. It is worth checking out or you can watch this video to learn more.
Welcome to the 2nd part of developing a Visual Text Analytics app using Qlik’s open-sourced solutions and a Word embedding technique(Word2Vec). In our previous tutorial , we designed a simple architecture(seen below) for the application that we will learn to develop today.
Qlik Full-stack? APIs? Machine Learning?
If these topics sounds interesting to you, this series(Part-1 & 2) might be your starting point.
Today, we are going to talk about one particular area within Visual Analytics i.e., Visual Text Analytics. This tutorial will focus on the nitty-gritty of this area of research and in my next post, I will do a step-by-step tutorial of how you can actually develop the application.
With the surge in the generation of digital text on the web in the form of product reviews, descriptions, feedback, etc., there has been a demand for leveraging text mining techniques to understand and analyze these unstructured data. Typically organizations would like to be able to identify patterns, specific keywords(that make an impact), similarities, etc. through text mining. However, the challenge in analyzing hidden patterns from a large noisy text corpora can be huge and at times daunting for analysts. To mitigate the challenge in the discussion, this research area aims to bring text mining, text visualization, and Human-Computer interaction together to make sense of the data.
In the past, I have built a couple of Visual Text Analytics applications using technology stack such as - D3.js, Plotly/Dash, Python Flask(for APIs), etc., and thought it might be interesting to try developing an app using Qlik Sense’s open-sourced solutions. Primarily, for this blog, we will be looking at two of Qlik’s frameworks - Nebula.js and Picasso.js. If you are not aware of them, here is a quick gist:
Hello Qlik Users!
Next Tuesday, July 27th at 10 am Eastern we will be having a Talk to Experts Tuesday session on Qlik Sense Mobile! You can register for the event here:
Product Manager, @Caique_Zaniolo, will be on the call along with others from Qlik Support, Professional Services and Marketing!
You could also win some Qlik SWAG! Join us during the session to find out how.
What questions do you have about Qlik Sense Mobile? Let me know in the comments below! We hope to see you on the call!
We hope to see you there!
Qlik Digital Support
Bonus: the new registration page allows you to register for the August 24th session on Qlik Gold client too!
Happy Tuesday Qlik Community!! This week on the Design Blog I have the pleasure of introducing our newest guest blogger, Lee Matthews. Lee comes to us from the opposite side of the world, well at least from where I am anyway. I mean really, as I get ready for winter he is getting ready for summer. Lee is a Principal Solution Architect with Qlik and is based in Melbourne, Australia. He joined Qlik in 2011 but has been working in the Business Intelligence field with various ERP and CRM vendors for over 20 years. Prior to that he was a management accountant. He therefore has a long history of working with data and reporting systems for organizations. When not tinkering with Qlik applications for clients, he enjoys tinkering with robots, making things out of wood and teaching these skills to his two boys. We are excited to have your contribution on the Design Blog Lee!
Effectively managing your projects with Qlik Sense
As a Solution Architect with Qlik I get the opportunity to work with many different organizations and to show them how Qlik can solve their problems and add value to their business. One common problem I see across larger enterprises is the need to effectively manage projects and to monitor resourcing for those projects. Often the reporting capability of project management systems is limited, or reporting across the entire portfolio of projects is something they are not designed to do.
This is where Qlik can add great value, in answering questions such as:
Below is a video I created that demonstrates a Project Portfolio Management application while covering many of the unique and powerful capabilities available in Qlik Sense. This application was developed as an example of how you might use Qlik Sense to analyze your entire project portfolio. It takes some concepts and approaches that different clients use in their businesses. Also worth highlighting is that this app uses a custom KPI object developed using the Widgets functionality built into Qlik Sense. Widgets allow you to develop your own visualizations with just a bit of HTML and CSS. You can learn more about Widgets in this quick video primer created by Mike Tarallo here: Qlik Sense 3.0 - Widget
(I attached this widget for you to play with. If using Qlik Sense Desktop 3.X, just extract the .zip file to your C:\Users\<user_id>\Documents\Qlik\Sense\Extensions directory. Qlik Sense Enterprise Server users will want to use the QMC to import the widget using the Extensions import utility.)
Using Qlik Sense for Project Portfolio Management
NOTE: To increase resolution or size of the video, select the YouTube logo in the bottom right of the player. You will be brought directly to YouTube where you can increase the resolution and size of the player window. Look for the 'settings' gears icon in the lower right of the player once at YouTube. If you cannot see the video, you can download the .mp4 file attached to this post.
Yesterday the Qlik Academic Program ran a workshop for students at the University of Alcalá in Spain to get their first experience with Qlik Sense. A group studying for master’s degrees in Data Science and Business Intelligence participated in the hands-on workshop which focused on a case study using Qlik in a fictitious retail company. The Head of Sales, Marketing, IT and the CEO all had questions that they wanted the data to answer, so the students were tasked with creating a Qlik Sense application and story to meet the various stakeholder’s requirements. Also, at the end of the session the students participated in a quick fire Kahoot quiz to test their abilities to make quick discoveries in their data using Qlik Sense.
For many of the students, this session was their first introduction to Qlik, so they were provided with a written step by step guide to the exercise, plus a live demo by Qlik instructor Sara Del Pino, with support from Laura Gutierrez. These sessions are a great way for students to get practise using Qlik Sense with guidance from experts. Also they are a good opportunity for students to experience the types of requirements that they could face in a business analyst position.
Did you know that Qlik hosts a Build Your First Qlik Sense App webinar every week? These sessions are completely free of charge, hosted by our brilliant instructors and a great introduction for anyone starting out with Qlik.
If you are a university student or educator you can also join our Qlik Academic Program for free, to get access to Qlik Sense software, training and qualifications as well as access to our live webinar series. For more information or to sign up visit qlik.com/academicprogram.
Hello Qlik Users,
As of Wednesday, there are three new Qlik Sense Enterprise on Windows patches available on the Qlik download site:
Qlik Sense Patch
May 2021 Patch 4
February 2021 Patch 10
November 2020 Patch 15
A link to an article lists the resolved defects for the corresponding Qlik Sense Enterprise on Windows patch. Release Notes are linked above but can also be found on the Release Notes page here in the Qlik Community.
Also, I wanted to let you all know there will not be any patches released on July 28th or August 11th. The normal patch schedule will resume on August 25th as will the Qlik Patch Wednesday blog.
Be sure to subscribe to the Qlik Support Updates Blog by clicking the green Subscribe button to stay up-to-date with the latest releases. Please give this post a like if you found it helpful and let us know if you have any questions using the comments below.
Thank you for choosing Qlik!
Qlik Global Support
Task chaining is here! We are delighted to announce that one of the most requested features for Qlik NPrinting is now available with our February 2018 release.
If you thought that Qlik NPrinting 17 triggers were only time-based and prevented you from creating event-based dependencies on other Qlik tasks, (such as app and data reloads) then think again. This functionality is now available out-of-the-box using the Qlik NPrinting APIs and a Qlik load script!
You can now seamlessly run tasks that represent the typical workflow for a Qlik NPrinting report. Using the publicly available APIs, you can reload Qlik NPrinting connection metadata, update user information and run a publish task, all following a Qlik data and/or app reload.
You can also institute a poling mechanism to ensure that one task is complete before starting a subsequent one.
The technical details and examples can be found here: https://community.qlik.com/thread/292037 (even though the example uses Qlik Sense, this can be done just the same in a QlikView load script).
Please note that this functionality was made possible by the resolution of a bug related to the Qlik REST connector. You will need the REST connector v1.3 which is part of the February 2018 release of Qlik Sense, or it can be downloaded separately and copied over the old REST connector.
Our long-term vision for reporting involves exposing the Qlik NPrinting tasks in the QMC, however this is a first major step toward integrated scheduling
Hello Qlik Users!
Based upon alignment to the strategy of the wider Qlik portfolio, Qlik has made the difficult decision to retire:
We will continue to support these products until the retirement date – January 31, 2022. You can continue to renew your support agreements, through the retirement date. However, renewal support agreements will not go beyond January 31, 2022, even if this is shorter than your normal support renewal period. Existing support agreements that expire after the retirement date will be honored; these agreements are not eligible for renewal.
Support for any additionally purchased licenses will not extend past January 31, 2022.
Please contact your Qlik sales representative if you have any questions or let us know in the comments below and we can route them to the appropriate people if necessary.
Please subscribe to the Qlik Support Updates Blog by clicking the green ‘Subscribe’ button if you haven’t already. Let us know that you read this post by giving it a like!
Qlik Global Support