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

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

Hi all,

when I download data from a table, I want the formatting to be applied as described here:

https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/DataExport/export-data.htm

This works fine with the old standard table. A dialog box appears where you can select advanced table formatting.

But this does not work with the simple table. There is no dialog box where you can select this option. Does anyone else have the same problem? I tried it with a simple table with few rows of data and no special formatting.

Thank you very much.

Hello everyone,

is it possible to use the QlikSAPConnector to extract data from an SAP S4/HANA 2025-System with SAP Basis 816, as in the documentation it's only specified for S4/HANA 2022. 

I'd appreciate any help!