Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We're excited to introduce our featured member for the month of August: This month we are featuring an amazing Qlik employee, Jonny Poole! Jonny has been an integral part of Qlik for the past 13 years as a member of the Presales organization. Throughout his time with Qlik, he has demonstrated a profound dedication to designing associative models and highlighting their value through the main Qlik client interfaces as well as value-added interfaces like reporting.
Jonny’s journey into the world of reporting began with his previous employer, Cognos (IBM), where he developed a passion for solving customer problems through his extensive experience in customer support. This background has been invaluable in his role at Qlik, where he has continued to help customers, partners, and prospects solve their most pressing data challenges.
Jonny shared, “Participating in the Qlik Community is the perfect opportunity to further my interest and to gain a pulse on the day-to-day needs of Qlik practitioners worldwide from customers, partners, prospects, and others.”
Please join us in congratulating Jonny on his outstanding contributions to the Qlik Community. Let's show our appreciation by commenting and hitting that like button! Thank you, Jonny, for inspiring us with your dedication and passion. @JonnyPoole @Melissa_Potvin @Jamie_Gregory @nicole_ulloa
Update as of July 15, 2024: The new Customer Portal is live!
Update as of July 9, 2024: Maintenance Window changed, expected start time is Saturday, July 13 at 2:00a.m. EST
On July 15, 2024, Qlik is launching your future home for managing your Qlik account needs. The initial release of Qlik’s Customer Portal will be the one place for all customers and partners to find support, for both Qlik and Talend products.
Here you’ll find:
We also make it easy to connect you to customer resource sites like:
By using your Qlik Account, you can gain access to these core support activities. Stay tuned for more business activities to make its way to Customer Portal related to account management and further customer success resources.
NOTE: If you currently do not have a Qlik Account, please follow these instructions to register for one. If you are having access issues to Qlik Customer Portal, you can contact Support through our chat, without needing to be logged in.
Maintenance Window:
If you are a Talend Customer, you can expect:
If you are a Qlik Customer, you can expect:
We look forward to bringing you easier ways to do business and are striving to enhance your experience. Place your questions in the comments below and we’ll be in touch!
Thank you for choosing Qlik,
Qlik Global Support and Customer Experience
Update as of May 15, 2024: Moved the dates back by one week.
As part of Qlik’s ongoing effort to unify our presence with Talend offerings, we are moving Talend login credentials to use the same authentication mechanism as other Qlik web properties. This will improve our overall customer experience and provide Talend customers greater access to data integration, quality, and analytics capabilities.
Starting May 21, 2024, the login mechanism for Talend Cloud customers will change to use the Qlik Account authentication infrastructure. This is not a forced migration to using Qlik Cloud applications or services; no other infrastructure is changing. Existing Talend Cloud login credentials will switch to a new authentication provider.
Review our most frequently asked questions below:
Qlik Account helps users access multiple Qlik services using one set of credentials. Once registered Qlik customers and partners can access their Qlik Cloud applications, Talend Cloud, Support Portal, and the Downloads page. Users can also access Qlik Community and Qlik Continuous Classroom (QCC). Additionally, partners can use their Qlik Account to access the Partner Portal.
No, but you can create a Qlik Account before the conversion dates.
Note: You must use the email address listed in your Talend Cloud profile when creating your Qlik Account. Do not use your Login Name.
What happens during the conversion process?
The following video explains the process of moving to a Qlik Account, referred to as Qlik ID.
Yes. Follow this link for instructions on creating your Qlik Account.
Note: If you create a Qlik Account before May 14th, then you must use the same email address listed in your Talend Cloud profile (see Figure 1.) and not your Login Name.
A web page displaying your currently active Qlik Cloud and Talend Cloud tenants will be displayed after a successful login. You can then navigate to a specific tenant by clicking on the appropriate tile (see Figure 2.)
Synchronization to populate your tenants list can take from ten seconds to a couple of minutes. If the web page doesn't populate your tenants list, the synchronization process will run again after two hours.
Another reason why all tenants may not appear in the list is a "region" query string parameter has been added to the URL. Simply remove the region parameter and the value, refresh the page, and the full list of tenants will appear.
If you see this page after completing the migration (see Figure 3,) the synchronization process may not have completed or you may have a mismatch between your Qlik Account email and your Talend Cloud tenant email.
You can fix the email mismatch by using the Talend Legacy Login link. You will be redirected to the old Talend login page. Follow these steps:
1. In your browser, navigate to https://iam.<region>.cloud.talend.com/idp/login?legacy=true where
"<region>" is the region your Talend Cloud tenant resides.
2. Authenticate to your tenant with your Talend userId and password.
3. Click on your name in the right side of the Talend toolbar.
4. Select Profile preferences from the menu.
5. In the Email field, update the email address to match your Qlik Account email address.
6. Save your profile.
7. Logout of the Talend tenant and navigate to the Qlik Cloud login page at https://login.qlik.com.
8. Log into Qlik Cloud using your Qlik Account.
You will not be able to access your Talend tenant if the email address for your user profile in the tenant doesn't match your Qlik Account email address.
Great! No further action is required.
Single sign-on functionality is not changing and you do not have to switch authentication providers. Access the updated sign-in page directly by entering https://iam.<region>.cloud.talend.com/idp/login-sso where <region> is the location of your Talend Cloud tenant. When you see this page, confirm your Talend Cloud region and enter the email you use to access Talend Cloud through your single sign-on provider.
When you press next you will be redirected to your identity provider authentication process.
No. Your existing bookmarked pages should redirect to use the new login mechanism.
To access the new Qlik Cloud login page visit https://login.qlik.com
The legacy login is available for a limited time to help users resolve email mismatches between Talend tenants and Qlik Account. Qlik reserves the right to deprecate this URL at any time with limited notice.
If you experience login difficulties, then contact us at the customercare@talend.com
If you have additional questions, comment below!
Hey Qlik Community,
I want to share a story with you all. It’s about someone's early days in the Qlik Community, a place that felt like a vast ocean of knowledge and expertise. However, navigating it wasn't always easy, especially when it came to getting the help this person needed. For better storytelling reasons, let's say it was me. My posts were often too vague or confusing, leading to frustration and few useful responses.
One day, I posted a question that I thought was clear: "Why isn’t my Qlik script working?" After a few days with no replies, I realized that my question didn’t give enough information for anyone to help me. It was like asking a mechanic, “Why isn’t my car running?” without mentioning the make, model, or symptoms. If you have worked with support before, you probably had that experience with a user. Or if you're married ("why did you do that?"; "did what??") 😄
After some trial and error, and learning from the fantastic community members, MVPS, Ambassadors and Luminaries, I found a way to get the responses I needed. Here are some tips that transformed "my" experience and might help you too.
1. Be Specific and Detailed:
Instead of "Why isn’t my Qlik script working?", try: "I am using Qlik Sense to connect to a SQL database, and my script returns an 'Invalid column name' error when loading data. Here’s the script I’m using: [insert script]. What could be causing this issue?"
2. Provide Context:
Explain the background of your problem. Are you following a specific tutorial? Did the script work previously and suddenly stop? The more context you provide, the easier it is for others to understand and help.
3. Include Screenshots or Code:
A picture is worth a thousand words. Screenshots of error messages or the part of the code that’s causing trouble can be incredibly helpful. Make sure to redact any sensitive information.
4. State What You’ve Tried:
Before posting, describe the solutions you’ve already attempted. This helps others avoid suggesting the same things and can lead to more advanced troubleshooting. For example: "I tried changing the column name in the SQL query, but the error persists."
5. Ask One Question at a Time:
If you have multiple issues, it’s often best to post separate questions for each. This makes it easier for community members to provide focused answers.
6. Be Patient and Polite:
Remember, the community is made up of volunteers who are here to help. A little patience and a thank you can go a long way. If someone's reply is the solution for your problem, let this person know in a reply and don't forget to flag their answer as the solution.
7. Use Relevant Tags:
Tags help categorize your question, making it easier for experts in that area to find and answer it. Use tags that are specific to your issue, like “Qlik Sense,” “SQL,” or “script error.”
8. Use Storytelling:
In my storytelling/presentation workshops I always teach people that the most important in any good message has the following elements:
- An Amazing Beginning and Ending
- It is structured in 3 acts: Present the problem, develop the context, Call to action or conclusion.
Keep that in mind when writing a Community post.
Here’s an example of a well-structured question:
---
Title:
"Qlik Sense Script Error: 'Invalid column name' when loading from SQL database"
Body:
"Hi everyone,
I’m encountering an issue with my Qlik Sense script when trying to load data from a SQL database. I receive the following error: 'Invalid column name'.
Context:
- I’m following a tutorial on Qlik’s website about connecting to SQL databases.
- This error started after I added a new column to my SQL table.
- Here’s the part of the script that’s causing the issue:
```
LOAD
CustomerID,
CustomerName,
OrderDate,
NewColumn
FROM
[SQL Database] (qvd);
```
Attempts:
- I’ve verified that the column name in SQL matches the name used in the script.
- I’ve refreshed the connection but still encounter the error.
Screenshot:
[Insert screenshot showing the error message]
Does anyone have suggestions on how to resolve this issue? Thanks in advance for your help!
---
So, isn't that a much better message?
By following these tips, you’ll not only increase the chances of getting the help you need but also contribute to making the Qlik Community a more effective and enjoyable place for everyone.
I also recommend learning from this incredible source of documents:
Getting Started and How-To's | Qlik Community
Happy Qliking!
Have you ever read something that changed your entire life? For me, that moment came from an article in an MSDN Magazine. It was a simple article, but it set off a chain of events that would transform my career and my life in ways I could never have imagined.
I was living in Brazil, young, recently married, in a new city, with no money, no friends, and no family around. I was transitioning from Physics to IT and feeling somewhat unsure about everything.
One day, I stumbled upon an article in MSDN Magazine that intrigued me. The author lived in the same city I had just moved to! At the end of the article, there was a mention of a local tech meetup group, and believe it or not, it was at the same college I was about to start attending. Intrigued, I decided to contact the author, and he pointed me to someone you probably know well: Igor Alcantara (@igoralcantara)! At that time, Igor was the Microsoft Academy Cell leader in that area.
That decision to contact the author was the first domino to fall. At the college facilities, I met Igor Alcantara. He was not hard to spot, wearing a Microsoft polo shirt and backpack. Long story short, he saw potential in me and offered me an opportunity to join his team.
This was the break I had been waiting for. I joined the company, gained invaluable experience, and expanded my network. A few years later, both Igor and I were offered positions at a multinational corporation. This opportunity led to another significant change: moving from Brazil to the United States.
Today, I am living and working in the U.S., thriving in my career, and continuously expanding my professional horizons. All of this stemmed from a single article and the decision to engage with a community.
Now, let’s bring this back to Qlik. What could joining a Qlik Meetup group do for you? Here are a few possibilities:
Networking: Meet professionals who share your interests and can open doors to new opportunities.
Learning: Stay up-to-date with the latest trends, tools, and techniques in the Qlik platform.
Collaboration: Find partners for projects, share ideas, and get feedback from a supportive community.
Inspiration: Discover new ways to approach problems and innovative solutions that you might not have considered.
Joining a Qlik Meetup group could be the start of a journey that leads to new friendships, career advancements, and even life-changing opportunities. If a simple magazine article could change my life, imagine what connecting with a dynamic and passionate community could do for you.
So, why not take that step? Attend a Qlik Meetup , get involved! See where the journey takes you. Your next big opportunity might be just a conversation away.
If the reason for you not to join a Qlik Meetup group is that there is not a group near you, then: why don’t you start your own group in your city? If you don’t know how, send me a message and I can help you.
Join today at https://www.meetup.com/pro/qlik/
Good day Qlik Community,
As part of our mission to help the community, my team is starting to put together a few Qlik cheat sheets. We will keep this updated as we go. Right now we have 3 available.
You simply click on the file and download it. No fee, no need to fill out your contacts.
I hope you find this helpful.
Here we go:
In the wake of the recent surge in the adoption and advancement of Large Language Models (LLMs), I've found myself contemplating the profound implications for the field of analytics and the evolving role of data and business analysts.
With each stride made in natural language processing technology, my fascination with its transformative potential only deepened. However, as I delved into the current applications of LLMs and Generative AI, I couldn't shake the sense that something vital was missing.
Despite the undeniable capabilities exhibited by these models, their relevance to real-world business scenarios often seemed nebulous. The disconnect between the touted examples and the practical needs of businesses left many questioning the applicability of these technologies.
It was amidst this backdrop of uncertainty that the concept of Language-Centric Analytics began to crystallize in my mind, after much reflection, discourse, and experimentation. This paradigm shift places language at the heart of the analytical process, recognizing its innate familiarity and accessibility as a means of interaction. By reframing analytics around language, we pave the way for a more intuitive and inclusive approach to data exploration and interpretation. The journey towards Language-Centric Analytics holds the promise of reshaping not only how we analyze data but also how we perceive and harness its potential to drive meaningful insights and informed decisions.
About that topic, I just published a short article in the Data Voyagers blog. This text serves as an introduction to this concept. I hope you all enjoy it.
The Rise of Language-Centric Analytics (datavoyagers.net)
I got an email from Qlik Ideation due to an added comment on a request, and the email has a link "Reply and see request details". When I click that link, all I get is this:
The I use the support link in the top menu of Qlik Community and I go to Ideation - Browse and Suggest https://community.qlik.com/t5/Ideation/ct-p/qlik-product-insight and I search the idea I want to visit in the table. I find it and I click its link, only to end up at the same error message.
In the Browse and Suggest table there is a text stating "To post an idea or authenticate yout login, first click Suggest Features" above this app." So I click that link and all that happens is that I am returned to the same Browse and Suggest page again, and when I once again click the idea link I still get the same error as in the image above.
"Suggest features" is the first of the links in this widget bar above the ideas table:
The second widget says "Open Portal" but the same thing happens as when I click the first link.
The third widget is Learn More [about Ideation], and it leads to https://community.qlik.com/t5/About-Ideation/ct-p/qlik-aboutideation. On that page there are five links at the bottom and only the first and last are working, the other (e.g. "How to submit an idea") leads to an error page.
Just before posting this message I come up with the idea to try with Google Chrome instead of Firefox that I am using - and now the link in the email that I got works! But instead, the Browse and Suggest table gives me an authenticate button, and when I click that I end up on an error page at ideation.qlik.com. Well, after once again reloading the Browse and Suggest page I can use it in Chrom and redirections to the ideation area works.
But I choose to post this anyways, even though I got it working in Chrome in the end. Does it really have to be this complicated to access ideation?
Hey Denver Qlikkies -
The Qlik Denver Meetup group is up and running! If you're local to that area, please join us.
https://www.meetup.com/denver-qlik-group
#Meetup #Denver #Colorado
We're excited to introduce our featured member for the month of August: This month we are featuring an amazing Qlik employee, Jonny Poole! Jonny has been an integral part of Qlik for the past 13 years as a member of the Presales organization. Throughout his time with Qlik, he has demonstrated a profound dedication to designing associative models and highlighting their value through the main Qlik client interfaces as well as value-added interfaces like reporting.
Jonny’s journey into the world of reporting began with his previous employer, Cognos (IBM), where he developed a passion for solving customer problems through his extensive experience in customer support. This background has been invaluable in his role at Qlik, where he has continued to help customers, partners, and prospects solve their most pressing data challenges.
Jonny shared, “Participating in the Qlik Community is the perfect opportunity to further my interest and to gain a pulse on the day-to-day needs of Qlik practitioners worldwide from customers, partners, prospects, and others.”
Please join us in congratulating Jonny on his outstanding contributions to the Qlik Community. Let's show our appreciation by commenting and hitting that like button! Thank you, Jonny, for inspiring us with your dedication and passion. @JonnyPoole @Melissa_Potvin @Jamie_Gregory @nicole_ulloa
||Trusted data is the key to business success. And with Qlik Talend Cloud, it’s never been easier to create a trusted data foundation to maximize the transformative value of your data. Learn how in our product roadmap keynote and demo. ||Available On-Demand|||| || https://pages.qlik.com/QTCProductLaunchWebinarOD.html
||With Qlik Answers™, get personalized, GenAI-driven answers from unstructured data, so you can make decisions with confidence. Learn how in our product roadmap keynote and demo. ||Available On-Demand|||| || https://pages.qlik.com/QlikAnswersProductLaunchWebinarOD.html
||Register now
This Techspert Talks session covers:
Chapters:
Resources:
Q&A:
Q: Does QCDI works as orchestration?
A: QCDI has built in orchestration capabilities for its tasks. This includes scheduling features and workflow.
Additionally, Qlik Cloud provides Qlik Application Automation which can handle broader orchestration capabilities including Qlik Cloud components like QCDI or external components. For example with Qlik Application Automation, you could run QCDI tasks to load and transform data, then execute a databricks notebook or job and then run your Qlik Sense reload.
Q: Does data flow through the QCDI cloud region or does my gateway region matter for it?
A: For data movement it depends on the data source.
Relational databases, mainframe and SAP (ECC / S4/HANA) data is captured by the gateway and delivered directly to the target without passing through Qlik Cloud.
SaaS applications like ServiceNow, Salesforce etc. do pass through our cloud.
Q: Do you also have Rest-API to Jira data?
A: There is a connection available to Jira Cloud in QCDI.
Q: Are Talend integration and Qlik Cloud Data Integration the same?
A: No they are not the same.
Qlik acquired Talend and we are working to integrate features from Talend Cloud into Qlik Cloud – come to Qlik Connect to learn more!
The use cases solved by Talend and Qlik Cloud Data Integration are different also….
QCDI is focused on 2 core use cases:
Log-based, low-latency capture for RDBMS sources and delivery to RDBMS or cloud object store targets Incremental (API based) capture for SaaS sources and deliver to RDBMS or cloud object store targets
Supporting Snowflake, Databricks, Google BigQuery, MS Fabric, AWS Redshift and SQL Server(onpremise or cloud)
This provides data ingestion AND transformation capabilities.
Transformations are performed using an ELT paradigm where the workload is pushed down to the data platform.
ETL process with Java or spark based transformations that leverage a mid-tier engine to process data (not ELT).
Application integration workloads that can integrate applications together
Streaming or event based integrations with message queues / kafka or other eventing systems
API creation with no-code features to define API’s
At the end of the day you can combine capabilities but you should consider your architecture / use case to determine the best solution. Talend Data Fabric / Studio is Qlik’s go-forward, strategic ETL solution while QCDI is our go-forward, strategic ELT solution
Click here to see video transcript
Hello Community,
when browsing the posts in a forum there is a button with three dots in the top right and one action it offers is "mark all messages as read". After clicking, it even says that all messages have been marked as read successfully. But I do not see any indicator for showing if a message has been read. Where is it? 😉 And is there a way to hide all posts that are marked as read?
Best regards
Thomas
Hi,
We have observed that General Script Errors occur frequently between 06:00 and 10:00. To address this issue, we have assigned both Manager and Worker roles to the central node in an effort to distribute task execution more effectively.
QlikSense Configuration:
Is it possible to adjust the Max concurrent reloads values specifically during the 06:00 to 10:00 time period? Our goal is to assign the Worker role to the central node only during the hours when General Script Errors are most frequent.
Thank you for your attention to this matter.
Join Qlik Support's office-hours, recorded live, where our experts answer your questions and help you navigate and better understand how to get started finding data insights with Qlik Cloud. This month's topic talk is: New to Qlik Cloud
Questions:
Resources:
Did we answer your question? Let us know by clicking the like button!
Hello,
The current server configuration where the general script occurs is shown in the attached file. If we explain both Central and ETL as operating in Worker mode, will the tasks be divided and executed according to the ratio of the Max concurrent reloads setting value?
For example, if the Max concurrent reloads setting value in the attached file is 7:15, will the tasks be executed divided by this ratio?
I would appreciate your response.
We are providing the requested file list related to the general script error issue and have a few additional questions.
File List for Review:
Current Situation: The system operates with two servers: a Central server and an ETL server. During peak hours (07:00–09:00), an unknown error (GENERAL SCRIPT ERROR) occurs, as shown in the provided references.
References:
Inquiry: The unknown errors occur after attempting a REST API CONNECTION with the big data platform [LOGPRESSO]. We need to determine if there is a limit on the number of API CONNECTION attempts in QlikSense or if there is a setting for the maximum number of attempts. Since the GENERAL SCRIPT ERROR only occurs after the REST API CONNECTION, it seems highly related to this issue.
Please review the information provided and respond with any insights regarding API CONNECTION limits or settings in QlikSense.
Thank you.
Join industry leaders Tim Zhou, Managing Director of AI & Data at Accenture, and Ronald van Loon, CEO and Principal Analyst at Intelligent World, as they share their expertise.
Discover how to lay the groundwork for AI success, explore practical strategies, and see real-world examples of organizations leveraging trusted data.
Register now and take the first step toward building AI you can trust.
Hello,
I would like to inquire whether it is possible to store QVD files in QlikSense using the "Hot," "Warm," and "Cold" data storage approach.
Since not all collected data is necessarily used, I am interested in enhancing query performance by configuring disks in a composite manner rather than relying solely on SATA disks. Could you please confirm if this approach is supported in QlikSense?
Thank you for your assistance.
Best regards,