Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 276,970 members
  • 6,438 online
  • 2,051,098 posts
  • 155,031 Solutions
Announcements
Data Works for AI is here - Join the discussion and enter to win a pair of Qlik kicks: Join the Conversation!

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    Replicate data from last 24 months

    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 nat... Show More

    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.

    Show Less
  • forum

    Talend Cloud

    truncateTrailingBinaryZerosInChars and CHR(0) behavior (Oracle to Snowflake)

    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 fo... Show More

    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.

    Show Less
  • forum

    Talend Cloud

    The CHR(0) character is being converted to spaces during replication.

    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... Show More

    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.

    Show Less
  • forum

    Integration, Extension & APIs

    Mashup - Multi Pge Export functionality via Qlik Embed Technology

    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 export... Show More

    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.

    Show Less
  • forum

    Qlik Replicate

    Why is rdsadmin.rdsadmin_util.show_configuration being executed when it is not a...

    Hello,Hi,I am testing Qlik Replicate on Oracle (19.30) on-premise source and OCI ADW target environment.However, in the task log01766922: 2026-07-14T1... Show More

    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

    Show Less
  • forum

    Visualization and Usability

    Using Aggr() with a Cyclic Dimension and a Drill-down Dimension in Qlik Sense En...

    I'm trying to build a bar chart in Qlik Sense Enterprise with: Dimension 1: A Cyclic Group containing several time dimensions (e.g. Month, Quarter, Y... Show More

    I'm trying to build a bar chart in Qlik Sense Enterprise with:

    • Dimension 1: A Cyclic Group containing several time dimensions (e.g. Month, Quarter, Year)
    • Dimension 2: A Drill-down Group (e.g. Discipline → Item)

    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
    Show Less
  • forum

    Talend Studio

    JSON fied in a CSV file

    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 ... Show More

    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

     

    Show Less
  • forum

    Qlik Replicate

    QEM: Audit trail "Requested Action" explanation

    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... Show More

    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

    Show Less
  • forum

    Integration, Extension & APIs

    Get all values from field.

    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... Show More

    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.

    Show Less
  • forum

    Data Movement & Streaming

    Qlik Data Gateway with SQL Stored Procedures

    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 dat... Show More

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

     

    Show Less
Leaderboard

Qlik community MVPs

Qlik Community MVPs — trusted experts driving collaboration, learning, and innovation.

mvp-banner-side-image

Customer Story

Data Drives the Reconstruction of an Entire State

Data Restores Confidence: How SEFAZ-RS Used Qlik to Support the Rebuilding of a State.

Customer Story

Qlik platform helps structure an analytics ecosystem to support diagnostic medicine and healthcare.

AFIP revolutionizes management, optimizes resource allocation and strengthens data-driven culture

Customer Story

Hapag-Lloyd Enables Smart Decisions With Qlik

Global container shipping giant delivers data transparency to enable confident decision-making and operational efficiency.

Customer Story

Students See Data Come to Life With Qlik Academic Program

Qlik turns raw data into valuable learning experiences, empowering both students and faculty at TTUHSC.

Customer Story

MillerKnoll Unifies Data with Qlik Talend

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.

Customer Story

Radiall Embraces the Cloud and Improves Operational Efficiency

Migration to Qlik Cloud Analytics optimizes analytics applications within months.

Customer Story

French Ministry of Armed Forces Develops a Data-Centric Culture

With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.

Your Place, Your People

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Qlik en México

Qlik en México

Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.

All are welcome

Hello from Japan

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Parlons Données

Parlons Données

Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.

open to all

AI Reality Tour

Zurich

Join data and AI leaders in Zurich on June 10, 2026 to learn how to scale AI and drive real enterprise impact.