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])

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,

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:

1. Extracted the certificate, private key, and CA chain from the client-provided PFX file using OpenSSL:
   - openssl pkcs12 -in <file>.pfx -clcerts -nokeys -out agent-certificate.pem
   - openssl pkcs12 -in <file>.pfx -nocerts -out agent-private-key.pem -nodes
2. Verified agent-certificate.pem contains the correct leaf certificate (subject=CN=*.domain) and agent-private-key.pem contains a valid private key block.
3. Built agent-ca.pem containing the Sectigo Intermediate CA and Root CA certificates (provided by the client as ca_bundle_sectigo_new.crt).
4. Replaced all four files (agent-ca.pem, agent-certificate.pem, agent-private-key.pem, agent-private-key-passphrase.dat) in the ssl/data directory of the Replicate Server data folder, after stopping the service.
5. Verified the new certificate is being served correctly via:
   openssl s_client -connect <host>:3552 -showcerts
6. Imported the Sectigo Root CA and Intermediate CA into the Windows Local Computer Certificate Store (Trusted Root Certification Authorities and Intermediate Certification Authorities) via certlm.msc.
7. Restarted both the Qlik Replicate Server service and the Replicate UI Server/Console service.

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:

1. Whether there are additional configuration steps required (beyond replacing the ssl/data files and importing the CA into the Windows Certificate Store) for the UI Server to trust the new certificate on port 3552.
2. Whether the UI Server validates trust through a different mechanism that also needs to be updated.
3. Any relevant log files we should review or provide to help diagnose this further.

Thank you