Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need some assistance in locating the Geo Analytics license linked to the Qlik Sense license.
I am installing the tool to enable the connector and import custom maps.
Hello Qlik Community,
In a native Qlik Sense pivot table, I want the Actual measure cell to display the calculated result and Numerator/Denominator as two vertically stacked sections:
The required structure under each period should remain:
I tried Chr(10) and Chr(13) & Chr(10), but the pivot table displays both values on the same line:
Adding a separate Calculation measure works, but changes the structure to:
This also increases the overall table width.
Is it possible to display the calculated result and Numerator/Denominator as two vertically stacked sections within one Actual measure cell?
If this is not supported, is there a native solution using a calculated dimension, ValueList(), or another approach without third-party extensions?
Thank you.
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 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.
Good Day all,
Please let me know if this is not the correct location for this question.
Does anyone have/built a pivot table extension where I can move the totals to the bottom of the pivot table?
I know this is a "cheap" request, but I have a client that is really difficult on this.
The amount of change data that is being captured from source is very large. 200 million records or so for about 20 tables. And this is causing a latency of about 4 hrs or 5 hrs to commit this to target. Is there any way we can speed up this CDC commits? I am attaching a photo of the current monitor screen and my change capture settings. Please let me know of any tuning that can be performed. Source is SQL server (MS-CDC) and target is Snowflake.
Hi all, good evening,
I need to compare the cumulative sales between a year and the year before. This for many years stored in my database.
The sales had already been normalized by the month of each year.
This is the expression I created to generate the information for each year:
Aggr(RangeSum(Above(Sum(QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])
| YEAR/MONTH | SALES YEAR | QTY |
| (other year months) | ... | ... |
| 2026/01 | 2024 | 1 |
| 2026/02 | 2024 | 10 |
| 2026/03 | 2024 | 25 |
| 2026/04 | 2024 | 8 |
| 2026/05 | 2024 | 14 |
| ... | ... | ... |
| 2026/01 | 2025 | 0 |
| 2026/02 | 2025 | 3 |
| 2026/03 | 2025 | 12 |
| 2026/04 | 2025 | 11 |
| 2026/05 | 2025 | 7 |
| ... | ... | ... |
| 2026/01 | 2026 | 4 |
| 2026/02 | 2026 | 5 |
| 2026/03 | 2026 | 8 |
| 2026/04 | 2026 | 12 |
| 2026/05 | 2026 | 20 |
And this is the generated graphic:
What I need is to created a new graphic that shows, for each year, the % growth between that year vs its last year, using the same rule (acumulated sales for each month).
I have already tried many solutions here in the topics, but I couldn't get the right result.
For exemple: Aggr(RangeSum(Above(Sum(QTY) / Sum({<[SALES YEAR] = {"$(=Only([SALES YEAR])-1)"}>}QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])
Thanks in advance for any help.
Hello,
I'm running QlikView server and publisher on a windows VM
Our license is renewed successfully as we confirmed with our contact in Qlik customer service management.
However i'm unable to apply the license, i have all the needed info (serial number, control number, LEF, owner information)
LEF should be correct as it was shared by our contact in Qlik.
Also tried to generate it from here with same results https://lef1.qliktech.com/manuallef/default.aspx
Tried restarting the QlikView windows services many times and applying the license again with no success.
worth noting the license for publisher is working fine with no issues.
Thanks in advance for any help or advise
Hi everyone,
I need to display different images based on the value of a variable. Unfortunately, the native "Text & Image" object doesn’t seem to meet my requirements.
Is there a way to load images from the media library depending on a variable (the variable will likely match the image names with a ".png" extension)?
I’ve come across extensions that allow the use of APIs or URLs, but my images are stored on my PC, and I'm not sure how I can share them via URLs (security policies).
Does anyone know of an extension that can help with this?
Thanks in advance for your help!
03761178: 2026-08-10T13:51:22 [TASK_MANAGER ]I: Task error notification received from subtask 0, thread 2, status 1022505 (replicationtask.c:3740) 03761331: 2026-08-10T13:51:22 [STREAM_COMPONEN ]E: Failed (retcode -1) to execute statement: 'DBCC PAGE(litrockfms, 1, 3336884, 1) WITH TABLERESULTS;' [1022502] (ar_odbc_stmt.c:4719) 03761331: 2026-08-10T13:51:22 [STREAM_COMPONEN ]E: RetCode: SQL_ERROR SqlState: 42000 NativeError: 2571 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]User 'ADEEFP2_Repl_User' does not have permission to run DBCC PAGE. Line: 1 Column: -1 [1022502] (ar_odbc_stmt.c:4724) 03761331: 2026-08-10T13:51:22 [SOURCE_CAPTURE ]E: Failed to execute statement: 'DBCC PAGE(litrockfms, 1, 3336884, 1) WITH TABLERESULTS;' [1022505] (sqlserver_endpoint_capture.c:1933) 03761331: 2026-08-10T13:51:22 [SOURCE_CAPTURE ]E: Failed to lookup the column 'comment' of table 'dbo.reqaprv', stream position '0000b020:00023752:0003' [1022505] (sqlserver_endpoint_capture.c:2089) 03761331: 2026-08-10T13:51:22 [SORTER ]E: The Transaction sorter. Cannot forward transaction [1022505] (sorter_transaction.c:1020) 03761331: 2026-08-10T13:51:22 [SORTER ]E: Error executing data handler [1022505] (streamcomponent.c:2048) 03761331: 2026-08-10T13:51:22 [TASK_MANAGER ]E: Stream component failed at subtask 0, component st_0_transaction_sorter [1022505] (subtask.c:1647) 03761331: 2026-08-10T13:51:22 [SORTER ]E: Stream component 'st_0_transaction_sorter' terminated [1022505] (subtask.c:1818) 03761178: 2026-08-10T13:51:22 [TASK_MANAGER ]W: Task 'mssql-ls-EFIP-litrockfmsusar-8ee9c8d7' encountered a fatal error (repository.c:6582)
Hi,
We are requesting assistance with an SSL/TLS certificate issue on our Qlik Replicate Server.
Environment:
- Qlik Replicate version: 2025.11.0.285 (X64)
- OS: Windows Server 2022
- Server hostname: BMTPRMPDBQLIK01.domain
- Affected port: 3552 (Replicate Server/agent communication port)
Background:
Our internal security team flagged the default self-signed certificate on port 3552 as untrusted (Nessus Plugin ID 51192 - SSL Certificate Cannot Be Trusted). We obtained a proper wildcard certificate issued by Sectigo (*.domain) and attempted to replace the self-signed certificate following the official documentation:
https://help.qlik.com/en-US/replicate/November2025/Content/Replicate/Main/Security/set_up_server_https_support.htm
Steps we have completed so far:
Current issue:
After completing the above steps, the Replicate web console now returns the following error:
"SYS, General - The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."
This suggests the UI Server is still unable to validate trust when communicating internally with the Replicate Server over port 3552, despite the certificate chain appearing valid via openssl verification.
Could you please advise:
Thank you
Catch defects and silent data corruption before they reach production with a standardized black-box testing framework for Talend Jobs.
Walk through six new AI capabilities now generally available in Qlik and start applying agentic data engineering to your team’s workflows.
Set your course for six weeks of expert-led sessions on data, analytics, and AI — available on demand.
Built for the builders: Modern data engineering is AI powered — and engineer led.
The pilot-to-production gap is real. From fragmented data to governance gaps Qlik and AWS break down what’s holding your enterprise AI back — and how to solve them.
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 Zurich on June 10, 2026 to learn how to scale AI and drive real enterprise impact.