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

Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight on Migrating to Qlik Cloud.

Questions:

1. 01:30 - How to resolve issues with Single Sign-on?
2. 02:13 - What manual work is there for a good migration?
3. 03:00 - How to handle QVWs until full migration is complete?
4. 05:16 - What are the documented limitations?
5. 06:30 - What's the difference between the migration tools?
6. 08:15 - How does the variable syntax work in a migration?
7. 11:09 - How to migrate old unsupported versions of QlikView?
8. 12:37 - What if the visualizations are all minimized?
9. 14:18 - What about the "Always one selected" setting?
10. 15:31 - What about NPrinting?
11. 16:50 - Is the limit to the number of sheets?
12. 17:28 - What is the minimal version of QlikView that's compatible?
13. 18:03 - Is there an app size limit?
14. 19:31 - Will hidden columns be converted?
15. 20:16 - Will it convert GeoAnalytics maps?
16. 22:21 - What is the recommended approach for older versions of QV objects?

Resources:

• Migrating To Qlik Cloud Analytics
• Qlik Product Downloads
• Qlik Migration center
• Planning your migration to Qlik Cloud
• Known limitations

Did we answer your question? Let us know by clicking the like button!

Click here to see video transcript

@SavRakkar 

@adam_jacobs 

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:

• Load script structure and organization
• Data model optimization (star schema, avoiding synthetic keys, QVD layers)
• Performance tuning (set analysis efficiency, AutoNumber, incremental loads)
• Naming conventions and maintainability

My question to the community: What are the most current and reliable sources you use to guide your development decisions? For example:

• Official Qlik help docs or whitepapers
• Community blogs or specific contributors you follow
• YouTube channels or webinars
• Internal standards your team has developed

Any links, authors, or resources you'd recommend would be greatly appreciated. Thanks in advance!