About Qlik Community

This September, we're turning the spotlight on a true Qlik pioneer whose expertise and passion have shaped the community in remarkable ways! Meet Mark de Souza Costa, a Qlik virtuoso with a rich 15-year history of mastering complex ETL solutions, enhancing application performance, and driving innovative integrations. From his roots in Brazil’s IT scene to leading the charge in Qlik innovation, Mark has been a relentless force for progress.

His journey is packed with insights and dedication, and we're excited to share his story with you. Let's dive into Mark’s Qlik adventure in his own words!

"I'm a firm believer that the best way to learn is by sharing knowledge. This belief drives me to contribute actively to our Qlik Community and Qlik Meetup Groups. Together with my colleague Igor Alcantara, I manage four Meetup groups across the US: Atlanta, Boston, Dallas, and Portland. We also support others who are interested in starting their own Meetup groups. Additionally, we maintain a blog and a YouTube channel, both under the name 'Data Voyagers,' where we share insights about Qlik."

When he's not diving deep into the world of Qlik, Mark enjoys playing video games and exploring his passions for videography and audio recording. His enthusiasm for learning and trying new things is truly inspiring.

Please join us in congratulating Mark on his incredible contributions to the Qlik Community. Let's show our appreciation by commenting and hitting that like button! Thank you, Mark, for your commitment and passion. @marksouzacosta @Sue_Macaluso @Melissa_Potvin @Jamie_Gregory @nicole_ulloa

This Webinar Will Cover:

 * Why Qlik Meetups Matter: Discover the benefits of fostering a local Qlik community for networking, learning, and career growth.

* The Meetup Blueprint: Step-by-step guidance on planning, launching, and sustaining a successful Qlik Meetup group.

* Engagement Essentials: Learn proven strategies for attracting and retaining members, from topic selection to event formats.

* Real-World Success Stories: Hear from experienced Meetup organizers who share their insights and tips for success.

Who Should Attend:

* Qlik enthusiasts of all levels who are passionate about data and community building.

* Professionals seeking to expand their network and knowledge in the Qlik space.

* Anyone interested in fostering a collaborative learning environment for data professionals.

Don't miss this opportunity to ignite your data community and become a Qlik Meetup master!

Register Here!

Discover how to bookmark posts in our community and keep track of important discussions with ease. If you find this tutorial helpful, be sure to give it a thumbs up!

(Click the YouTube link for a transcript of the video. If you need closed captions, please let us know here!)

Hello, my problem is that I created a Role for some users in QMC, those users have access to a segmentate QMC. When they create some new streams or tasks, they manage to see other Custom properties, instead of only the one's belonging to them, in the case below, it just had to appear the customproperty_2:

Can anyone help?

Learn how to update language settings in our community and tailor your experience by selecting the language that best suits you. Don't forget to like this video if you find it helpful!

(Click the YouTube link for a transcript of the video. If you need closed captions, please let us know here!)

If you’ve been exploring the potential of Qlik Answers, you already know it's a powerful tool for interacting with unstructured data. But how far can it really go?

In my latest article, I dive deep into the practicalities of using Qlik Answers—from building Knowledge Bases with medical research to pushing the boundaries of what this tool can do. Along the way, I share the surprises, challenges, and why I believe Qlik Answers is a game-changer for anyone serious about data science.

Interested in seeing how you can get even more out of Qlik Answers? Click the link below to read the full article here:

My first impressions of Qlik Answers: Is it worth it? (datavoyagers.net)

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 

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:

1. Networking: Meet professionals who share your interests and can open doors to new opportunities.

2. Learning: Stay up-to-date with the latest trends, tools, and techniques in the Qlik platform.

3. Collaboration: Find partners for projects, share ideas, and get feedback from a supportive community.

4. 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:

Qlik Cheat Sheets (ipc-global.com)

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)

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

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:

• Central node: type (Manager and Worker), Max concurrent reloads (7)
• Worker node: type (Worker), Max concurrent reloads (14)

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.

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:

• App Task List with General Script Errors: General Script Error LIST_QnA_v1.xlsx
• Detailed Logs of the Affected App: General Script Error LIST_QnA_v1.zip
• Complete Log Files: LogCollector_00174923 (4).zip

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:

• Distribution of VAS App Executions by Time
• Unknown Error (General Script Error) by Time
• Detailed Logs of Unknown Errors

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.