Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 238,253 members
  • 4,008 online
  • 2,020,724 posts
  • 151,944 Solutions
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    Ways to install downgrade version of qlik replicate

    Hi Team, I have QLik replicate 2022.11 version currently. I need to upgrade the version to 2023.5 (latest version). I would like to understand whether... Show More

    Hi Team,

    I have QLik replicate 2022.11 version currently. I need to upgrade the version to 2023.5 (latest version). I would like to understand whether we can do downgrade install ie again from 2023.5 to 2022.11  in case of any issue? If so , what is the steps? 

    i) As per the release note, it is necessary to uninstall the current version and install the version needed. In that case, will that impact the existing setup and all configurations ? what about license? Whether it is required to do license again after uninstall?

    ii) If i want to stop all the task in qlik replicate before installation/uninstallation, what is the process for stopping and starting all task in one go (without any manual process) 

     

    Thanks,

    Mythili Boopathy

    Show Less
  • forum

    Qlik Replicate

    Scenarios where passthrough filter is slower than regular table filter

    Hi, I came across a scenario where the passthrough filter is surprisingly slower than the table filter in full load. What are the scenarios which can ... Show More

    Hi,

    I came across a scenario where the passthrough filter is surprisingly slower than the table filter in full load. What are the scenarios which can cause this to happen?

    My understanding is that the passthrough filter offer greater performance as it alters the actual select statement sent to the source endpoint.

    Regards,

    Mohammed

    Show Less
  • forum

    Qlik Replicate

    Qlik replicate full load CPU utilization

    We are running our replicate on windows server with Standard_E8s_v3 size. There will be two tasks always running on the server.  One will always be in... Show More

    We are running our replicate on windows server with Standard_E8s_v3 size. There will be two tasks always running on the server. 

    One will always be in CDC mode and other runs full loads 3 times a day and continues in CDC mode remaining time.

    The issue we are seeing is when there is a full load running on the second task the CPU is in upwards of 80% and there is a latency on the CDC task.

    I heard that when a task is in full load each table will occupy 1 CPU , is it correct ? and each task will need 1 cpu when it is running

    Show Less
  • forum

    Qlik Replicate

    How do keys defined in Replicate prevent duplicates from reaching the target?

    Hi, I have run into some interesting behaviour while I was doing some testing. I have a task that goes from Oracle to SQL server with one table only. ... Show More

    Hi,

    I have run into some interesting behaviour while I was doing some testing. I have a task that goes from Oracle to SQL server with one table only. The source table and target tables don't have any primary key or unique indexes defined on them. However, in Replicate -> Table Settings -> Transform, I've defined a combination of three columns as keys.

    MoeyE_0-1733445220992.png

    I tested inserting some duplicates on the source database however these duplicates are not applied to the target database, even though the target has no primary key or unique index defined on it. How exactly does this work? How does Replicate identify duplicates? Does it read the incoming records then compare them against the target table to decide whether or not to apply them? Is this less performant than having the actual PK/Unique Index on the target table? Please help me understand how this works, it is appreciated as always. Thanks.

    Regards,

    Mohammed

    Show Less
  • forum

    Qlik Replicate

    Function Columns as Key

    Using Nov 2022 Qlik Replicate Version from Oracle 19c to Snowflake on AWS.   We are taking data from an application table and creating a hash on the c... Show More

    Using Nov 2022 Qlik Replicate Version from Oracle 19c to Snowflake on AWS.

     

    We are taking data from an application table and creating a hash on the concatenation of the key columns eg:

    ifnull(colA,'')||ifnull(colB,'')||ifnull(colC,'') for all key columns and then set the hash of this as our primary key in snowflake (Target). However, I see that when a record gets updated, QLIK tries to set the target key column as null. This calls a not null constraint on our Snowflake DDL.

    Our source has the same 3 columns as a unique index, but we hash and concat them into our solo target key.

     

    Is there any way around having QLIK temporarily set the column to NULL or should we remove the not null constraint on our target table? The exception table is showing that is it updating our hash_key to null where hash_key = theoldvalue.

     

    Show Less
  • forum

    Qlik Replicate

    different schemas with the same table's names in the one replication task

    I have this situation that I have few schemas with the same table names in every schemas and when I am adding these tables names are changed to table_... Show More

    I have this situation that I have few schemas with the same table names in every schemas and when I am adding these tables names are changed to table_name_1 and it is replicating with the same name with "_1" which is different name like in the source. I would like to handle it somehow. In old qlik every table was represanted like schema.table_name and it was not any issue when few schemas had the same table names.

    Show Less
  • forum

    Qlik Replicate

    Unable to add UDF to qlik

    Hi team , I had complied a UDF and generated dll and .so file . when I followed the steps from Document , i couldn’t  see my UDF in qlik under express... Show More

    Hi team , 

    I had complied a UDF and generated dll and .so file . when I followed the steps from Document , i couldn’t  see my UDF in qlik under expression builder>>functions>>UDF .

    need some help on this . please let me know if additional details needed 

    followed this . 
    https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/user_defined_transformations.htm#:~:text=the%20Expression%20Builder-,User%2Ddefined%20transformations,%3CINSTALL_DIR%3E%5Caddons%5Csamples%5CMyTransformation,-Information%20note

    Show Less
  • forum

    Mobile

    CSRF API Call on Mobile App

    Anyone have luck getting the Qlik Mobile App to generate a CSRF API call successfully? Seeing no issues using the call on desktop and mobile browser b... Show More

    Anyone have luck getting the Qlik Mobile App to generate a CSRF API call successfully? Seeing no issues using the call on desktop and mobile browser but when using the Qlik Mobile App, the CSRF call doesn't return a token. 

    I submitted a support ticket but it was suggested to post here as well.

    Show Less
  • forum

    New to Qlik Analytics

    How to find number of days

    Hi, I have a number of  periods and intervals in a generic day-month format. My challenge is how to calculate the number of days an interval intersect... Show More

    Hi,

    I have a number of  periods and intervals in a generic day-month format. My challenge is how to calculate the number of days an interval intersects with a period as per the example table below. 

    I have tried with the DayNumberOfYear() function, which works fine as long as I'm in the same year, i.e. line 1, but when intervals and periods span over 31-dec, as per line 2 & 3, this approach is no longer giving correct results.  

    period_start period_end interval_from interval_to #intervall_days_in_period
    12-dec 20-dec 01-dec 15-dec 3
    05-dec 20-jan 20-dec 10-jan 21
    25-dec 15-feb 20-jan 01-mar 27

     

    Any assistance on how to solve this is highly appreciated. Regards//Peter

    PS. interval_from & interval_to are user input hence solution need to be outside of the script.

     

    Show Less
  • forum

    Qlik NPrinting

    Question about setting the report sending condition in NPrinting

    The user has the following question:Hello, I need to configure a condition in which the email is only triggered when my condition is satisfactory.In m... Show More

    The user has the following question:

    Hello, I need to configure a condition in which the email is only triggered when my condition is satisfactory.

    In my case, it will only send the email to those who are experiencing delays in the process.

    When there was no such situation = late, the email should not be sent.

    It happens that when the condition is satisfactory, it is sending an email without the attachment but with the email body message and the error message

    In this case, the email was not supposed to be sent, as the condition is different from "Delayed"

    Is this Qlik's default behavior?

    Best Regards,
    Junior de Sousa

    Show Less
X
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

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

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

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

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!