Hello 
I got the following sample data:

CompanyCode    JournalNo.   ledgerType    entryType     Amount

010                     12345           4                    ttt___            699
010                     12345           2                    FSSA            599
010                     678               4                    GRP___       700
010                     5544             2                    GFD              400

I want to display in a stright table the journal numbers whose ledger type is not 4

the expected result is 

JournalNo.          Amount
12345                 599
5544                   400
678                     700

I created the following calculated dimension

aggr(only {<LedgerType ={4}, EntryType={GRP___}> + <LedgerType -={4}>}JournalNo.

I'm getting the following result

JournalNo.          Amount
12345                 699
12345                 599
5544                   400
678                     700

how can i exclude the line in blue?
I know it appeared because the journalNo. satisfies the condition LedgerType -= 4

Hy everyone! I am participatin in a university hachathon where we are analyzing public disaster relief funds alongside socieconomic indicators like HDI and population size.

As a data analysis student, I`d like to ask: What are the best practices or recommended data modeling techniques in Qlik Sense to combine public financial records with demographic indicators without causing synthetic keys or circular references? Thanks in advance!

Hi team,

We are shifting out Qlik Replicate servers from an OnPrem data centre to GCVE.

Or replication tasks that are writing to AWS S3 started returning an intermittent error message:

00031576: 2026-09-01T12:41:32 [FILE_FACTORY ]E:
Send request failed: Windows/WinHTTP error code is 12002: The operation timed out
. [1000100] (AWS_SDK_CPP Internal Logger:337)
00031576: 2026-09-01T12:41:32 [FILE_FACTORY ]E: Encountered network error when sending http request. [1001705] (anw_retry_strategy.cpp:170)

This error message happens from all our servers writing to S3 and it has an intermittent nature.  For example I can click "test connection" and it will fail the first two times and then work the third.  It almost seems like the connection needs to be warmed up.

Our network team speculates the timeout is resulting from a DNS request is not responding in time.  

We have tried updating the cdcIdleTimeout on the endpoint to a very high number; but this hasn't solved the problem.

Since the S3 connector is written on the AWS SDK - is there a way to potentially access properties like httpSocketTimeout through the endpoint to give Qlik more time waiting for a response?

Or any other idead if people have come across this problem before?

Hello,

I’ve configured a replication task that reads from a Log Stream and replicates data to a Snowflake target with Apply Changes Processing enabled, meaning that changes are applied directly to the target tables in Snowflake. The source of the Log Stream is an Oracle database.

Moreover, I’ve implemented a soft-delete logic in this task by adding a technical field defined as follows:

CASE ifnull(operation_indicator('DELETE','UPDATE','INSERT'),'null')

WHEN 'null' THEN 'INSERT'

ELSE operation_indicator('DELETE','UPDATE','INSERT') END

This is the soft-delete implementation described here: https://community.qlik.com/t5/Qlik-Replicate/Operation-Indicator-as-New-column/td-p/2061166.

Occasionally, operations are performed on the source that modify primary key fields. This is not a problem for Qlik Replicate, which correctly updates the corresponding record in the target table. However, this change is processed as an UPDATE. This can be a problem for consumers of the target table. If they read the table using an incremental approach, they have no indication that the record with the previous primary key has been modified or no longer exists. Therefore, if a downstream table is updated incrementally using a MERGE, this change will not be captured correctly.

I tried to investigate if it’s possible to transform the UPDATE into a DELETE of the record with the previous key, followed by an INSERT of the record with the new key. I found that this is possible for Change Tables populated using Store Changes Processing: “DELETE and INSERT when updating a primary key column: For tasks configured with streaming target endpoints (for example, Kafka), the DELETE+INSERT statements will be executed on the actual target. For all other target endpoints, they will be executed in the associated Change Tables. This option requires full supplemental logging to be turned on in the source database” (https://help.qlik.com/en-US/replicate/May2026/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_applychangtunestab.htm#ar_tasks_custom_1624443382_1694425).

However, I need to apply this logic directly to the target tables, rather than to Change Tables, using the soft-delete approach. This would allow consumers of the target table to identify that the record with the previous primary key no longer exists, even if they read the table incrementally (for example, by reading only the changes from the last day).

Is there a way to transform a primary key UPDATE into a DELETE + INSERT for regular target tables (not Change Tables)? Is there a way to achieve the same result using the soft-delete logic described above?

Thank you in advance for your support.

Best regards

Hi,

I have a 12 month line chart with this expression:

SUM({<MonthYear={">=$(=Date(MonthStart(Max(MonthYear),-11),'MMM-YY'))<=$(=Date(MonthStart(Max(MonthYear)),'MMM-YY'))"}>}[PDR %])

The dimension is MonthYear (essentially the last day of the month)

I want to add standard deviation as a reference line. This needs to adjust with the chart if a different MonthYear is selected, i.e. the standard deviation should be based on the 12 data points in the chart.

Many thanks

We recently wrapped a project embedding Qlik Sense analytics inside a client's customer-facing fintech mobile app (React Native shell, native modules where needed), and a few lessons cost us enough time that they're worth sharing. Posting here partly to sanity-check our conclusions against people who do this daily.

1. The iframe shortcut is a false economy on mobile.
Our first pass was the obvious one — single integration, sheet embedded via iframe in a webview. It worked in the demo and fell apart in the field: session handling inside mobile webviews was fragile (cookies getting dropped on iOS especially), pinch/scroll gestures fought the parent app, and load times on 4G were rough because we were pulling the whole sheet UI when users only needed two visualizations. We ended up rebuilding around qlik-embed / capability-API-style object-level embedding, rendering individual charts instead of full sheets. More work upfront, dramatically better UX.

2. Auth is the real project.
The embedding itself was maybe 30% of the effort. Getting identity right was the rest — the app has its own user accounts, so we needed the mobile session to map to a Qlik identity without ever showing users a second login. JWT-based auth against the tenant solved it, but token refresh inside a long-lived mobile session took real iteration: our first implementation silently expired mid-session and users saw blank chart areas with no error. Lesson: build the token-refresh and failure states first, not last. Blank rectangles destroy trust in the numbers faster than an honest "reconnecting" state does.

3. Section access pruning beats client-side filtering — but test the empty states.
Since this was financial data, row-level security was non-negotiable. Section access did what it promises, but the UX consequence surprised the client: users with narrow access sometimes hit legitimately empty visualizations, which looked like bugs. We added explicit "no data available for your accounts" states rather than letting default empty charts render. Small thing, big reduction in support tickets.

4. Mobile users don't explore — pre-aggregate for them.
Desktop Qlik users filter and dig. Mobile users glance. Session length data after launch confirmed it: median mobile session was well under a minute. We moved the most-requested answers (balance trends, category breakdowns) into small pre-filtered objects on the first screen and left deep exploration to a "full dashboard" view most users never open. Engagement went up when we showed less.

Open question for the board: for those embedding at object level in customer-facing apps — are you handling theming by duplicating apps per brand, via custom themes, or overriding at the embed layer? We went with embed-layer overrides to keep one master app, but curious whether that bites us at scale.

Happy to go deeper on the auth flow if anyone's fighting the same webview session issues.

Congratulations to Mária Oreská from Inphinity, for being this quarter's Women Who Qlik Voice of Impact! 

Each quarter, Women Who Qlik recognizes a member who exemplifies our mission to connect, support, and empower women and allies across the Qlik ecosystem. We’re proud to celebrate Mária for her leadership, creative use of Qlik, and passion for collaboration and knowledge sharing. From leading an international team on COVID-19 analytics to inspiring others to explore what’s possible with Qlik, Mária is a true champion of Women Who Qlik. Learn more about Mária below! 

What is a project or initiative you've worked on using Qlik that you're particularly proud of? 

One of the projects I’m most proud of was leading an international team of freelance Qlikkies who built a publicly available Qlik app with daily COVID data, country comparisons, and interactive analytics. I’m proud not only of what we built - as far as I know, the only publicly available truly interactive COVID analytics at the time - but also of how people from different countries came together voluntarily to help fight fear and anxiety with data. 

What's one Qlik tip, trick, or best practice you think every user should know? 

A few years ago, I’d have said Ctrl+00 for dummy data. But AI has that covered now.  So my tip is don’t wait for users to tell you exactly what they need. They’ll often ask for a faster horse. Show them the car. Show them what’s possible with Qlik Answers, automations, writeback, data pipelines, and more. 

What's one of your favorite memories from Qlik Connect? 

Only one? That's really tough. Nine years ago, at the end of my first Qonnections (Qlik Connect) (at the same place as this year) I said I'd come back as a speaker one day. This year, it finally happened, with two sessions! Standing on stage with Alex Walker and Nick Seagrave and hearing them speak so highly about our collaboration and the value Inphinity brought was something special. 

And yet, what really keeps bringing me back is the community - great people, friendly conversations with some of the best experts in the world, experienced people supporting the younger generation, and bright new minds eager to learn, contribute, and be part of it. 

What are you currently learning or exploring outside of work? 

I’m writing my first fiction novel - about a young woman who uses AI to write a book. So, I’m learning how to describe everything from a piece of dust floating in the air to complex emotions like anxiety and depression. 

Is there anything else you'd like to share? (Favorite books, TV series, hobbies, fun facts, or anything else you'd like the community to know!) 

I love puzzles with thousands of pieces, read fiction, recently started a local book club, and I’m still waiting for my letter from Hogwarts! And don't hesitate to reach out to me if you'd like to chat. 

Share your thoughts on Mária's amazing career and around her unique hobbies and interests in the comments below!

Hi,

I am using button object in layout container over a text object to apply some actions and sheet navigation in Qlik Cloud. This works perfectly in browser but not in SaaS mobile app. I have noticed that actions such as set variable value works perfectly in mobile app however only navigation functionality is not working either I choose sheet navigation or apply bookmark action.

Can anyone confirm that this is a known bug or please suggest some solution or workaround. 

Hi team,

We got the Vulnerability description below on Qlik sense server.

Path : C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage\gbq\lib\LibCurl64.DllA\libcurl.dll
Installed version : 7.84.0.0
Fixed version : 8.21.0

Could you please suggest whether this should done by window team or do we need to upgrade anything related to Qlik.

Thanks & Regards,

Irshad Ahmad