Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This space offers a variety of blogs, all written by Qlik employees. Product and non product related.
Product Innovation
By reading the Product Innovation blog, you will learn about what's new across all of the products in our growing Qlik product portfolio.
Support Updates
The Support Updates blog delivers important and useful Qlik Support information about end-of-product support, new service releases, and general support topics.
Qlik Academic Program
This blog was created for professors and students using Qlik within academia.
Community News
Hear it from your Community Managers! The Community News blog provides updates about the Qlik Community Platform and other news and important announcements.
Qlik Digest
The Qlik Digest is your essential monthly low-down of the need-to-know product updates, events, and resources from Qlik.
Qlik Education
The Qlik Education blog provides information about the latest updates of our courses and programs with the Qlik Education team.
Recent Blog Posts
-
Qlik Account logins impacted by Auth0 outage
Hello Qlik Users!Update as of 4:13 pm EDT on 4/20/2021 - We are receiving reports that the service is restored. Qlik is continuing to monitor. Auth0, a partner of Qlik’s, is currently experiencing an outage impacting Qlik Cloud Services. Customers using Qlik Accounts to login into their tenant are having issues logging in at this time.Qlik is closely monitoring the situation and will keep you posted as more information becomes available. Please s... Show MoreHello Qlik Users!
Update as of 4:13 pm EDT on 4/20/2021 - We are receiving reports that the service is restored. Qlik is continuing to monitor.
Auth0, a partner of Qlik’s, is currently experiencing an outage impacting Qlik Cloud Services. Customers using Qlik Accounts to login into their tenant are having issues logging in at this time.
Qlik is closely monitoring the situation and will keep you posted as more information becomes available. Please subscribe to the Qlik Status page to receive updates on the issue. View Auth0’s status page for more details on the outage.
Customers using their own IDP are not affected by this outage.
Kind regards,
Qlik Digital Support
-
Qlik Web Connectors Patch available for Google Spreadsheet Connector Issue
Hello Qlik Users!Last week, an issue was identified with the Google Spreadsheet Connector for Qlik Web Connectors and Qlik Sense Enterprise SaaS.A patch is now available for Qlik Web Connectors, Qlik Web Connectors December 2020 Patch 2. The patch can is on the Downloads site, along with the release notes. Please review the release notes before upgrading and follow the documentation for upgrading Qlik Web Connectors.To resolve the issue, GetWorks... Show MoreHello Qlik Users!
Last week, an issue was identified with the Google Spreadsheet Connector for Qlik Web Connectors and Qlik Sense Enterprise SaaS.
A patch is now available for Qlik Web Connectors, Qlik Web Connectors December 2020 Patch 2. The patch can is on the Downloads site, along with the release notes. Please review the release notes before upgrading and follow the documentation for upgrading Qlik Web Connectors.
To resolve the issue, GetWorksheetV2 was added to the list of tables. GetWorksheetV2 or GetSheetValues should be used going forward as GetWorksheet is now deprecated.
A fix was pushed to Qlik Sense Enterprise SaaS on Friday, May 7th, resolving the issue.
Please let us know if you have any questions using the comments below.
Thank you for choosing Qlik!
Kind regards,
Qlik Digital Support
-
Techspert Thursdays - Top 10 Visualization Tips for Qlik Sense Enterprise
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 our Qlik Support Experts.The Support Techspert Thursday session from May looked at at Top 10 Visualization Tips for Qlik Sense Enterprise. But wait, what is it exactly?Support Techspert Thursdays is a free webinar to facilitate knowledge sharing held on a monthly basis, on the third Thursd... Show MoreHi 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 our Qlik Support Experts.
The Support Techspert Thursday session from May looked at at Top 10 Visualization Tips for Qlik Sense Enterprise.
But wait, what is it exactly?
Support Techspert Thursdays is a free webinar to facilitate knowledge sharing held on a monthly basis, on the third Thursday of each month.
Hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today.In this session we will cover:
• Deep dive into visualizations
• Demonstration of most effective charts
• How to exploit controls to the maxClick on this link to see the presentation
-
Registering for Events via Qlik Community
Qlik Community is more than just your average online community. We are a true 'hub' destination wanting to connect our members to other members but also to help you navigate the Qlik ecosystem. Over the past two years we have seen a massive spike in interest that the community be more than just Q&A. While we certainly get that you come here primarily to have questions answered there is more to do here. This article is focused on raising aware... Show MoreQlik Community is more than just your average online community. We are a true 'hub' destination wanting to connect our members to other members but also to help you navigate the Qlik ecosystem. Over the past two years we have seen a massive spike in interest that the community be more than just Q&A. While we certainly get that you come here primarily to have questions answered there is more to do here.
This article is focused on raising awareness to the Events area within the Qlik Community. Plus I hope to leave you with a laugh or two. Read on members!
I'll fill you in on a little secret, we do NOT promote ALL Qlik events on the community. In fact, many that hit our desk are just not a good fit. We make daily decisions on which events to promote here and have no intention to bombard you with content just because we have a page to do it.
If you have not yet visited our Events and Webinar page, please do - you may uncover something of interest. You can subscribe to the page to receive notifications. Tell us what you think of the Events & Webinars page in the comments- the good, the bad, the ugly - we can handle it! In the future we plan to connect the dots better; the intent is to bring event information to the forums where you spend your time - with no need to subscribe elsewhere.
Speaking of events, have you registered for QlikWorld Online 2021 yet? We wish we could see you in person this year but it is what it is. What I can tell you with certainty is this... the Qlik Events team put their heart and soul to ensure an incredible event experience. So register now if you haven't already.
Register here for QlikWorld Online 2021
To prepare for QlikWorld I was asked to prepare a video 😲 for the Qlik Community booth. While I have to save the final video for the actual event I can share my BLOOPER video 🤣🤣 If you can't laugh at yourself who can you laugh at?
See you online !
Melissa Potvin
Director, Qlik Community
-
Inphinity & Qlik - Carbon Footprint Simulator
If you'd like to know more, let us know. 😉 -
12 Steps to configure QSEoW after an Active Directory Domain name change
Hello Qlik Users!Are you changing your company’s Active Directory Domain name? If so, you will want this article that explains the 12 steps to successfully configure Qlik Sense Enterprise on Windows after the domain name change!Qlik Sense and changing the Active Directory Domain nameSome of the steps may not be required if you used “localhost” or the server name without any reference to the domain. If possible, review this article prior to the Ac... Show MoreHello Qlik Users!
Are you changing your company’s Active Directory Domain name? If so, you will want this article that explains the 12 steps to successfully configure Qlik Sense Enterprise on Windows after the domain name change!
Qlik Sense and changing the Active Directory Domain name
Some of the steps may not be required if you used “localhost” or the server name without any reference to the domain. If possible, review this article prior to the Active Directory Domain name change so your team is aware of what is required on the Qlik Sense Enterprise on Windows side.
I hope everyone has a wonderful weekend!
Kind regards,
Qlik Digital Support
-
How to find technical breakout sessions during QlikWorld
Hello Qlik Users! QlikWorld starts Monday, May 10th! Have you signed up for any breakout sessions yet? You can easily filter the sessions for a list of technical sessions or technical workshops. First, make sure you are registered for QlikWorld. Then go to the Breakout Sessions page and scroll down to the list of sessions. Under Track, select Technical and Technical Workshops. You can also filter by Featured Product or search for your favorite ... Show MoreHello Qlik Users!
QlikWorld starts Monday, May 10th! Have you signed up for any breakout sessions yet? You can easily filter the sessions for a list of technical sessions or technical workshops.
First, make sure you are registered for QlikWorld. Then go to the Breakout Sessions page and scroll down to the list of sessions. Under Track, select Technical and Technical Workshops.
You can also filter by Featured Product or search for your favorite speaker!
I recommend favoriting the sessions you are interested in. You will need the codes in the description to locate the session during QlikWorld.
What sessions do you currently have favorited?
Thank you for choosing Qlik!
Kind regards,
Qlik Digital Support
-
QlikWorld 2021 May 10-12, 2021 Free Virtual Event
Learn. Connect. Be inspired. Join this unique data integration and analytics conference.QlikWorld is a global annual conference dedicated to the latest advancements of data integration and data analytics. Qlik's online event features scheduled keynote presentations, interactive sessions with thought leaders and subject matter experts, and product demonstrations. QlikWorld is your chance to discover how you can activate your data to drive business... Show MoreLearn. Connect. Be inspired. Join this unique data integration and analytics conference.
QlikWorld is a global annual conference dedicated to the latest advancements of data integration and data analytics. Qlik's online event features scheduled keynote presentations, interactive sessions with thought leaders and subject matter experts, and product demonstrations. QlikWorld is your chance to discover how you can activate your data to drive business forward. And the best part? It’s free – and you can join from any device.
-
Join me for a live Academic Program webinar
Free software and training for university students!
-
Ideation and QlikWorld - A Unique Experience
Check out Qlik Ideation, a program where Qlik collects and analyzes feedback from our community of product enthusiasts to help shape product direction based on real customer requirements. If you are already familiar with the forum, be sure to Register for QlikWorld to access a unique experience for Ideation within the Data Analytics, Data Integration, and Active Intelligence Expo Centers. -
Introducing Qlik Sense Mobile for SaaS – Analytics at the point of Decision.
Today we are excited to introduce Qlik Sense Mobile for SaaS, a new, fully native app for iOS and Android that provides an enhanced user experience, fully interactive online and offline analysis, and integrated push alerting to drive action at the point of decision. The Qlik Sense mobile app can be downloaded to your device from the Apple App Store on iOS or the Google Play store on Android. With this new app, users can drive action at the poi... Show MoreToday we are excited to introduce Qlik Sense Mobile for SaaS, a new, fully native app for iOS and Android that provides an enhanced user experience, fully interactive online and offline analysis, and integrated push alerting to drive action at the point of decision. The Qlik Sense mobile app can be downloaded to your device from the Apple App Store on iOS or the Google Play store on Android. With this new app, users can drive action at the point of decision, moving from passive to active BI.
-
New updates to SaaS editions of Qlik Sense!
Hello Qlik Users!Did anyone see the new updates to SaaS editions of Qlik Sense that dropped yesterday?Features and improvements include:New security roles that allow users that are not tenant administrators or Professional users the ability to create shared or managed spacesEnhancements to the Insight Advisor chat that improve narratives in question responses, refine the user interface for question parsing and more intelligent app selection when ... Show MoreHello Qlik Users!
Did anyone see the new updates to SaaS editions of Qlik Sense that dropped yesterday?
Features and improvements include:
- New security roles that allow users that are not tenant administrators or Professional users the ability to create shared or managed spaces
- Enhancements to the Insight Advisor chat that improve narratives in question responses, refine the user interface for question parsing and more intelligent app selection when responding to questions
- Microsoft SharePoint has been added as a Storage Provider in Data Connections
- Administrators have the option to let users provide their own credentials when using specific connectors
The most exciting highlight of the release is the new Qlik Sense Mobile for SaaS app for iOS and Android! It is exclusively for SaaS users (client-managed users should stick with the Qlik Sense Mobile app) and connects directly to your tenant to give you insights on the go! You can see more information and a demo of the app on the Product Innovation Blog. There is also a FAQ that addresses common questions.
The Qlik Sense SaaS in 60 videos are available in the Connect and Learn button within your tenant. The videos review some of the above features and other enhancements that have been made within the past few weeks. Be sure to check those out!
If you have any questions, please let me know in the comments below.
Thank you for choosing Qlik!
Kind regards,
Qlik Digital Support
-
Qlik Learning Portal User Tours
We have recently added walk-through tours on our Qlik Learning Portal home page and My Learning Dashboard to improve the first-time user experience.
-
covid vaccine availability in Maharashtra
This apps helps people to get better decision on how, where and at what time to get vaccination. It also helps to people to identify which is nearest location from them get vaccination. -
Issue identified with Google Spreadsheet Connector
Hello Qlik Users!An issue has been identified with the Google Spreadsheet Connector when using “GetWorksheet”. The issue affects:Qlik Web Connectors December 2020Qlik Sense BusinessQlik Sense Enterprise SaaS Two error messages can occur, depending on the platform.Qlik Web Connectors on-premise error message<Exception>APIConnectorInterfaces.Exceptions.APIConnectorException: Failed on attempt 1 toGET. (The remote server returned an error: (400) Bad... Show MoreHello Qlik Users!
An issue has been identified with the Google Spreadsheet Connector when using “GetWorksheet”. The issue affects:
- Qlik Web Connectors December 2020
- Qlik Sense Business
- Qlik Sense Enterprise SaaS
Two error messages can occur, depending on the platform.
Qlik Web Connectors on-premise error message
<Exception>APIConnectorInterfaces.Exceptions.APIConnectorException: Failed on attempt 1 toGET. (The remote server returned an error: (400) Bad Request.) ---> System.Net.WebException: Theremote server returned an error: (400) Bad Request.
Qlik Cloud Services error message
HttpStatusCode: BadRequest, StatusCode: 400, StatusDescription: Bad Request, Message: The remote server returned an error: (400) Bad Request., ResponseBody: Error 400 (Bad Request)!!1
There is currently a workaround, which you can find in the article:
R&D is currently investigating the issue. Qlik Support will update the article with information as it comes in.
Kind regards,
Qlik Digital Support
Edited to add: There is also the Known Issues for Qlik Sense SaaS article. Please bookmark this page to use for future reference.
Update 5/6/2021 at 9:45 am EDT: Qlik is developing an update to the Connector package to use an improved getWorksheetmethod. We expect the update to be available Monday. When the update is released, we will also post instructions on how to move to the new method, along with considerations for testing.
Update 5/11/2021 at 9:04 am EDT: A fix was pushed out to Qlik Sense Enterprise SaaS on Friday, May 7th. A patch is now available for Qlik Web Connectors. Please see Qlik Web Connectors Patch available for Google Spreadsheet Connector Issue for more information.
-
Community Enhancements (2021 - 3)
In this release we offer a refreshed look and feel to Qlik Gallery and a new page showcasing our Featured Members.
-
Connecting Multiple Calendar Date Fields in a Qlik Sense App Using Linked Tables
In today's blog and video, Qlik Solution Architect Tomilayo Komolafe (Tomi) is back providing real in-the-trenches solutions to real customer problems. How does one do analysis with multiple date fields?Here is the scenario:Customer had multiple date fieldsOne primary key is related to multiple date fieldsI was recently working with a prospect in the quality assurance (QA) space. The customer had an interesting problem on his hands. Whenever a Q... Show MoreIn today's blog and video, Qlik Solution Architect Tomilayo Komolafe (Tomi) is back providing real in-the-trenches solutions to real customer problems.
- How does one do analysis with multiple date fields?
Here is the scenario:
- Customer had multiple date fields
- One primary key is related to multiple date fields
I was recently working with a prospect in the quality assurance (QA) space. The customer had an interesting problem on his hands. Whenever a QA event arises in his team, a QA number is generated. However, each QA #, at some point, would have a Date Identified, Date Initiated, Date of Occurrence, and Date Closed field. He was stumped on how to perform analysis on his data with these multiple date fields. For example, if he wanted to know how many events were Identified, Occurred, and Closed, in August 2020, how could he do this? He knew he would need some arbitrary master calendar that connects all these date fields together. (For a great explainer video on Master Calendar - check out this video from my colleague Mike Tarallo . It is slightly older but still valid in this scenario and explains the Master Calendar concept in an easy to understand manner. )
NOW....that’s not all, my customer still needed a way to relate all the four date field types to the master calendar. We resolved his problem using Link Tables and my video below goes through how this can be implemented. In this example, I am playing the role of a retailer, think of Amazon, whom for any order generated with some Order ID number, there would be multiple dates related to this order. The dates here are OrderDate, InvoiceDate, ShippedDate, and ArrivalDate. Watch how easy Qlik makes analyzing this data set easy.
Watch this video to learn more and see how we solved it:
Can't see the video? YouTube blocked by your region or organization? Download the .mp4 files to watch on your computer or mobile device.
See more of Tomi's posts:
-
Getting all data cells from app.createCube()
As I was working on one of my latest mashups, I had a task, to get all cells with numerous sets of dimensions and measures, with a HyperCube out of Qlik Sense. The worst part is that one of my sets, had a total of 3+ million cells! We know that the initial HyperCube returns only up to ~10k cells, So the question is how do we paginate to get the rest or even get them all in one call! We also know that, most of the Capability API methods are using ... Show MoreAs I was working on one of my latest mashups, I had a task, to get all cells with numerous sets of dimensions and measures, with a HyperCube out of Qlik Sense. The worst part is that one of my sets, had a total of 3+ million cells!
We know that the initial HyperCube returns only up to ~10k cells, So the question is how do we paginate to get the rest or even get them all in one call!
We also know that, most of the Capability API methods are using promises, something very helpful, especially if we make a lot of calls to Qlik Sense and expect to return the results only when all of the promises have been resolved. This is where promises “.all()” come into play.
Even though ES6 has promises build in, not all browsers support it yet, so I will use Angular's $q to handle those promises.
First we have to make the initial call and get the maximum rows and columns. We start by creating the cube with the dimensions
app.createCube({
qDimensions : qDimensions,
qMeasures : qMeasures
}).then(function(model) {
Once we have the model ready, we make the initial call to get the first set of results and get the HyperCube info like total columns and total rows
model.getHyperCubeData('/qHyperCubeDef', [{qTop: 0, qWidth: 20, qLeft: 0, qHeight: 500}]).then(function(data) {
Once we have that we can determine how many total pages do we have
var columns = model.layout.qHyperCube.qSize.qcx;
var totalheight = model.layout.qHyperCube.qSize.qcy;
var pageheight = Math.floor(10000 / columns);
var numberOfPages = Math.ceil(totalheight / pageheight);
Now, if we got all of the results, we should end the method and return those results
if (numberOfPages==1) {
deferred.resolve(data.qDataPages[0].qMatrix);
}
Otherwise, we should get the data from all pages and then return the results! Promises in full glory!!!
var Promise = $q;
var promises = Array.apply(null, Array(numberOfPages)).map(function(data, index) {
var page = {
qTop: (pageheight * index) + index,
qLeft: 0,
qWidth: columns,
qHeight: pageheight,
index: index
};
return model.getHyperCubeData('/qHyperCubeDef', [page]);
}, this);
Promise.all(promises).then(function(data) {
for (var j=0; j<data.length; j++) {
for (var k=0; k<data.qDataPages[0].qMatrix.length; k++) {
qTotalData.push(data.qDataPages[0].qMatrix)
}
}
deferred.resolve(qTotalData);
});
This is how we get all of the results for a given set of Dimensions and Measures.
If you want to paginate just create a function that passes the page+1*500 to the qInitialDataFetch like
app.createCube({
qDimensions : qDimensions,
qMeasures : qMeasures,
qInitialDataFetch : [{
qTop : (pageIndex)*500,
qLeft : 0,
qHeight : 500,
qWidth : 20
}]
}, function(reply) {
Or
model.getHyperCubeData('/qHyperCubeDef', [{qTop: (pageIndex)*500, qWidth: 20, qLeft: 0, qHeight: 500 }]).then(function(data) {
-
Presenting Datathon Finalists Team Qlik Boom!
Our Qlik Academic Program Datathon finalists will be presenting their solutions to the challenge involving the United Nations Sustainable Development Goals during QlikWorld from 10-12 May. In preparation for this, I spoke to finalist team Qlik Boom to find out who they are, their experience of the datathon, and their hopes for the future. -
Talk to Experts Tuesday session on Qlik Sense SaaS and Qlik Sense Business TOMOR...
Hello Qlik Users! We have a Talk to Experts Tuesday session on Qlik Sense SaaS and Qlik Sense Business happening tomorrow! The session is at 10 am EDT and you can register here:Talk to Experts Tuesday: Qlik Sense SaaS/BusinessWhat kind of questions do you have about Qlik Sense SaaS or Qlik Sense Business? Let me know in the comments below or join us and listen to our Experts answer your questions LIVE!We hope to see you there!Kind regards,Qlik Di... Show MoreHello Qlik Users!
We have a Talk to Experts Tuesday session on Qlik Sense SaaS and Qlik Sense Business happening tomorrow! The session is at 10 am EDT and you can register here:
Talk to Experts Tuesday: Qlik Sense SaaS/Business
What kind of questions do you have about Qlik Sense SaaS or Qlik Sense Business? Let me know in the comments below or join us and listen to our Experts answer your questions LIVE!
We hope to see you there!
Kind regards,
Qlik Digital Support
