About Qlik Community

Hello Qlik Community,

We're excited to introduce our featured member for the month of July: Igor! Igor has been a cornerstone of our Community since he joined in 2017, bringing with him a wealth of experience and a passion for data science that is truly inspiring. With 20 years of experience working with Qlik, having seen it all starting with QlikView. His deep expertise in statistics, science research, and other areas has made him a valuable asset to the Qlik Community.

Based in Atlanta, he and his colleague Mark Costa, lead four Meetup groups in the US: Atlanta, Boston, Dallas, and Portland. Igor is a speaker, science podcaster, and mentor, helping others start their meetup groups in their cities.

Igor said, “Qlik isn't just a tool; it's a versatile platform that has enabled me to explore various aspects of data science, from statistics to medical research. Over the years, I’ve integrated Qlik with other technologies and pioneered the use of its statistical functions in my company, driving innovation and collaboration. My early adoption of AutoML and use of Qlik to integrate platforms like Python showcase my commitment to staying at the forefront of technology.

Beyond his professional achievements, Igor has a rich array of hobbies. He enjoys podcasting, robotics, and mixology. Notably, he is the creator of the drink Qlik Fusion, crafted specifically for Qlik Connect as part of his role as a Social Media Ambassador.

Please join us in congratulating Igor for his outstanding contributions to the Qlik Community. Let's show our appreciation by commenting and hitting that like button! Thank you, Igor, for inspiring us with your dedication and passion. @Sue_Macaluso @Melissa_Potvin @nicole_ulloa @Jamie_Gregory @igoralcantara

Hello everyone!

Me and @igoralcantara are excited to announce the launch of our new WhatsApp Community for all Qlik Meetup USA & Canada members!
This is a space where we can share ideas, experiences, ask questions, and much more. Let's keep the conversation going beyond our events and make our community even stronger.

Join us here: https://chat.whatsapp.com/KMn7bKco8KF0kiibTgUSwi

Not a Qlik Meetup member? Join today at https://www.meetup.com/pro/qlik/

Also, don't miss our upcoming online event focused on AutoML like you've never seen before.
Make sure to register and get all the details here:
https://www.datavoyagers.net/post/qlik-automl-in-action-practical-steps-from-data-preparation-to-real-insights

Looking forward to seeing you there!

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)

This short video will show you why you should subscribe to boards on the Qlik Community. Stay updated with the latest discussions and never miss out on important posts. Click the like button if you find this video helpful!

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

Hello together
I would like to analyse all callers, for example, if a phone number has called again during 24 hours, then it counts as a recaller.

Thank you very much for the support.

Regards,

Good day, Qlik Community!

Have you ever wondered what a Qlik Meetup is? It's a fantastic opportunity to join a data-driven community, whether you're a beginner or an expert in data analytics. It is great for learning, networking, sharing ideas and problems and to discuss business.

I recorded a short video about it, you can find here:

https://youtu.be/M__vjmlAaNo

And this is the link to find the Qlik Meetup closest to you. If there is none you could be a group leader. If you need help to get started, reach out. We'll be glad to support you.

https://www.meetup.com/pro/qlik/

This short video will guide you on how to disable email notifications in our community. Take control of your inbox and customize your notification settings to suit your preferences. Click the like button if you find this video helpful!

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

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/

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!

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.

https://bit.ly/4ezo6MK

Hello May! We are halfway through 2024. This month's focus is on a rising star. A member who joined the Qlik Community not seven months ago has already posted over one hundred times. You can see him on the monthly leaderboard. Many of the answers he’s provided are marked as accepted solutions. He shows his appreciation regularly by liking others' posts. This May, we are featuring a Qlik Partner and a Community member with a rank of Creator II, Maxime Piquet, AKA mpc.

Check out our rising stars story:

Allow me to introduce myself; I'm Maxime. As a seasoned data consultant, I've been harnessing the power of Qlik tools since 2016. My journey began with QlikView 11.2, followed by Qlik Sense in June 2017, and then Qlik Cloud. I've honed my skills in various areas, including app development, optimization, architecture, administration, upgrade, and migration. I'm proud to say that I'm newly certified.

When I embarked on my Qlik journey, the Community became my guiding light. It was my go-to for knowledge enhancement and assistance. Today, I'm privileged to give back and support my fellow Qlik Community members. Sharing and helping are not just values I hold dear but also ones that my company cherishes.

I like to eat, drink, and repeat. I enjoy strength training and climbing. I love cooking, mechanical work, and sports. In addition, I enjoy DIY projects and the watchmaking industry. I’m curious, and I love to discover new things! Share with me your hobbies!

Please show Maxime how much we appreciate his contributions to the Qlik Community. He is an inspiring example of a rising star. Like and comment, and, as Maxime said, share your hobbies.

Thank you, Maxime, for being our May featured member. @Jamie_Gregory @calebjlee @nicole_ulloa @Melissa_Potvin @mpc 

Hello Qlik Community,

We're thrilled to introduce our featured member for the month of June: Théo Atragie! Théo joined our Community in October 2023, and since then, he's been shining bright as one of our rising stars. As a data consultant at ACSSI, a leading French digital service company, Théo has quickly established himself as a key player in the Qlik ecosystem. With a keen focus on Qlik Sense, he dedicates his time to mastering the intricacies of data analytics and visualization.

What sets Théo apart is not just his expertise but also his unwavering commitment to helping others. Despite being a relatively new member, Théo is constantly engaged and active in our Community. He consistently stays on top of the leaderboards and is always ready to lend a helping hand to fellow Community members.

In his own words, Qlik isn't just a tool for me; it's a gateway to observation and discovery. Spending time in the Community is something I enjoy because it allows me to both receive and give knowledge, enriching my pedagogy.

In his life outside of data analytics, Théo enjoy participating in sports, particularly running. He recently completed the Paris Marathon, showcasing his determination and endurance. Based in Baisieux, France, Théo embodies the spirit of our global Community, bridging geographical boundaries to connect with fellow Qlik enthusiasts worldwide.

Please join us in congratulating Théo for his outstanding contributions to the Qlik Community. Let's show our appreciation by commenting and hitting that like button! Thank you, Théo, for inspiring us with your dedication and passion. @Sue_Macaluso @Melissa_Potvin @nicole_ulloa @Jamie_Gregory @theoat 

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

Good Day.

I am looking for any advise on how to resolve this issue. I have a dataset consisting of Groups, with Sites and Site Names. From time to time a new site can accidently be allocated the same Site Code or Site Name as an existing site.

I am looking for a way to identify duplicate Site Codes and Site Names, as per the included PNG file. It can also be that the Site Codes are different and the Site Names are the same.

The “# Sites” expression is “RowNo(Total) ” and currently the expression to Identify the duplicate Site code is “Rangecount(Above(Count(Sitecode), 0, RowNo()))”.

I would be appreciate any suggestions on the issue, whether in a straight table or by creating a separate table.

Thank you – much appreciated.

i am trying to load oracle database stored procedures output using out parameter and functions returning the values from oracle database to Qlik sense using below mentioned methods and getting the same error which is

"Executing non-SELECT queries is disabled. Please contact your system administrator to enable it."

Method-1

DOO_HEADERS_ALL:
load *;
SQL CALL mg_cust.QLK_GET_DOO_HEADERS_ALL_PRC('V_RESULT') !EXECUTE_NON_SELECT_QUERY;

Method-2

DOO_HEADERS_ALL:
load *;
SQL CALL mg_cust.QLK_GET_DOO_HEADERS_ALL_PRC('V_RESULT');

Method-3:

DOO_HEADERS_ALL:
load *;
SQL EXEC mg_cust.QLK_GET_DOO_HEADERS_ALL_PRC('V_RESULT');

STORE DOO_HEADERS_ALL INTO $(vLoad_E)/DOO_HEADERS_ALL.QVD](qvd);
Drop Table DOO_HEADERS_ALL;

i am getting the same error as attached, Please guide me to resolve this.

Join us for two days of invaluable insights, best practices, and insider tips that will help you take your data and analytics game to the next level! 

First, you'll get the inside scoop on Qlik's vision, product roadmap, and outlook. Then, Qlik executive, partners, customers, and industry insiders will dive into the best practices and applications for data, analytics, and AI that will make you a data dynamo.

Register now to save your spot! https://pages.qlik.com/QlikConnectLivestream_2024.html

P.S. It's totally FREE!