Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Featured Content
-
High Five - September 2026, André Hamon
Featured Member · September 2026 Meet André, our September Featured Member This month, all eyes are on André, whose journey from New Zealand's... Show MoreFeatured Member · September 2026Meet André, our September Featured Member
This month, all eyes are on André, whose journey from New Zealand's insurance industry to the heart of London's data community shows exactly the kind of curiosity and drive that makes a great Qlik Community member. A dedicated Qlik customer for years, André brings real, hands-on experience to every thread he touches, and he's not shy about sharing it. We're thrilled to name him our Featured Member for September 2026!
André spent the last decade working in general insurance in New Zealand, starting out in underwriting before moving into BI and data. Most recently, he worked at Ando Insurance, where he worked across Qlik Cloud, Snowflake, and Salesforce, and embedded AI into BI workflows. While there, André had the opportunity to speak at Qlik Connect in 2024, and in 2025, Ando Insurance was recognized with the Qlik Organizational Transformation award at the Qlik Digital Transformation Awards Australia & New Zealand in Sydney.
“Explaining a set analysis expression, a load script pattern, or an automation block to someone else forces me to properly understand it.”
— André
For André, the Community has always been more than a resource, it's where he's worked through some of his toughest Qlik challenges over the years, usually by finding a thread where someone had already hit the same wall. Now, he pays it forward by answering questions himself, and he says he picks up plenty from other people's answers along the way too.
Outside of Qlik, André loves building things just for the fun of it, from a Raspberry Pi dev server to small apps and even a Qlik extension or two. He's also working on learning French (even after two months living in Lyon), and he's an avid tennis fan.
Thank you, André!
Thank you for bringing your expertise and generosity to the Qlik Community. Please join us in celebrating André as our September 2026 Featured Member, leave a comment below!
-
Qlik Sense Enterprise Scalability Tools
This tool is being deprecated, updates will be received during 2026, but thenceforth be considered deprecated. The Qlik Sense Enterprise Scalability T... Show MoreThis tool is being deprecated, updates will be received during 2026, but thenceforth be considered deprecated.
The Qlik Sense Enterprise Scalability Tools (QSEST) are used to create and run load and performance tests towards Qlik Sense Enterprise on Windows (QSEoW).Included parts are:
- Documentation on how to use the package
- Command line tool for Windows, Mac and Linux. This command line tool (gopherciser) is open source and can be found here .
- GUI for Windows and Linux.
Downloadable files can be found here:
📎 Qlik Sense Enterprise Scalability Tools
Qlik Sense documents to help analyze result and log files can be found here :https://community.qlik.com/docs/DOC-15451Change log
v1.14.1
- Bugfix for entering JWT key path
- Gopherciser v0.21.23 -> v0.22.2
- Avoid errors with JWT keys when running as wasm in GUI
- improved IPv6 handling
-
bugfixes
v1.14.0
- Added linux arm64 binaries
- Removed osx binaries
- Updated scheduler including support for linux arm64
- Support for QSEoW Nov 2025
- Gopherciser v0.20.1 -> v0.21.23
- Bugfixes
- Support nl insights objects
- Support Treedata calculation condition
- Add sn-nav-menu to supported objects.
- Add arm64 linux binaries
- Add scheduler and CPU metrics to prometheus pushed metrics
- Add configurable thinktime inbetween publishing and unpublishing sheets
- Add optional timeout settings to open app action
- Add possibility to generate empty script to template command
- Autodetect privatekey type and update default signing algorithm when using jwtsettings
- Support for PS256,PS384,PS512,ES256,ES384,ES512 and EdDSA JWT signing algorithms
- Duplicatesheet improvements
- Limit request concurrency while getting app structure
v1.13.0
- Gopherciser v0.18.7 -> v0.20.1
- QSEoW Nov24 support
- Support sn-tabbed-container object
- Openapp changed for Nov24 api compliance
- New default websocket reconnect backoff pattern
- Bugfixes
v1.12.0
- Updated scheduler
- Gopherciser v0.18.5 - v0.18.7
- performance enhancements
- new action stepdimension
Your use of Qlik Sense Enterprise Scalability Tools will be subject to the same license agreement between you and Qlik for your Qlik Sense License. Qlik does not provide maintenance and support services for the Qlik Sense Enterprise Scalability Tools, however please check QlikCommunity for additional information on use of these products.
-
Qlik MCP Just Got Smarter About Data Pipelines with Three New Lookup Tools for A...
Improving Declarative Pipeline Development If you've been building Qlik Talend Cloud pipelines declaratively with a coding agent like Anthropic's Clau... Show MoreImproving Declarative Pipeline Development
If you've been building Qlik Talend Cloud pipelines declaratively with a coding agent like Anthropic's Claude Code or OpenAI's Codex, then you already know the productivity win. And if you've coded for any length of time, then you may have encountered a friction point where your agent needed a real connection name, or a real table ID, or a real value from your tenant, and template placeholders just won't cut it. Until now, that meant tabbing out of VS Code, opening the Qlik Cloud web app, and hunting down the answer by hand.
That changes today. Qlik's MCP server has just added three new lookup tools built specifically for declarative data pipeline development, closing that gap by bringing real tenant context directly into your coding session.
New MCP Tools for Agentic Data Engineering
The three new MCP tools are as follows:
- qlik_search: Searches for Qlik catalog resources such as applications, datasets, data products, glossaries, etc. by name or content. This tool has been extended to also return pipeline projects and pipeline connections.
- qlik_get_pipeline_project_details: Returns the project’s binding values. Used to discover all of the details about a specific pipeline project
- qlik_search_connection_objects: List all source entities (tables, views) available in a data connection. Used to discover what data sources are available when configuring data pipeline tasks.
In practice, that means you can ask the tenant a question via your coding agent and get a straight answer: does this space exist, what's this connection actually called, what tables sit behind it. No more generating a pipeline against a guess and finding out it's wrong on import.
So now you can ask questions while you are developing like:
"Show me all available tables in our Sales database connection so I can decide which tables to include in the data pipeline."
And you'll receive context-aware answers as below:
Why it Matters
The benefit is simple: less time spent switching context and more time spent writing pipelines that work the first time. A data engineer working on a pipeline project can ask about spaces, connections, and table structures in natural language right in the editor and keep coding. That's a real efficiency gain for iterative development. It also directly addresses the top piece of feedback we heard during the original testing phase for declarative pipelines: many data engineers wanted a mechanism to introspect a live Qlik environment for information beyond their current pipeline project. So these tools fill that gap. They search, they describe, and they resolve. Delivering precise answers on the current Qlik environment, highlighting what is and isn't with data pipelines.
Available Now
The new tools for pipelines are live as of August 25th and work with any third-party coding agent connected to Qlik's MCP server, including Claude Code, GitHub CoPilot and Open AI's Codex. Note that if you're already building declarative pipelines and MCP is connected, then there's nothing new to set up. The tenant pipeline context is just there the next time you ask a question.
However, if you haven't tried declarative pipelines with a coding agent yet, then now's a good time to start. All the instructions for configuring your IDE, adding pipeline schemas, configuring Git Hub, and setting up MCP for coding agents can be found on the Qlik Developer portal here.
Furthermore, if you've not yet signed up for a Qlik Talend Cloud trial tenant, then you can register for free here too!
Finally, the only thing left for me to say is "Happy coding pipelines with enhanced MCP tools!". We know you're going to love it.
-
-
What's Next for Your AI Journey?
We hope you've enjoyed our Make Your Data Work for AI discussions! Every organization is at a different stage of its AI journey. What's the next mil... Show MoreWe hope you've enjoyed our Make Your Data Work for AI discussions! Every organization is at a different stage of its AI journey.
What's the next milestone you're working toward? It could be improving data quality, expanding adoption of agentic capabilities, demonstrating business value, strengthening governance, or launching a new use case.
If you haven't already, watch the Make Your Data Work for AI story here!
Tell us what's next for your team in the comments. Share your response for a chance to win a pair of sneakers. Winner announced August 14.
Recent Discussions
-
Change Uni-Directional Tasks to Bi-Directional in Qlik replicate
Hi ,I have created 100+ uni-directional tasks for data replication requirement. Now there is little change in requirement, I also need to replicate da... Show MoreHi ,
I have created 100+ uni-directional tasks for data replication requirement. Now there is little change in requirement, I also need to replicate data back to source in same tables to keep data sync on both sides. I want to change my tasks to bi-directional. Is there any way I could change exported JSON and then import so tasks become bi-directional. Or will need to create tasks again ?
Please if someone could help me in this.
Thank you -
High Five - September 2026, André Hamon
Featured Member · September 2026 Meet André, our September Featured Member This month, all eyes are on André, whose journey from New Zealand's... Show MoreFeatured Member · September 2026Meet André, our September Featured Member
This month, all eyes are on André, whose journey from New Zealand's insurance industry to the heart of London's data community shows exactly the kind of curiosity and drive that makes a great Qlik Community member. A dedicated Qlik customer for years, André brings real, hands-on experience to every thread he touches, and he's not shy about sharing it. We're thrilled to name him our Featured Member for September 2026!
André spent the last decade working in general insurance in New Zealand, starting out in underwriting before moving into BI and data. Most recently, he worked at Ando Insurance, where he worked across Qlik Cloud, Snowflake, and Salesforce, and embedded AI into BI workflows. While there, André had the opportunity to speak at Qlik Connect in 2024, and in 2025, Ando Insurance was recognized with the Qlik Organizational Transformation award at the Qlik Digital Transformation Awards Australia & New Zealand in Sydney.
“Explaining a set analysis expression, a load script pattern, or an automation block to someone else forces me to properly understand it.”
— André
For André, the Community has always been more than a resource, it's where he's worked through some of his toughest Qlik challenges over the years, usually by finding a thread where someone had already hit the same wall. Now, he pays it forward by answering questions himself, and he says he picks up plenty from other people's answers along the way too.
Outside of Qlik, André loves building things just for the fun of it, from a Raspberry Pi dev server to small apps and even a Qlik extension or two. He's also working on learning French (even after two months living in Lyon), and he's an avid tennis fan.
Thank you, André!
Thank you for bringing your expertise and generosity to the Qlik Community. Please join us in celebrating André as our September 2026 Featured Member, leave a comment below!
-
Looking for the Best AI Coding Assistant for Beginners
Hi everyone, I'm new to this community, so I hope this is the right place to ask. I'm currently learning programming and am looking for a reliable AI ... Show MoreHi everyone,
I'm new to this community, so I hope this is the right place to ask.
I'm currently learning programming and am looking for a reliable AI coding assistant that can help me write, understand, and debug code. Since I'm still a beginner, I'd prefer a tool that's easy to use and can explain concepts, suggest code improvements, and help fix errors.
If you've used any AI coding assistants that you'd recommend, I'd really appreciate your suggestions and experiences.
Thank you in advance!
-
Qlik Alerting - User Group 관련 질의
안녕하세요. 당사에서는 Qlik을 단순 Dashboard 조회 목적이 아닌 사용자 Role 기반 Dashboard 및 Alerting/NPrinting 서비스로 활용하고 있습니다. 이에 따라 Role별로 조회 가능한 Qlik Dashboard와 수신 가능한 Aler... Show More안녕하세요.
당사에서는 Qlik을 단순 Dashboard 조회 목적이 아닌 사용자 Role 기반 Dashboard 및 Alerting/NPrinting 서비스로 활용하고 있습니다.
이에 따라 Role별로 조회 가능한 Qlik Dashboard와 수신 가능한 Alerting/NPrinting을 구분하여 관리하는 것이 중요합니다.
현재 Qlik Alerting의 User Group 관리 및 AD Security Group 연동과 관련하여 아래와 같은 개선사항을 요청드립니다.
1. User groups 목록 조회 제한 개선
현재 Admin > User management > User groups 경로에서 회사 내 Role별로 User Group을 생성하여 관리하고 있습니다.
당사에서는 약 80개의 Role을 User Group으로 생성하였으나, User groups 페이지에서는 최대 50개의 Group만 조회되고 있습니다.
또한 Alert 리스트와 달리 User groups 페이지에는 Show More 또는 Pagination과 같은 추가 목록 조회 기능이 제공되지 않아, 50개를 초과하는 전체 Group 목록을 확인하기 어렵습니다.
개선 요청
User groups 페이지에서도 생성된 전체 User Group을 조회할 수 있도록 기능 개선을 요청드립니다.
예를 들어 아래와 같은 기능이 제공되면 좋을 것 같습니다.
- Pagination 또는 Show More
- 전체 Group 목록 조회 가능해야 함
2. User Group 검색 기능 개선
Alert의 수신자를 설정할 때 User Group의 개수가 많기 때문에 검색 기능을 사용하고 있습니다.
그러나 현재 Alert의 수신자 설정 화면에서는 Group Name의 일부만 입력하여 검색할 경우 검색 결과가 조회되지 않는 문제 및 Assigned된 Group 리스트가 일부만 보이는 문제가 있습니다.
예를 들어
ADMIN이라는 Group을 검색하기 위해ADM만 입력하면ADMINGroup이 검색 결과에 표시되지 않습니다.반면, Admin > User management > User groups 화면에서는
ADM과 같이 Group Name의 일부만 입력해도 해당 문자열이 포함된 Group들이 정상적으로 검색됩니다.개선 요청
Alert의 수신자 설정 화면에서도 User groups 관리 화면과 동일하게 Partial Match / Contains 방식의 검색이 가능하도록 개선을 요청드립니다.
예를 들어:
- 검색어:
ADM - 검색 결과:
ADMIN,ADMINISTRATOR,ADM_ENGINEER등ADM을 포함하는 모든 Group
즉, Group의 정확한 Full Name을 입력하지 않더라도 검색어가 Group Name에 포함되어 있으면 해당 Group이 검색 결과에 표시되도록 개선되면 좋겠습니다.
3. AD Security Group과 Qlik / Qlik Alerting / Qlik NPrinting 간 자동 연동
당사에서는 AD Manager를 통해 특정 OU 하위에 Role별 Security Group을 구성하여 사용하고 있습니다.
각 Security Group에는 해당 Role을 보유한 구성원의 AD ID가 포함되어 있으며, 따라서 AD에서는 각 사용자가 어떤 Role에 속해 있는지에 대한 정보를 이미 관리하고 있습니다.
현재는 이러한 AD Security Group 정보를 Qlik, Qlik Alerting, Qlik NPrinting에서 직접 활용하기 어려운 것으로 보입니다.
그 결과, 현재는 관리자가 Qlik Alerting에 Role별 User Group을 별도로 생성하고, 인사이동이나 조직변경이 발생할 때마다 각 Group의 구성원을 수동으로 수정해야 합니다.
개선 요청
AD의 Security Group 정보를 Qlik 플랫폼에서 직접 활용할 수 있도록 AD Security Group과 Qlik / Qlik Alerting / Qlik NPrinting 간의 연동 기능을 제공해 주실 것을 요청드립니다.
예를 들어 아래와 같은 방식의 연동을 고려해 주시면 좋겠습니다.
AD Security Group
→ Role별 구성원 관리
→ Qlik / Qlik Alerting / Qlik NPrinting에서 해당 Group 정보 활용이를 통해 관리자가 각 제품에서 User Group 및 사용자 정보를 개별적으로 관리하지 않고, 회사 AD의 Role 정보를 Single Source of Truth로 활용할 수 있을 것으로 생각합니다.
특히 당사와 같이 Qlik을 Role-based Dashboard 및 Notification Platform으로 활용하는 환경에서는 다음과 같은 기능이 중요합니다.
- Role별 Qlik Dashboard 접근 권한 관리
- Role별 Qlik Alerting 수신자 설정
- Role별 Qlik NPrinting 수신자 설정
- 조직/인사변동 발생 시 사용자 권한 및 수신자 정보 자동 반영
- 관리자의 수동 User Group 관리 업무 최소화
현재와 같이 관리자가 각 시스템에서 Role 및 사용자를 수동으로 관리하는 방식은 Role 및 사용자 수가 증가할수록 관리 부담과 운영 오류 가능성이 커질 수 있습니다.
따라서 AD Security Group을 Qlik 플랫폼의 User Group과 연계하여 자동으로 동기화할 수 있는 기능을 제공한다면, Enterprise 환경에서 Qlik을 Role 기반으로 운영하는 고객에게 상당히 유용한 기능이 될 것으로 생각합니다.
-
-
Qlik Sense 11/2024: How can we automatically configure Qlik to update the script...
When you create a new App this is what gets created in the script section:SET ThousandSep=',';SET DecimalSep='.';SET MoneyThousandSep=',';SET MoneyDec... Show MoreWhen you create a new App this is what gets created in the script section:
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;-$#,##0.00';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET FirstWeekDay=6;
SET BrokenWeeks=1;
SET ReferenceDay=0;
SET FirstMonthOfYear=1;
SET CollationLocale='en-US';
SET CreateSearchIndexOnReload=1;
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';
SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';I want to add a line that is basically a $(Must_Include) statement that loads a controlled standard QVS file, that will force our script standards during App creation across all Apps.
What file & location do I need to add this logic?
-
Start task from timestamp in Qlik Replicate for DB2 LUW
Qlik Replicate: May 2025 (2025.5.0.247)Source: IBM DB2 LUW 11.5.9Target: IBM DB2 (ODBC)Architecture: Log Stream Staging → Downstream CDCBackgroundWe a... Show MoreQlik Replicate: May 2025 (2025.5.0.247)
Source: IBM DB2 LUW 11.5.9
Target: IBM DB2 (ODBC)
Architecture: Log Stream Staging → Downstream CDCBackground
We are implementing replication for approximately 35 DB2 LUW databases between MAIN and DR using Qlik Replicate Log Stream Staging + downstream CDC.
The requirement is to keep replication ready in both directions. Application traffic will be active on only one server at a time (MAIN or DR), but we need the replication infrastructure to remain synchronized so that traffic can be switched between servers without rebuilding the replication setup.
1. Start from Timestamp
We tried to start a Log Stream Staging task from a specific timestamp using both:
Replicate UI → Advanced Run Options → Start processing changes from Date and Time
Qlik Enterprise Manager (QEM) API
Both return the following error:
"start from timestamp was blocked, when using IBM DB2 LUW as source endpoint, ‘start from timestamp’ is only supported if change was captured after the CDC task started."
Could someone clarify the expected behavior for timestamp-based positioning with DB2 LUW, particularly with a Log Stream Staging → downstream CDC architecture?
2. Log Stream Task Cannot Start
To keep the replication infrastructure ready in both directions, we started the DR → MAIN Log Stream tasks.
For 25 out of 35 databases, we have:
MAIN → DR Log Stream: Running
MAIN → DR CDC: Running
DR → MAIN Log Stream: Running
However, for the remaining 10 databases, the DR → MAIN Log Stream task cannot start. The console only shows:
"Task cannot be started"
There are no additional useful errors in the console.
The affected databases are on the same DB2 server and have the same general configuration as the databases where the tasks are working successfully.
Could someone advise what could cause this behavior for only specific DB2 databases and how we can obtain more detailed diagnostics?
Any guidance on these two issues would be greatly appreciated.
-
QlikReplicate + PostgreSQL and "WAL heartbeat" advanced connection properties
Hi,We have enabled the "WAL heartbeat" option in the source endpoint’s "Advanced Connection Properties". According to the documentation, this should m... Show MoreHi,
We have enabled the "WAL heartbeat" option in the source endpoint’s "Advanced Connection Properties". According to the documentation, this should manage the WAL increase when no activity occurs (classic logical replication issue with PostgreSQL WAL).
However, in our tests, when we stop data injection into the source database, the WAL usage continues to grow indefinitely. Eventually, the replication slot is lost once the "max_slot_wal_keep_size" limit is reached.
No other connection occured on the DB during our test, QlikReplicate's slot is the only connection.
When removing the slot, WAL stay flat around 0. -
Charts for Root Cause Analysis in Qlik Sense / Cloud
Root cause analysis lives or dies on chart choice. Check out this visual reference on the 7 charts built for exactly that, on LinkedIn: 👉 https://www... Show MoreRoot cause analysis lives or dies on chart choice.
Check out this visual reference on the 7 charts built for exactly that, on LinkedIn:
👉 https://www.linkedin.com/posts/antonbaranchuk_root-cause-analysis-charts-in-qlik-power-ugcPost-7486028502102892544-nVvc/ -
Qlik Sense repository service consuming full RAM in the central node
Hi All,Qlik Sense repository service is consuming full memory in the server and causing node down.Any idea why would repository service would consume ... Show MoreHi All,
Qlik Sense repository service is consuming full memory in the server and causing node down.
Any idea why would repository service would consume full memory?
Current observation is repository service is gradually consuming full memory in the server. From resource monitor I could see that most memory is consumed while connecting to the dedicated postgres repository database.
Kindly provide any suggestion where should I start checking ?
Thanks.
-
Qlik Sense Desktop 15.13.14 - Error 1003 when opening QVF files from UNC network...
Hello Qlik Support,We are experiencing an issue with Qlik Sense Desktop 15.13.14 when opening QVF files directly from a network share.EnvironmentQlik ... Show MoreHello Qlik Support,
We are experiencing an issue with Qlik Sense Desktop 15.13.14 when opening QVF files directly from a network share.
Environment
- Qlik Sense Desktop 15.13.11 (working)
- Qlik Sense Desktop 15.13.14 (failing)
- Windows 10/11
- Network share: \\file\...Issue
Users running Qlik Sense Desktop 15.13.14 receive the following error when opening QVF files directly from the network share:
Error 1003App not foundCould not find appFindings- The issue is reproducible across multiple users.
- The issue occurs with multiple QVF applications.
- Qlik Sense Desktop 15.13.11 can open the same QVF files from the same network share without any issues.
- The applications are not corrupted.
- If the same QVF file is copied locally (for example under the user's Documents\Qlik folder), it opens successfully using version 15.13.14.
- The failure only occurs when opening the application directly from the UNC path.
RequestBased on our testing, this appears to be a regression introduced between versions 15.13.11 and 15.13.14, specifically affecting QVF files stored on network shares.
Could you please advise:
- Whether this is a known issue.
- If any changes were introduced regarding UNC/network path access in these versions.
- Whether there is a workaround available.
- If a defect has already been identified and fixed in a newer release.
Thank you for your assistance.
Best regards,
Panagiotis Alexandrou
-
Not all records loaded during reload.
Hi All,I've noticed that after the reload of today that a lot of records are not loaded in the dashboard.The selection is the same as the previous day... Show MoreHi All,
I've noticed that after the reload of today that a lot of records are not loaded in the dashboard.
The selection is the same as the previous days and also the file was available.
This is a part of the log of Yesterday.
I load 2 files in the table.
In the first file are 33,598,635 records.
The second file 56,329,459 - 33,598,635 = 22,730,824 records.
33,598,635 lines fetched
20260903T112456.545+0200 1230 next
20260903T112456.546+0200 1180 let vFile = 'TRX_H_' & 2026 & '.QVD'
20260903T112456.550+0200 1181 concatenate
20260903T112456.550+0200 1182 TRX_H:
20260903T112456.550+0200 1183 LOAD
20260903T112456.550+0200 1184 AutoNumber(TRX_H_TYPE & TRX_H_DTME & TRX_H_DTMJ & TRX_H_DTMM & TRX_H_DTMD & TRX_H_UURT & TRX_H_STNR & TRX_H_REF & TRX_H_SEQ,'Key_TRXD') as Key_TRXD,
20260903T112456.550+0200 1185 AutoNumber(TRX_H_TYPE & TRX_H_DTME & TRX_H_DTMJ & TRX_H_DTMM & TRX_H_DTMD & TRX_H_UURT & TRX_H_STNR & TRX_H_REF & TRX_H_SEQ,'Key_TRXF') as Key_TRXF,
20260903T112456.550+0200 1186
20260903T112456.550+0200 1187
20260903T112456.550+0200 1188
20260903T112456.550+0200 1189
20260903T112456.550+0200 1190
20260903T112456.550+0200 1191 num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00'),TRX_H_DTMM,TRX_H_DTMD)) as Datumtransactie,
20260903T112456.550+0200 1192
20260903T112456.550+0200 1193 if(0 = 1,
20260903T112456.550+0200 1194 Applymap('PBY_Map',num(TRX_H_STNR,'00000') & Left(num(TRX_H_REF,'0000000000'),4),num(Today())),
20260903T112456.550+0200 1195 num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00') ,TRX_H_DTMM , TRX_H_DTMD))) as DatumNum,
20260903T112456.550+0200 1196
20260903T112456.550+0200 1197
20260903T112456.550+0200 1198 Left(num(TRX_H_UURT,'000000'),2) & ':' & Mid(num(TRX_H_UURT,'000000'),3,2) as Uur_Getankt,
20260903T112456.550+0200 1199
20260903T112456.550+0200 1200 Left(num(TRX_H_UURT,'000000'),2) as Uur,
20260903T112456.550+0200 1201 Left(num(TRX_H_UURT,'000000'),2) & ':' & mid(num(TRX_H_UURT,'000000'),3,2) & ':' & left(num(TRX_H_UURT,'000000'),2) as UurSec,
20260903T112456.550+0200 1202 num(TRX_H_STNR,'00000') as Stationnummer,
20260903T112456.550+0200 1203
20260903T112456.550+0200 1204
20260903T112456.550+0200 1205
20260903T112456.550+0200 1206 if(TRX_H_SHF=0, 'Terminal', TRX_H_SHF) as Shift_Id,
20260903T112456.550+0200 1207 TRX_H_STNR & '-' & if(len(trim(TRX_H_OPID)) = 0 or TRX_H_OPID = ' ' ,'Terminal', trim(TRX_H_OPID)) as Operator_Id,
20260903T112456.550+0200 1208 if(len(trim(TRX_H_OPID)) = 0 or TRX_H_OPID = ' ' ,'Terminal', 'Shop') as Terminal_Shop,
20260903T112456.550+0200 1209
20260903T112456.550+0200 1210
20260903T112456.550+0200 1211
20260903T112456.550+0200 1212
20260903T112456.550+0200 1213 TRX_H_CUST as KeyCust,
20260903T112456.550+0200 1214 if(len(trim(TRX_H_ID)) > 0,TRX_H_ID, TRX_H_PAN) as Firmakaart,
20260903T112456.550+0200 1215 'KL' & num(TRX_H_CUST,'00000') as Klant_Lev_Nummer,
20260903T112456.550+0200 1216 applymap('KLANT_MAP', 'KL' & num(TRX_H_CUST,'00000'),'UNKNOWN') as Klant_Naamtest,
20260903T112456.550+0200 1217 TRX_H_PAN,
20260903T112456.550+0200 1218
20260903T112456.550+0200 1219 TRX_H_ODO as Km_Stand,
20260903T112456.550+0200 1220
20260903T112456.550+0200 1221 TRX_H_CARR as Plaatnummer,
20260903T112456.550+0200 1222 TRX_H_TTNA as TRXHTotal
20260903T112456.550+0200 1223 FROM
20260903T112456.550+0200 1224 [..\03_QVD\TRX_H_2026.QVD]
20260903T112456.550+0200 1225 (qvd)
20260903T112456.550+0200 1226 where num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00'), TRX_H_DTMM,TRX_H_DTMD)) >= 45658 and len(trim(TRX_H_STNR)) > 0 and TRX_H_STNR <= '1000'
20260903T112456.555+0200 19 fields found: Key_TRXD, Key_TRXF, Datumtransactie, DatumNum, Uur_Getankt, Uur, UurSec, Stationnummer, Shift_Id, Operator_Id, Terminal_Shop, KeyCust, Firmakaart, Klant_Lev_Nummer, Klant_Naamtest, TRX_H_PAN, Km_Stand, Plaatnummer, TRXHTotal,
20260903T114353.975+0200 56,329,459 lines fetchedThis is the a part of the log of the reload of today.
Also in the first file I have less records then the day before (it should be more)
And in the second file I have almost no records loaded.
30,883,385 lines fetched
20260904T062431.542+0200 1230 next
20260904T062431.559+0200 1180 let vFile = 'TRX_H_' & 2026 & '.QVD'
20260904T062431.590+0200 1181 concatenate
20260904T062431.590+0200 1182 TRX_H:
20260904T062431.590+0200 1183 LOAD
20260904T062431.590+0200 1184 AutoNumber(TRX_H_TYPE & TRX_H_DTME & TRX_H_DTMJ & TRX_H_DTMM & TRX_H_DTMD & TRX_H_UURT & TRX_H_STNR & TRX_H_REF & TRX_H_SEQ,'Key_TRXD') as Key_TRXD,
20260904T062431.590+0200 1185 AutoNumber(TRX_H_TYPE & TRX_H_DTME & TRX_H_DTMJ & TRX_H_DTMM & TRX_H_DTMD & TRX_H_UURT & TRX_H_STNR & TRX_H_REF & TRX_H_SEQ,'Key_TRXF') as Key_TRXF,
20260904T062431.590+0200 1186
20260904T062431.590+0200 1187
20260904T062431.590+0200 1188
20260904T062431.590+0200 1189
20260904T062431.590+0200 1190
20260904T062431.590+0200 1191 num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00'),TRX_H_DTMM,TRX_H_DTMD)) as Datumtransactie,
20260904T062431.590+0200 1192
20260904T062431.590+0200 1193 if(0 = 1,
20260904T062431.590+0200 1194 Applymap('PBY_Map',num(TRX_H_STNR,'00000') & Left(num(TRX_H_REF,'0000000000'),4),num(Today())),
20260904T062431.590+0200 1195 num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00') ,TRX_H_DTMM , TRX_H_DTMD))) as DatumNum,
20260904T062431.591+0200 1196
20260904T062431.591+0200 1197
20260904T062431.591+0200 1198 Left(num(TRX_H_UURT,'000000'),2) & ':' & Mid(num(TRX_H_UURT,'000000'),3,2) as Uur_Getankt,
20260904T062431.591+0200 1199
20260904T062431.591+0200 1200 Left(num(TRX_H_UURT,'000000'),2) as Uur,
20260904T062431.591+0200 1201 Left(num(TRX_H_UURT,'000000'),2) & ':' & mid(num(TRX_H_UURT,'000000'),3,2) & ':' & left(num(TRX_H_UURT,'000000'),2) as UurSec,
20260904T062431.591+0200 1202 num(TRX_H_STNR,'00000') as Stationnummer,
20260904T062431.591+0200 1203
20260904T062431.591+0200 1204
20260904T062431.591+0200 1205
20260904T062431.591+0200 1206 if(TRX_H_SHF=0, 'Terminal', TRX_H_SHF) as Shift_Id,
20260904T062431.591+0200 1207 TRX_H_STNR & '-' & if(len(trim(TRX_H_OPID)) = 0 or TRX_H_OPID = ' ' ,'Terminal', trim(TRX_H_OPID)) as Operator_Id,
20260904T062431.591+0200 1208 if(len(trim(TRX_H_OPID)) = 0 or TRX_H_OPID = ' ' ,'Terminal', 'Shop') as Terminal_Shop,
20260904T062431.591+0200 1209
20260904T062431.591+0200 1210
20260904T062431.591+0200 1211
20260904T062431.591+0200 1212
20260904T062431.591+0200 1213 TRX_H_CUST as KeyCust,
20260904T062431.591+0200 1214 if(len(trim(TRX_H_ID)) > 0,TRX_H_ID, TRX_H_PAN) as Firmakaart,
20260904T062431.591+0200 1215 'KL' & num(TRX_H_CUST,'00000') as Klant_Lev_Nummer,
20260904T062431.591+0200 1216 applymap('KLANT_MAP', 'KL' & num(TRX_H_CUST,'00000'),'UNKNOWN') as Klant_Naamtest,
20260904T062431.591+0200 1217 TRX_H_PAN,
20260904T062431.591+0200 1218
20260904T062431.591+0200 1219 TRX_H_ODO as Km_Stand,
20260904T062431.591+0200 1220
20260904T062431.591+0200 1221 TRX_H_CARR as Plaatnummer,
20260904T062431.591+0200 1222 TRX_H_TTNA as TRXHTotal
20260904T062431.591+0200 1223 FROM
20260904T062431.591+0200 1224 [..\03_QVD\TRX_H_2026.QVD]
20260904T062431.591+0200 1225 (qvd)
20260904T062431.591+0200 1226 where num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00'), TRX_H_DTMM,TRX_H_DTMD)) >= 45658 and len(trim(TRX_H_STNR)) > 0 and TRX_H_STNR <= '1000'
20260904T062431.629+0200 19 fields found: Key_TRXD, Key_TRXF, Datumtransactie, DatumNum, Uur_Getankt, Uur, UurSec, Stationnummer, Shift_Id, Operator_Id, Terminal_Shop, KeyCust, Firmakaart, Klant_Lev_Nummer, Klant_Naamtest, TRX_H_PAN, Km_Stand, Plaatnummer, TRXHTotal,
20260904T062456.643+0200 31,170,105 lines fetchedWho has an idea why he is not loading all data?
The data is the transaction header out of a shop. So every day there should be more records.
If I doe now a reload of the trx_h_2026 with the same selections in my desktop, this is the result.
Who can help me with this?
-
Azure Blob storage connection is failing due to large size of csv files
Dear Qlik team,Our goal is to create a replicate task in Qlik Data Integration and the source data is present in Azure Cloud storage. We are capturing... Show MoreDear Qlik team,
Our goal is to create a replicate task in Qlik Data Integration and the source data is present in Azure Cloud storage. We are capturing the data from multiple csv files from Azure blob storage. We have successfully created the connections for other folders/tables and we have replicated the data. But for one particular folder contains csv files which are 1.2 - 1.8 GB each, we are unable to create the connection.
Is there a limitation on file size? or Is there any setting that we need to enable/disable?
-
tSalesforceBulkExec: missing salesforce_id / error in output
Hello, We upgrade this summer our Talend Cloud Studio from 7.3.1 to 8.0.1R2026-06. I'm trying to create a new job to put data in Salesforce using the ... Show MoreHello,
We upgrade this summer our Talend Cloud Studio from 7.3.1 to 8.0.1R2026-06.
I'm trying to create a new job to put data in Salesforce using the tSalesforce bulk components, and specifically the tSalesforceBulkExec.
I put it on the designer, select the existing connection, choose the module to update and import the schema from my tSalesforceOutputBulk in the "Schema".
When I use the MAIN and Reject output of the tSalesforceBulkExec (or check the "Schema MAIN" & "Reject Schema" in Basic Settings), I have the input schema, but the following automatic columns are missing :
- MAIN : salesforce_id & salesforce_created
- Reject : error
Is this a standard behavior or a regression ?
I try to click on the "Guess schema", but I got compilation error for this specific action (the job compile without error)
Edit Sept 07 : it also seems that it does not handle well when one/some fields contains lines returns. When everythings was alright in 7.3.1
We generate the file with a tFileOutputDelimited (with a specific configuration) and use the API Bulk V2 to avoid this problem, but the global values NB_SUCCESS / NB_REJECT / NB_LINE aren't set in V2.
-
Possible Syntax Error. Dynamic Date for bookmark
Hello good people of the Qlik Community We have a Year drop down and the User can select the Year they want to view. The problem is that it defaults t... Show MoreHello good people of the Qlik Community
We have a Year drop down and the User can select the Year they want to view.
The problem is that it defaults to year 2023 when entering the sheet.
We want to change it to use a dynamic value GL.Year = Year((Today(0)). but when doing so, the expression is blank on the bookmark.
What am I missing?
Here's some screenshots to illustrate. Heres the bookmark
Here's an example where it's hardcoded a year. We don't want a hardcoded year, would like to have Year(Today(0)) to keep it dynamic
I'm able to achieve this using the Action, but it only applies to one sheet in a application. Looking for more of a "global" config where all sheets in the app use Year(today(0)) as the Year selection
Cheers!
-
New video - Manage Qlik Automations with Claude and Qlik MCP Server
Wanted to flag this for anyone working with Qlik Automations: Qlik has added new automation-management tools to the Qlik MCP Server, along with a set ... Show MoreWanted to flag this for anyone working with Qlik Automations: Qlik has added new automation-management tools to the Qlik MCP Server, along with a set of open-source Agentic Skills (qlik-oss/agentic-skills) that teach coding agents how to use them properly.
In this episode of Data Voyagers, I use Claude Code with the Qlik Automation Builder skill to create a Qlik Automation that reloads every Table Recipe in a Shared Space, then go back and edit it, testing along the way so you can see exactly what the agent does at each step.
If you're maintaining automations by hand today, or just want to see what an agent-built one actually looks like under the hood, it's worth the 19 minutes.
Watch it here: https://youtu.be/FwgpjHETWHU
The skills are open source and on GitHub if you want to try them in your own tenant.
Regards,Mark Costa
-
[ARTICLE] How to identify duplicated fields in Qlik Cloud ?
After a long wait, Qlik Cloud has finally introduced a feature that can save a LOT of time for developers! 🙌When loading data, if a field is duplicat... Show MoreAfter a long wait, Qlik Cloud has finally introduced a feature that can save a LOT of time for developers! 🙌
When loading data, if a field is duplicated, Qlik now tells you exactly which field is causing the problem. 🎯
Before this update, I had to manually search for the duplicated field — and sometimes there were hundreds of fields to go through. 😩🔎
Now? Qlik simply shows you the exact name of the duplicated field. 💥
Less manual work.
Less frustration.
More time to focus on what really matters: building things. 👨💻⚡
This may look like a small improvement, but for anyone working with large data loads, it’s a BIG deal! 🚀 -
Qlik Sense | Popup Message
Hi All,Basically am looking out for dynamic message box popup functionality where I can display any dynamic message externally.There should not be any... Show MoreHi All,
Basically am looking out for dynamic message box popup functionality where I can display any dynamic message externally.
There should not be any dependency on script/code changes from backend or front end in app.
I am trying to make changes in .txt or .xlsx external file which will be directly visible into app.
If i enter and dynamic message in .txt file and enable show option then it will show popup message on dashboard homepage and if i disable show option then popup message will be disappeared.
Regards,
KK
-
Select in Field Action - wildcard value in Search String
Hi All,I want to pass a value in Search String of the Select in Field Action, which is dynamic and changes frequently.Let's say, the field name is Pro... Show MoreHi All,
I want to pass a value in Search String of the Select in Field Action, which is dynamic and changes frequently.
Let's say, the field name is Product and it has value is in format 'Medicine_*'. Today it can be 'Medicine_Tablet', the next day it can be 'Medicine_Capsule', some other day it can be 'Medicine_Cream'.
Each day has a unique 'Medicine_*' value.
What Function/How would be the value/function in Search String value?
Select in Field - PRODUCT
Search String - 'Medicine_*'
-
Qlik Sense interactive displays on Windows 10 Kiosk
i am looking to setup a couple interactive QlikSense dashboards per business request and would like to use Windows 10 Kiosk mode. i am not familiar en... Show Morei am looking to setup a couple interactive QlikSense dashboards per business request and would like to use Windows 10 Kiosk mode. i am not familiar enough with the program to know if it would be best to use the app or browser interface. my users are using via browser (chrome i believe).
@support any advisement on Kiosk configuration?
