Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
My Source connection is an Oracle database. I have audit tables in my Replicate task "Full Load + Apply Changes"
the tables are huge and by nature there is heavy DML operations.
My target is Snowflake "Extra Small Size", I see significant amount of latency when i tried replicating audit tables.
Is there a way I can limit the date range to be at most 24 months of history data in the replicate task ?
Thank you.
Hello team,
We are using a pipeline project in Qlik Talend Cloud (QTC) to replicate data from Oracle to Snowflake.
During our testing, we noticed the following behavior regarding trailing CHR(0) characters:
1. Default settings (No changes to truncateTrailingBinaryZerosInChars)
CHAR: Truncated
VARCHAR: Converted to spaces
2. With truncateTrailingBinaryZerosInChars set to false
CHAR: Converted to spaces
VARCHAR: Converted to spaces
(We are already asking about why they are converted to spaces in this thread: https://community.qlik.com/t5/Talend-Cloud/The-CHR-0-character-is-being-converted-to-spaces-during/m-p/2553385#M693)
Could you please help us with these two questions?
Q1. Is the truncateTrailingBinaryZerosInChars parameter supported/recommended in QTC?
Q2. Is it expected behavior that CHR(0) in VARCHAR is not truncated by default (when the parameter is not specified)?
Best Regards.
Hello Team,
We are currently running a pipeline project in Qlik Talend Cloud to replicate data from Oracle to Snowflake.
During this process, we noticed that CHR(0) (null characters) from the Oracle source are being converted into spaces (whitespaces).
We have already investigated the pipeline steps and confirmed that this conversion (where CHR(0) becomes spaces) is already occurring at the stage where the data is loaded from Oracle to the external storage (Amazon S3).
Could you please let us know if there is any workaround, configuration, or parameter setting to prevent this conversion and preserve the null character?
Best Regards.
Hi Team,
We have a Qlik mashup which we have developed and there is an export button though which we are exporting table to PDF. Currently it is exporting single page pdf. There is a requirement to generate multi page export (new feature for export to pdf in SaaS Straight tables). We are using Qlik Embed technology. Has someone implemented multi page export to pdf? Can you please share reference code.
Hello,
Hi,
I am testing Qlik Replicate on Oracle (19.30) on-premise source and OCI ADW target environment.
However, in the task log
01766922: 2026-07-14T13:34:44 [TARGET_APPLY ]T: Going to prepare the statement 'BEGIN rdsadmin.rdsadmin_util.show_configuration;END;'
Occurs periodically, and in the source Oracle alert log
2026-07-14T16:46:07.799507+09:00 WARNING: too many parse errors, count=1551 SQL hash=0x6e856dc9 PARSE ERROR: ospid=184696, error=6550: Additional information: hd=0x31713a070 phd=0x31e3fd178 flg=0x20 cisid=114 sid=114 ciuid=114 uid=114 sqlid=9zjxcqxr8avf9 ...Current username=ARUSER ...Application: repctl@dpts-cdc-qa-ar01 (TNS V1-V3) Action:
Occurs randomly
I am curious why the `rdsadmin.rdsadmin_util.show_configuration` statement is executed even though it is not an RDS environment, and why it is executed on Oracle source code in an on-premise environment. This phenomenon did not occur when using `qlik replicate 2023 Nov 468` in the same source target environment.
I checked task json file and endpoint but I couldn't find anything strange.
How can I identify the cause?
Regards
Kwang Ho
I'm trying to build a bar chart in Qlik Sense Enterprise with:
My measure needs to calculate an average of a case-level metric, so I'm using Aggr() to first calculate the metric per case and then averaging the result. The purpose is that i can drill down from discipline to item
Avg(
Aggr(
If(
Sum(a_score) > 0,
(Sum(d_score) - Sum(a_score)) / Sum(a_score)
),
case_no
)
)
The problem is that the chart uses both a Cyclic Group and a Drill-down Group, while Aggr() requires explicit dimensions. I've looked into functions like GetCurrentField() and some community posts about drill-down dimensions, but I can't solve my problem. Can we achieve this by measure or have some ways to workaround.
Here is my sample data
| CaseID | Category | Item | A_Score | D_Score |
|---|---|---|---|---|
| 1001 | A | A1 | 10 | 15 |
| 1001 | A | A2 | 20 | 25 |
| 1001 | B | B1 | 15 | 18 |
| 1002 | A | A1 | 12 | 16 |
| 1002 | A | A2 | 18 | 20 |
| 1002 | B | B1 | 10 | 14 |
Hello y'all,
I've got a regular .csv file, with around 30 regular columns. However, a couple of columns are JSON text.
I would like to parse the JSON text and get some extra columns from it.
I've tried to use a tExtractJSONFields, but there are two flaws:
- the component seems to be expecting a full JSON input, not a JSON column among regular string-type columns
- I hardly know anything about Json paths and Json queries
The JSON column is called 'jugement', one of the JSON property I need from it is called 'complementJugement', so I've used '$.jugement' as the Jsonpath query and 'complementJugement' as the Json query mapped to a new schema column. I got this error message:
Expected to find an object with property ['jugement'] in path $ but found 'java.lang.Integer'. This is not a json object according to the JsonProvider: 'com.jayway.jsonpath.spi.json.JsonSmartJsonProvider'.
Can anyone help me with this issue?
Thanks in advance
Hi Team,
I am trying to intepret what actions relate to values in "Requested Action" in the audit trail in QEM.
Is there a list somewhere? Specifically I am looking for what "putdatabase" relates to.
Thanks in advance,
Jon
Hi,
I have embedded Qlik charts in my mashup project using the <qlik-embed> component. I need to apply an initial selection when the mashup loads.
The requirement is to dynamically determine the highest (latest) value from a field and use it as the initial selection. For example, if the field is Year and it contains values such as 2022, 2023, 2024, 2025, and 2026, I need to identify the maximum value (2026) at runtime and apply it as the initial selection when the mashup opens.
Has anyone had success with setting up a data gateway to on-premise SQL server then executing a stored procedure?
When I run it, it never returns data; just spins. However, if I run the raw query from the SP directly in the Qlik load script, it returns as expected. Does the Data Gateway set up just not like stored procedures?
Example:
LOAD *;
SQL
EXEC [Server].[Schema].[StoredProcedure];
See why Qlik was named a Leader in the 2026 Gartner® Magic Quadrant™ for Analytics and Business Intelligence Platforms
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.