Discover

Good day Qlik Community,

Here I come again with another article and this one is about a new way to consume analytics, where apps and dashboards are not just more work added to already busy people, but part of their routine, driving everyday routine. Welcome to the era of Ambient Analytics.

You can read the article at Data Voyagers:

Ambient Analytics: Solving the Dashboard Fatigue Epidemic

If you like it, I ask you to share it. 

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?

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

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)

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.

How to Post

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:

• Jobs Seeking People
• People Seeking Jobs
• People Seeking Internships

• Companies Seeking Interns 

Tips for a Great Post

• 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.

Bonus for Academic Program Members

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!

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.

• Maximized Product Value and ROI
• Faster, Smoother Implementation
• Expert Knowledge and Best Practices
• Reduced Support Needs and Risk
• Stronger Partnership and Continuous Improvement

Explore Qlik Services Here!

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