Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Our October feature shines on Robert Mika, whose curiosity and design sense have shaped Community conversations. He’s the kind of contributor who makes complex topics feel approachable and enjoyable. From his first steps with Qlik in 2013 to becoming an active voice in the Community since 2014, Robert Mika’s journey has been defined by curiosity, creativity, and a drive to help others see the story in their data. Today, he works as a Creative BI Designer and Qlik Specialist.
Robert’s professional path has taken him across industries, from pharma and manufacturing to banking, insurance, and now technology. Along the way, he has shared his expertise generously in the Qlik Community, which he describes as a space where discovery thrives.
“Whether I’m solving technical challenges, exploring design ideas, or learning from others, I find inspiration in the creativity here,” Robert shares.
Outside of work, Robert finds balance in new age music, yoga, and the gym, practices that fuel his energy and help him recharge. It’s this mix of focus, creativity, and collaboration that makes his presence in the Qlik Community so impactful.
Robert, thank you for bringing your passion, creativity, and collaborative spirit to the Qlik Community. Please join us in celebrating Robert in the comments below!
@robert_mika @Sue_Macaluso @Melissa_Potvin @Jamie_Gregory @nicole_ulloa @Tammy_Milsom @Brett_Cunningham
Qlik is leveraging the power of AI to provide a new testing experience. This means more flexibility for you! You choose where and when you want to take your certification exam. Starting in May, you can take all product certifications whenever it is convenient for you directly on Qlik Learning.
What can I expect with the new Qlik certification experience?
How to get ready:
The Exam Experience
You’ll be able to select your certification exam directly from Qlik Learning. Once you complete your exam will appear on your Qlik Learning homepage — ready when you are.
All exams are proctored and recorded using software-based proctoring. If you have any issues during your exam, a human proctor will pop in. Before launching the exam, you will need to complete a few checks, like identification verification and a workspace scan. You’ll also get a countdown timer to show your remaining time.
Open Book, Clear Boundaries
All Qlik Certification Exams are open book. This means you are permitted to use authorized test aids during your exam.
The authorized exam materials are limited to: Qlik Learning courses and use cases, Qlik Talend products, documentation, knowledge-based articles, your own study notes, and web searches. The use of AI or AI-assisted tools and web browsers is strictly prohibited.
You’ll get your exam results right away. If you have passed your exam, your certification badge will be issued to you directly!
Get Ready with Confidence
The best way to prepare for an exam is to complete the relevant training courses and practice the outlined skills. You will find everything you need on Qlik Learning, including detailed exam overviews for Qlik Talend Data Integration Certification and Qlik Data Analytics Certification. These overviews include learning plans, use cases, topics covered, and practice tests to help you assess your knowledge.
Qlik certification exams are designed to meet industry standards by combining hands-on experience with product training. They also assess the foundational methodologies required to deliver high-quality, successful projects.
Questions? Reach out to us education@qlik.com Happy Learning!
Data is everywhere. Every decision, every process, every strategy is powered by it. But here’s the challenge:
👉 What if we don’t know how to interpret the data in front of us?
👉 What if we can’t tell the story behind it?
That’s where Data Literacy comes in: the ability to read, work with, analyze, and communicate with data—regardless of role, skill level, or tools.
Improving your data literacy means:
✔ Asking better questions.
✔ Interpreting insights with confidence.
✔ Taking informed actions that drive impact.
Yet…
📊 Only 24% of business decision-makers feel confident using data.
📊 Just 32% of executives are considered data literate.
📊 Among young people, only 21% are data literate.
✨ Want to know how data literate you are?
Take this free assessment: The Data Literacy Project
What is a Learning Experience?
A Learning Experience is a live, one-time, instructor-led session created exclusively for Passport holders.
You tell us what you need to learn now, and our instructors design a focused class to help. These sessions often cover:
The goal is simple: fresh, useful knowledge you can apply right away.
Upcoming Learning Experiences:
Don’t miss out—get your Passport today and unlock all instructor-led courses plus exclusive Learning Experiences designed for your growth.
Looking for your next opportunity—or the perfect candidate? You’re in the right place! This forum connects employers, job seekers, and interns in the Qlik ecosystem.
Use the templates below to make your post clear and easy to find. Just copy the one that fits, fill in your details, and select the correct label:
Include location, role details, and contact info.
Add the correct label so your post reaches the right audience.
Follow up on any responses and close your post once the position is filled or your search is over.
If you’re part of the Qlik Academic Program or learned Qlik at your university, don’t forget to add the “Qlik Academic Program” label to your post, this helps others in the community spot you!
Happy connecting, and good luck!
Our October feature shines on Robert Mika, whose curiosity and design sense have shaped Community conversations. He’s the kind of contributor who makes complex topics feel approachable and enjoyable. From his first steps with Qlik in 2013 to becoming an active voice in the Community since 2014, Robert Mika’s journey has been defined by curiosity, creativity, and a drive to help others see the story in their data. Today, he works as a Creative BI Designer and Qlik Specialist.
Robert’s professional path has taken him across industries, from pharma and manufacturing to banking, insurance, and now technology. Along the way, he has shared his expertise generously in the Qlik Community, which he describes as a space where discovery thrives.
“Whether I’m solving technical challenges, exploring design ideas, or learning from others, I find inspiration in the creativity here,” Robert shares.
Outside of work, Robert finds balance in new age music, yoga, and the gym, practices that fuel his energy and help him recharge. It’s this mix of focus, creativity, and collaboration that makes his presence in the Qlik Community so impactful.
Robert, thank you for bringing your passion, creativity, and collaborative spirit to the Qlik Community. Please join us in celebrating Robert in the comments below!
@robert_mika @Sue_Macaluso @Melissa_Potvin @Jamie_Gregory @nicole_ulloa @Tammy_Milsom @Brett_Cunningham
I have to apply a condition in a text object so that it will be displayed to only those users who have 'BRANCH' in the security excel file in the 'LEVEL' column
I used this expression :-
=IF(WildMatch(Concat({<NTNAME={'$(OSUser())'}>} DISTINCT LEVEL, '|'), '*BRANCH*') > 0 , 1, 0)
but it didn't work, still all the other users are able to see that text object even though they do not have BRANCH,
Can someone please help me with the correct expression?
Hi,
I’m ingesting data from DB2 to BigQuery using Qlik. Is there a way to store or log the ingestion details into a BigQuery table? If yes, how can I set it up?
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?
Some Qlik Community members aren’t just contributors. They’re collaborators, innovators, and pioneers. Laura Ashworth exemplifies all of these. As a long-time Community member, Qlik Luminary, and advocate for Women Who Qlik , Laura has spent over a decade helping others unlock the full potential of their data. We’re proud to recognize her as our September Featured Member!
Laura is the Sr. Qlik Sense Architect & Engineer at Raymond James, where she brings over 13 years of experience working with Qlik products. Her journey began with QlikView, where she quickly discovered the value of Qlik Community as a place to learn, troubleshoot, and connect with others.
“Qlik Community is not just a website to find information on issues,” Laura says. “It’s a way to connect, share, and learn from others, get great insights into what is coming, or find basic how-to instruction within events, webinars, blogs, and more.”
Her expertise and enthusiasm have made a lasting impact, both through her day-to-day work and her ongoing presence in the Community. From blog posts to forums, Laura brings a thoughtful approach to solving problems and helping others find clarity—one piece at a time.
And speaking of pieces, Laura is a big fan of jigsaw puzzles!
“No wonder I was attracted to data and analytics,” she shares. “Data is just a puzzle to put together in order to provide the picture at the end. Of course, the pieces have to fit correctly—not always an easy task—and you can’t have any missing pieces, or you wouldn’t have a completely correct picture.”
When she’s not deep in Qlik solutions or solving puzzles, you’ll find Laura spending time with her pets.
Laura, thank you for your attentiveness, leadership, insight, and deep presence in the Qlik Community through the various groups you are a part of. We're thrilled to feature you this month. Please join us in celebrating Laura in the comments below! @lashworth @Sue_Macaluso @Melissa_Potvin @Jamie_Gregory @nicole_ulloa @Tammy_Milsom @calebjlee @Sarah-Clark
Good day Qlik Community!
I have a new article available at Data Voyagers. This time I decided to talk about the good and old, fan favorite, Qlik Engine. However, with a different perspective, a neuroscience perspective.
Humans don’t think like queries. We don’t learn by joining information in pre determined ways. We think and learn by making association. Produce a data engine that helps computers process information like our brain was a revolution in Analytics and it is still today the core and greatest advantage of Qlik.
This is my article of this week. I hope you like it.
Think Like a Human, Calculate Like a Machine: Qlik Associative Engine
Hello,
I have completed the Talend Administration Center Essentials (TAC) course on the Qlik learning portal and would like to register for certification. I don't know how to do this. Can someone please help me? Thanks in advance.
Hi,
Is there a way to configure the sample size to less than 10,000 records in Data Preparation Cloud? I need to work with smaller samples and would like to know if this option is available.
Thanks.
Hello all,
I am currently working on a task, in which I am triggering a Talend job to run when I click a button 'Run Talend Job' on the Salesforce record. I am able to trigger the job using webhook URL. But my requirement is to run the job only to the record from which I click the 'Run Talend Job' button. For that I need to send the record Id to the Talend Cloud (in the form of a JSON) and extract the Id from JSON and use it in the tSalesforceInput component (so that I can make sure that the Talend job is running only for this record).
However, when I am testing using POSTMAN and send a payload as
Hello everyone,
We are experiencing an issue with bookmarks in Qlik Sense Server. When a user creates a bookmark under My favorites, it becomes visible to all users in the published app, instead of remaining private.
Environment:
Qlik Sense Server (please see version below – e.g. May 2025)
Bookmarks created in a published app
What we expect:
Bookmarks saved under My favorites should only be visible to the user who created them.
What is happening:
Any bookmark created by a user is visible to all other users in the same app.
What we tried:
We created two security rules in QMC — one for private bookmarks and another for published bookmarks — but this did not solve the problem. No other custom rules are currently affecting bookmarks.
Rules we applied:
Private bookmarks
Actions: Create, Read, Update, Delete, Publish
Conditions:
Public bookmarks
Actions: Read
Conditions:
Question:
Has anyone faced this issue before?
How can we configure security rules so that private bookmarks are only visible to their owner, and not exposed to all users in the published app?
Thanks in advance for any guidance!
Os favoritos privados são visíveis para todos os usuários em aplicativos publicados (Qlik Sense Server)
Descrição:
Olá a todos,
Estamos enfrentando um problema com favoritos no Qlik Sense Server. Quando um usuário cria um favorito em Meus favoritos , ele se torna visível para todos os usuários no aplicativo publicado, em vez de permanecer privado.
Ambiente:
Qlik Sense Server (consulte a versão abaixo – por exemplo, maio de 2025)
Marcadores criados em um aplicativo publicado
O que esperamos:
Os favoritos salvos em Meus favoritos devem ficar visíveis somente para o usuário que os criou.
O que está acontecendo:
Qualquer marcador criado por um usuário fica visível para todos os outros usuários no mesmo aplicativo.
O que tentamos:
Criamos duas regras de segurança no QMC — uma para favoritos privados e outra para favoritos publicados — mas isso não resolveu o problema. Nenhuma outra regra personalizada está afetando os favoritos no momento.
Regras que aplicamos:
Favoritos privados
Ações: Criar, Ler, Atualizar, Excluir, Publicar
Condições:
Favoritos públicos
Ações: Ler
Condições:
Pergunta:
Alguém já enfrentou esse problema antes?
Como podemos configurar regras de segurança para que favoritos privados fiquem visíveis apenas para seus proprietários e não para todos os usuários do aplicativo publicado?
Agradecemos antecipadamente qualquer orientação!
Why the component tDBInput (and it's similar tOracleInput) doesn't have the "Use prepared statement" flag ?
tDBRow has this feature but the tDBInput doesn't.
How can I prevent sql injectjon without this basic feature ?
How can I abstract my queries from the specific dialect of the database if I cannot use prepared statements?
(using talend 8 upd 2025/07 - java 17)
Hallo zusammen,
ich habe Produktions-Mengen je Dienstleistung und Jahr und möchte die Differenz zum Vorjahr errechnen.
Ich benutze eine Pivot-Tabelle:
Die Formel für die Berechnung der Differenz zum Vorjahr lautet:
=Sum({$<[Jahr]={$(=year(today()))}>}[Menge])-Sum({$<[Jahr]={$(=year(today())-1)}>}[Menge])
Wie ihr seht, stimmt die Differenz nicht.
z.B müsste 2025 Kuvertieren 3000 sein.
Die Basistabelle sieht wie folgt aus:
Über Hilfe würde ich mich sehr freuen
Gruß Jörg
Looking for your next opportunity—or the perfect candidate? You’re in the right place! This forum connects employers, job seekers, and interns in the Qlik ecosystem.
Use the templates below to make your post clear and easy to find. Just copy the one that fits, fill in your details, and select the correct label:
Include location, role details, and contact info.
Add the correct label so your post reaches the right audience.
Follow up on any responses and close your post once the position is filled or your search is over.
If you’re part of the Qlik Academic Program or learned Qlik at your university, don’t forget to add the “Qlik Academic Program” label to your post, this helps others in the community spot you!
Happy connecting, and good luck!
Id class. value required A-B
123 A. 100. -100
123. B. 200
124 A. 500. -100
124. B. 600
Olá!
Estamos com problema atualmente relacionado aos bookmarks no meus favoritos, ou seja, o usuário salva um bookmark em seus favoritos, porém todos os usuários conseguem visualizar no aplicativo que esta publicado.
Utilizamos a versão QlikSense Server, no QMC criamos duas regras uma para bookmark privado e outra para bookmark publicado, porém sem sucesso. E não temos outra configuração que esteja relacionada aos bookmark:
Poderiam nos ajudar?
Regra para bookmark privado:
Ações: Create, Read, Update, Delete, Publish
Condições:Versão privada esta com esses critérios:
!resource.App.stream.Empty()
and resource.App.HasPrivilege("read")
and resource.objectType="bookmark"
and user = resource.owner
and !user.IsAnonymous()
Regra para bookmark publico:
Ações: Read
Condições:
!resource.App.stream.Empty()
and resource.App.HasPrivilege("read")
and resource.objectType="bookmark"
and resource.published = true
and !user.IsAnonymous()
Customers should use our professional services because these services provide direct expertise, ensure optimal product performance, and reduce risk during deployment, adoption, and ongoing use.
Here's a good thing to get your weekend started: a new episode of the Data Voyagers podcast!
We live in a time where data is everywhere but wisdom is rare. A time where more data is available. But, with all this power, are we thinking better or just… faster? The real challenge of the information age isn’t access to data, it’s knowing how to think with data.
In today's Episode, Igor Alcantara and Angelika Klidas welcome Kevin Hanegan to discuss critical thinking. Critical thinking isn’t just a nice-to-have, it’s the difference between blindly following numbers and truly understanding what they mean. Listen to this episode and check out how Critical Thinking can not only improve your business but make you a better citizen.
Subscribe to the Data Voyagers Podcast wherever you get your podcasts and share the show with friends and colleagues.
Episode post:
#12 - Critical Thinking: The Wisdom Beyond the Data | Podcasts
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/