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.
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 Education blog provides information about the latest updates of our courses and programs with the Qlik Education team.
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 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
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, 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
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 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 max
Click on this link to see the presentation
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 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
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 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
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 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
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 forward. And the best part? It’s free – and you can join from any device.
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 point of decision, moving from passive to active BI.
Hello Qlik Users!
Did anyone see the new updates to SaaS editions of Qlik Sense that dropped yesterday?
Features and improvements include:
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
Hello Qlik Users!
An issue has been identified with the Google Spreadsheet Connector when using “GetWorksheet”. The issue affects:
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.
In today's blog and video, Qlik Solution Architect Tomilayo Komolafe (Tomi) is back providing real in-the-trenches solutions to real customer problems.
Here is the scenario:
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:
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 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) {
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/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