About | Qlik Community (2024)

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 aQlik Meetupgroup 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 aQlik Meetupgroup 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 aQlik 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 aQlik Meetupgroup 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 athttps://www.meetup.com/pro/qlik/

Show Less

By marksouzacosta 2024-06-21 / 12:01 PM

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!

Show Less

By igoralcantara 2024-06-19 / 04:22 PM

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

Show Less

By amber_cover 2024-06-20 / 10:52 AM

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

Show Less

By Sue_Macaluso 2024-05-01 / 10:15 AM

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

Show Less

By calebjlee 2024-06-03 / 11:07 AM

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!)

Show Less

By calebjlee 2024-06-17 / 11:13 AM

How to Rank 2 measure

Rank by units first then if units is equal >> rank by sales

i use like this not work!!
Aggr(Num(Rank(Sum(Units),Sum(Sales)), name)

please help..

Show Less

By kanchanap*rn 2024-06-16 / 03:14 AM

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

Show Less

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.

Show Less

By johngouws 2024-06-09 / 12:47 AM

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.

Show Less

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!

Show Less

By amber_cover 2024-05-28 / 02:00 PM

By calebjlee 2024-05-28 / 10:30 AM

Good day, Qlik Community!

Qlik Connect is just around the corner! To celebrate and welcome the entire Qlik Community to join us next week in Florida, I’ve crafted a refreshing new green drink.

Introducing QlikFusion.

Skål

Show Less

By igoralcantara 2024-05-28 / 09:33 AM

Hi all,

possibly I'm not long enough with Qlik. I'm really unsure about the Options to Upgrade a QlikView SBE Server to Qlik Sense Enterprise.

It will be very nice, If one of you experts can support me with details information.

Thanks a lot. BR Elke

Show Less

Good day!

We are hosting an Online Qlik Meetup event next week, on May 30th. It will be an online event for 4 meetup groups: Atlanta, Boston, Dallas, and Portland. If you're near one of these cities, make sure to: 1) join the group, 2) RSVP for the event.

If you're from another Meetup Group and would like to host this event with us, please DM me and join our alliance!

Details about the event and links:
**Qlik's ML Journey: Enrich your data with AutoML, LLM and MLOps**
May 30th - 6:00 PM EST

Atlanta:
https://www.meetup.com/atlanta-qlik-dev-group/events/300757689/?utm_medium=referral&utm_campaign=share-btn_savedevents_share_modal&utm_source=link

Boston:
https://www.meetup.com/qlik-meetup-boston/events/300757687/?utm_medium=referral&utm_campaign=share-btn_savedevents_share_modal&utm_source=link

Dallas:
https://www.meetup.com/dallas-qlik-dev-group/events/300757688/?utm_medium=referral&utm_campaign=share-btn_savedevents_share_modal&utm_source=link

Portland:
https://www.meetup.com/qlik-meetup-portland/events/300757695/?utm_medium=referral&utm_campaign=share-btn_savedevents_share_modal&utm_source=link

Show Less

By igoralcantara 2024-05-20 / 11:23 AM

I want to know QlikQlik Sense Academic Student get access to install qliksense on a server or what its called Qlik sense production server. If yes, how can I get access if I want to do it on on prem?

Show Less

By samdatanalyst 2024-05-19 / 03:02 AM

HI,

I'm facing an issue where I can't find the snapshot option when selecting the filter pane visualization, unlike other visuals where it's readily available. Additionally, I require live data in the storytelling sheet and the ability to utilize filtered pane visuals within it.

Show Less

By muneer12345 2024-03-28 / 07:23 AM

Hi everyone,

A big thank you to all who joined our Qlik Community office hours and contributed to the engaging discussions on ideation. We truly appreciate your thoughtful questions! If you missed out, don't worry - you can catch up by watching the recording here (Password: 3CsFfaR*). Stay tuned for updates on our next Qlik Office Hours, which will be posted soon on our events page.

Show Less

By calebjlee 2024-05-15 / 12:39 PM

hello everyone,

An error occurred when I was creating a snowflake connection : "Connections are only allowed to *.snowflakecomputing.com hosts. " .

It seems that the official snowflake driver does not support ".cn" ending hosts.

How can I avoid this problem? Do I need to modify the driver configuration file?

Show Less