Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a use case where I display a roster using a pivot table. Y axis shows people and X axis shows the date and the measure shows the type of shift. I want to allow the user to select a cell (measure) on the chart and qlik should "filter" the chart dimensions of the measure intersect.
Currently I have to select the person row and then the date column for the chart to show the single shift. I want the reverse of this; click the shift (measure) and the chart filters to the person/date.
Thanks in advance.
Hi Team,
I am working on a Qlik Sense workflow application where data is loaded from a single source file and split into multiple logical tables associated through: Key Delivery.
I am using Straight tables for source/master data display
writeback tables for user updates
At the same time, users are expected to manually update operational fields through writeback tables.
My Question:
can editable/writeback columns be reliably used as filter pane fields in Qlik Sense?
or is it recommended that filters should only come from stable source/master data tables, while writeback tables should only store operational/manual update fields?
I would like to understand:
Best Practice
performance impact
data consistency
recommended enterprise design approach
Thanks
Hello Techies ,
Attached Sales Analysis - QVF file , I have generated from Qlik Cloud - Demo App . Now I am looking forward for the real data set for adding some changes and re-load it with more graphics. Not sure how to get actual data set in .csv format for this app or even any other demo app with dataset e.g. Financial Analysis or Supply Chain Analysis.
Appreciate your assistance.
#demoapps #demodata #qlikapps
Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight on Migrating to Qlik Cloud.
Questions:
Resources:
Did we answer your question? Let us know by clicking the like button!
Click here to see video transcript
Hello team,
I need your advice on the Qlik administration part, specifically regarding licenses.
For Qlik Sense: We have approximately 8000 licenses available. When we grant access to individual user IDs, the total count decreases. However, when adding an AD group, no licenses are deducted. Any insights on why this is happening?
For QlikView: We use Named CALs, totaling around 750 licenses. When we add individual user IDs, the total count decreases, but the same doesn't happen when adding an AD group.
Your advice would be greatly appreciated. Thank you!
Regards,
Ricky K
Thanks to those other links in the Qlik community, I managed to configure the connection between Entra ID and Qlik Sense through OIDC :
- Qlik Sense for Windows: How to configure OIDC with... - Qlik Community - 1812401
- How To: Configure Qlik Sense Enterprise SaaS to us... - Qlik Community - 1704442
However, I still have a problem with claims. When I disable OIDC optional claims, I can login successfully, but when I add them back to have information about my users such as email or display name, I have an error 400.
Did someone manage to make it work ?
We are having issues attempting to set up an Azure MSSQL database source - when testing the connection we receive the following error from Qlik (v2025.11):
RetCode: SQL_ERROR SqlState: FA004 NativeError: 0 Message: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Failed to authenticate the user '8ffcd3a2-3e1b-4d6a-9ef0-993832e9c228' in Entra ID (Authentication option is 'ActiveDirectoryServicePrincipal').
00000945: 2026-05-12T17:17:09:683127 [AT_GLOBAL ]I: Qlik Replicate Server Log (V2025.11.0.285 3b9bf2f6ae88 Linux 6.12.13-200.fc41.aarch64 #1 SMP PREEMPT_DYNAMIC Sat Feb 8 20:30:50 UTC 2025 x86_64 64-bit, Revision:3a2220d5f81c24e3e19825b06ce8db2bbe0c9b7d, PID: 944) started at Tue May 12 17:17:09 2026 (at_logger.c:2763)
00000945: 2026-05-12T17:17:09:683762 [AT_GLOBAL ]I: Licensed to Qlik Replicate Express users (software license acceptance implied)Express license: You are running the Express Edition with reduced functionality (245 days remaining) (at_logger.c:2773)
00000945: 2026-05-12T17:17:09:683831 [AT_GLOBAL ]I: Log file encryption base "HbIFY1L3uWqjkVDdH/tnnQ==" (at_logger.c:2784)
00000945: 2026-05-12T17:17:09:683869 [INFRASTRUCTURE ]I: Crypto mode: Standard. (at_logger.c:1607)
00000945: 2026-05-12T17:17:09:692779 [SERVER ]T: The server is listening on TCP port 3550 (server.c:838)
00000945: 2026-05-12T17:17:09:719219 [UTILITIES ]I: Scheduler configuration has been loaded. (scheduler.c:606)
00000947: 2026-05-12T17:17:09:719831 [INFRASTRUCTURE ]I: Log cleanup thread successfully initialized and running. (logger.c:860)
00000945: 2026-05-12T17:17:09:726196 [TASK_MANAGER ]I: Feature flags for process are: (ar_feature_flags.c:232)
00000948: 2026-05-12T17:17:09:874422 [COMMUNICATION ]T: Client is connected to 127.0.0.1:3550 on port 50544 (at_lgnet.c:1713)
00000945: 2026-05-12T17:17:09:876632 [COMMUNICATION ]T: Accepted a new connection on port 3550 from 127.0.0.1:50544 (at_lgnet.c:1432)
00000945: 2026-05-12T17:17:09:958410 [SERVER ]I: Client session (ID 1248848983) allocated (dispatcher.c:276)
00000945: 2026-05-12T17:17:09:958809 [SERVER ]T: New session created (Session #1248848983) (server.c:2268)
00000948: 2026-05-12T17:17:10:73663 [REST_SERVER ]W: Failed to initialize pam configuration, pam authentication disabled. (atctl_serve.c:275)
00000948: 2026-05-12T17:17:10:76127 [REST_SERVER ]I: Agent was started successfully (listening on port 44444). (atctl_serve.c:402)
00000948: 2026-05-12T17:17:12:775409 [COMMUNICATION ]T: Accepted a new connection on port 44444 from 10.89.0.4:41488 (at_lgnet.c:1432)
00000948: 2026-05-12T17:17:12:847440 [COMMUNICATION ]T: Accepted a new connection on port 44444 from 10.89.0.4:41492 (at_lgnet.c:1432)
00000953: 2026-05-12T17:17:17:961280 [SERVER ]T: Validating ODBC driver for provider: 'ODBC Driver 18 for SQL Server' (sqlserver_endpoint_imp.c:1180)
00000953: 2026-05-12T17:17:17:964731 [SERVER ]T: Using provider: 'ODBC Driver 18 for SQL Server' (sqlserver_endpoint_imp.c:1249)
00000953: 2026-05-12T17:17:17:965066 [SERVER ]T: The folder '/opt/microsoft/msodbcsql18/lib64/' exists (sqlserver_api.c:80)
00000953: 2026-05-12T17:17:17:965633 [SERVER ]T: Get list files from folder '/opt/microsoft/msodbcsql18/lib64/' with filter. The result is '1' files (sqlserver_api.c:87)
00000953: 2026-05-12T17:17:17:966500 [SERVER ]I: ODBC driver 'ODBC Driver 18 for SQL Server' found as installed (sqlserver_endpoint_util.c:404)
00000953: 2026-05-12T17:17:17:966512 [SERVER ]T: ODBC driver 'ODBC Driver 18 for SQL Server' found as installed (sqlserver_endpoint_util.c:405)
00000953: 2026-05-12T17:17:17:966622 [SERVER ]T: ODBC driver 'ODBC Driver 17 for SQL Server' found as *NOT* installed (sqlserver_endpoint_util.c:405)
00000953: 2026-05-12T17:17:17:966728 [SERVER ]T: ODBC driver 'ODBC Driver 13 for SQL Server' found as *NOT* installed (sqlserver_endpoint_util.c:405)
00000953: 2026-05-12T17:17:17:967124 [SERVER ]T: App name connection parameter (user agent) is 'APP=QlikReplicate/2025.11 (microsoftazuresqlmscdc)' (sqlserver_endpoint_util.c:319)
00000953: 2026-05-12T17:17:17:967129 [SERVER ]T: sqlserver_src_set_odbc_connection_string(): connection string (without credentials): 'DRIVER={ODBC Driver 18 for SQL Server};SERVER=sql-eap-weu-lgrr-qa.database.windows.net;DATABASE=eap-db-lgrr-qa-11;Trusted_Connection=no;Encrypt=yes;TrustServerCertificate=yes;APP=QlikReplicate/2025.11 (microsoftazuresqlmscdc);' (sqlserver_endpoint_util.c:259)
00000953: 2026-05-12T17:17:18:10105 [SERVER ]I: Source endpoint 'Microsoft Azure SQL (MS-CDC)' is using provider syntax 'SQLServer' (provider_syntax_manager.c:1004)
00000945: 2026-05-12T17:17:18:910371 [SERVER ]T:
00000945: 2026-05-12T17:17:38:105472 [SERVER ]T:
00000945: 2026-05-12T17:17:39:116993 [SERVER ]T:
00000953: 2026-05-12T17:17:39:300155 [SERVER ]T: RetCode: SQL_ERROR SqlState: FA004 NativeError: 0 Message: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Failed to authenticate the user '8ffcd3a2-3e1b-4d6a-9ef0-993832e9c228' in Entra ID (Authentication option is 'ActiveDirectoryServicePrincipal').
Error code 0xA190; state 41360 [1022502] (ar_odbc_conn.c:584)
00000953: 2026-05-12T17:17:39:300693 [SERVER ]T: Connection failure error codes are: 00026,00904,10054,4060,01222,55,64,121,1231,233,109,18401,6005,40613 (provider_syntax_manager.c:3076)
00000953: 2026-05-12T17:17:39:301391 [SERVER ]T: Table error codes are: 16943,208,11529,1904,1750,8180,207 (provider_syntax_manager.c:3135)
00000953: 2026-05-12T17:17:39:301412 [SERVER ]T: Table error codes are: 16943,208,11529,1904,1750,8180,207 (provider_syntax_manager.c:3135)
00000953: 2026-05-12T17:17:39:301506 [SERVER ]T: Data failure error codes are: 7125,8114,6522,511 (provider_syntax_manager.c:3106)
00000953: 2026-05-12T17:17:39:301530 [SERVER ]T: Data failure error codes are: 7125,8114,6522,511 (provider_syntax_manager.c:3106)
00000953: 2026-05-12T17:17:39:301793 [SERVER ]T: Connection failure error codes are: 00026,00904,10054,4060,01222,55,64,121,1231,233,109,18401,6005,40613 (provider_syntax_manager.c:3076)
00000953: 2026-05-12T17:17:39:302360 [SERVER ]T: Failed to connect [1022500] (sqlserver_endpoint_imp.c:2354)
00000953: 2026-05-12T17:17:39:302615 [SERVER ]T: Entering 'sqlserver_endpoint_free_imp' (sqlserver_endpoint_imp.c:2672)
00000953: 2026-05-12T17:17:39:300155 [SERVER ]E: RetCode: SQL_ERROR SqlState: FA004 NativeError: 0 Message: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Failed to authenticate the user '8ffcd3a2-3e1b-4d6a-9ef0-993832e9c228' in Entra ID (Authentication option is 'ActiveDirectoryServicePrincipal').
Error code 0xA190; state 41360 [1022502] (ar_odbc_conn.c:584)
00000953: 2026-05-12T17:17:39:302360 [SERVER ]E: Failed to connect [1022500] (sqlserver_endpoint_imp.c:2354)
We are able to connect to the source endpoint using the same ODBC driver using python, on the same machine running Qlik Replicate:
((replicate) ) bash-5.1$ python3 test_odbc.py
Testing connection to Azure SQL Database with: Driver={ODBC Driver 18 for SQL Server};Server=tcp:sql-eap-weu-lgrr-qa.database.windows.net,1433;Database=eap-db-lgrr-qa-11;Authentication=ActiveDirectoryServicePrincipal;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;UID=8ffcd3a2-3e1b-4d6a-9ef0-993832e9c228;PWD=*******;
('Microsoft SQL Azure (RTM) - 12.0.2000.8 \n\tApr 14 2026 20:27:12 \n\tCopyright (C) 2025 Microsoft Corporation\n',)
✓ Connection successful
No other logs as we cant set up a task. Has anyone else had any experience with this error?
Hi Team,
We have one question regarding the quarterly DB2 zos source archival activities.
Previously, during a similar archival activity, we experienced very high latency issues due to huge transaction volumes generated in the source logs. Additionally, a few Qlik tasks encountered data missing issues because of resource constraints during heavy processing.
To mitigate the issue, we later increased the infrastructure resources by doubling the disk space, CPU, and RAM capacity.
Could you please help us understand the best practices or recommended approach for handling these kinds of large-volume archival activities? We would like to know the recommended planning, tuning, or operational strategies to minimize latency and avoid data loss/issues in Qlik replication tasks during such events.
Your guidance and recommendations would be very helpful for us.
Thanks,
Shyam Sundar.
Hi everyone,
I've been working on improving the structure and performance of my Qlik load scripts and front-end apps, and I want to make sure I'm following the most current best practices... not just what was recommended 3 or 4 years ago.
I'm looking for resources that cover topics like:
My question to the community: What are the most current and reliable sources you use to guide your development decisions? For example:
Any links, authors, or resources you'd recommend would be greatly appreciated. Thanks in advance!
Introducing a new agentic experience in Qlik Answers and open AI access through MCP. Later this March: Discovery Agent and trusted data products embedded into analytics.
Yesterday’s innovations are today’s table stakes. BARC reveals modern ISVs’ most essential capabilities.
Your journey awaits! Join us by Logging in and let the adventure begin.
Data Restores Confidence: How SEFAZ-RS Used Qlik to Support the Rebuilding of a State.
AFIP revolutionizes management, optimizes resource allocation and strengthens data-driven culture
Global container shipping giant delivers data transparency to enable confident decision-making and operational efficiency.
Qlik turns raw data into valuable learning experiences, empowering both students and faculty at TTUHSC.
MillerKnoll partnered with Qlik Talend® data solutions to unify data across its diverse systems, accelerating critical processes and nearly eliminating data integration issues organization-wide.
Migration to Qlik Cloud Analytics optimizes analytics applications within months.
With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.
Join one of our Location and Language groups. Find one that suits you today!
Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.
Join data and AI leaders in Vienna on May 20, 2026 to learn how to scale AI into real enterprise impact.
Join the Nordics virtual event on May 20, 2026 to learn how to scale AI and unlock real enterprise value from anywhere.
Join data and AI leaders in Zurich on June 10, 2026 to learn how to scale AI and drive real enterprise impact.