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: 
  • 255,337 members
  • 3,454 online
  • 2,036,781 posts
  • 153,368 Solutions
Announcements
Qlik Community Office Hours: Join us on July 9th, 2025 - REGISTER HERE!

Welcome to Qlik Community

Recent Discussions

  • forum

    Data Movement & Streaming

    Qlik Cloud Data Integration - Frequency of BICC extracts from Oracle Fusion

    Hi Support, With regard to the Oracle Fusion connector in Qlik Cloud Data Integration, since the connector uses BICC to connect to the Fusion database... Show More

    Hi Support,

     

    With regard to the Oracle Fusion connector in Qlik Cloud Data Integration, since the connector uses BICC to connect to the Fusion databases, is there an indication of how frequently extract jobs run in BICC to capture the changes in the Fusion tables? 

     

    Thanks,

    Nak

    Show Less
  • forum

    Water Cooler

    Suzy's Tips - Accessibility

    A quick walkthrough of AudioEye, our digital accessibility tool that helps ensure the Qlik Community is usable for everyone! (Click the YouTube link ... Show More

    A quick walkthrough of AudioEye, our digital accessibility tool that helps ensure the Qlik Community is usable for everyone!

    (Click the YouTube link for a transcript of the video. If you need closed captions, please let us know here!)

    Show Less
  • forum

    Water Cooler

    Got Questions About Qlik Community? Join Our Live Q&A + Swag Raffle!

    Hey everyone!  We’re hosting Qlik Community Hours, a casual live session where you can bring any and all questions about the Qlik Community platform, ... Show More

    Hey everyone! 

    We’re hosting Qlik Community Hours, a casual live session where you can bring any and all questions about the Qlik Community platform, no product questions this time, just Community stuff!

    Whether you’re wondering how to post, navigate the forums, or earn badges, this is your chance to ask us live!

    Bonus: Everyone who attends will be entered into a raffle to win some exclusive Qlik swag!

    Register here!

    Show Less
  • forum

    Talend Cloud

    how to Enable tQVDoutput component in talend

    Hi, I am currently working on Talend cloud data fabric, I saw the Talend R2025-05 release notes that we have the new Qlik Cloud Components such as tQV... Show More

    Hi,

    I am currently working on Talend cloud data fabric, I saw the Talend R2025-05 release notes that we have the new Qlik Cloud Components such as tQVDOutput and tQlikOutput. I would like to explore this components, but I am unable to find in the palette.

    Has anyone worked on it? I am using the R2025-06v3 version, is this version is compactable for those components? should I use the same respective release version to use the Qlik cloud components?

    Qlik document: Qlik Cloud components | Talend Components for Jobs Help

    Talend Cloud Talend Data Integration 

    Show Less
  • forum

    Qlik Replicate

    SAP note 3255746 impact on connector

    SAP:SAP Note 3255746 was updated and now states that “the usage of RFC modules of the Operational Data Provisioning (ODP) Data Replication API by cust... Show More

    SAP:

    SAP Note 3255746 was updated and now states that “the usage of RFC modules of the Operational Data Provisioning (ODP) Data Replication API by customer, or third-party applications to access SAP ABAP sources (On-Premise or Cloud Private Edition) is NOT permitted by SAP.”

     

    How will that affect the Qlik connector used to obtain data from HANA? Will it stop working once SAP enforces their note?

    Show Less
  • forum

    Qlik Replicate

    Handle Purge – Full Load + CDC from DB2 to Redshift (Implementation Questions)

    Hi Team, I’m working on a use case where I need to implement a full load followed by CDC from DB2 to Redshift, and I want to make sure we handle DB2 p... Show More

    Hi Team,

    I’m working on a use case where I need to implement a full load followed by CDC from DB2 to Redshift, and I want to make sure we handle DB2 purges correctly while retaining historical data in Redshift.


    Scenario Summary

    • We perform a full load from DB2 table emp to Redshift table emp before the DB2 team purges older records.

    • After the purge, we enable CDC (insert, update, delete) to a separate Redshift table: emp_incremental.

    • We use a MERGE process to sync CDC changes from emp_incremental into emp, using a last_updated_dt timestamp.

    • Natural deletes from CDC should be processed normally (we do not retain those).

    • Our goal is to preserve all data that existed before purge, but allow regular CDC to continue afterward.


    Implementation Questions

    1. Can I implement this from a single Qlik Replicate task?
      Can I map the same DB2 table (emp) twice — once for full load only to Redshift table emp, and once for CDC only to Redshift table emp_incremental?
      Or is it recommended to use two separate tasks for this?

    2. How do I configure the task(s) to:

      • Perform full load only to emp (once, before purge)

      • Apply only CDC (insert/update/delete) to emp_incremental (after purge)

    3. Will Qlik capture deletes that happen during or after the purge (from DB2 logs) and apply them to emp_incremental?

    4. How can I define and apply a last_updated_dt = GETDATE() field in both full load and CDC using the Derived Column transformation?

    5. What are the best practices for ensuring this approach works reliably — especially for purge scenarios — without introducing soft delete columns?


    Thanks in advance for your help!

    Best regards,

    Bishnu

    Show Less
  • forum

    Visualization and Usability

    Qlik Retiring Table Visualization

    I saw news that Qlik is retiring the Table visualization and replacing it with the new Straight Table visualization. If Qlik follows through with that... Show More

    I saw news that Qlik is retiring the Table visualization and replacing it with the new Straight Table visualization. If Qlik follows through with that it would be severely detrimental to our reporting. Setting aside the additional work our developers would have to put in replacing/reformatting every existing table across the companies we work with, the Straight Table visualization lacks much of the functionality that made the simple Table visualization so compelling. As an example, a user can't easily use the search magnifying glass to filter a column - that is now buried behind three clicks in the hamburger menu that appears on each column in the Straight Table. Is there any way to submit feedback to Qlik and tell them this is a terrible idea and they should keep the old Table visualization? 

    Show Less
  • forum

    Integration, Extension & APIs

    Discrepancy in data between Qlik tabel and Excel Add-in Export

    I have a challenge I can’t figure out. I created a sheet in Qlik with a table that contains a range of information. Two of the fields are called Bilag... Show More

    I have a challenge I can’t figure out. I created a sheet in Qlik with a table that contains a range of information. Two of the fields are called BilagNr and RegistreringsNr. BilagNr is unique to the transaction, and RegistreringsNr is the license‐plate number linked to that transaction.

    When I view the table in Qlik, the row with BilagNr 116455 shows RegistreringsNr YF12587, which is correct according to the database. But when I use the Excel Add-in to export a report based on this same table, the same BilagNr 116455 comes out with a completely different RegistreringsNr (AY46466).

    Why is the Excel Add-in returning the wrong RegistreringsNr?

    Show Less
  • forum

    Talend Studio

    Configuring an HTTPS connection with Talend on Linux server

    Hi, I am new to Talend and I have given a task to connect Talend to an API which require in HTTPS connection. I have download the certificate on place... Show More

    Hi, I am new to Talend and I have given a task to connect Talend to an API which require in HTTPS connection.

    I have download the certificate on place it in the cert store and I have configure Talend using the following setup:

    williaml_0-1751367117030.png

    It works on Windows device but I will need to use it in Linux environment.

    What I have done so far is import it to the keystore in Linux server and change the configure above but it wont connect.

    Next what I have done is copy the cacert file from windows machine to Linux server and place it in /etc/pki/tls/certs/cacerts and I have update the path and the password but it sill not able to connect.

    Can I ask if someone had able to connect using Linux server?

    Show Less
  • forum

    App Development

    Conditional Count if for entire column

    Hi all,I want to each row to calculate the number of columns, which match the following criteria:(1) the created date has to be <= the created date of... Show More

    Hi all,

    I want to each row to calculate the number of columns, which match the following criteria:

    (1) the created date has to be <= the created date of the specific line
    (2) the close date has to be <= the created date of the specific line


    Example:
    For ID = 4, there are 2 rows, which match the criteria (ID 1 + ID 2). ID 3 does NOT match the criteria, since the close date is after the created date of ID 4. Therefore, the counter should not count this lins.

    IDCreatedClosedCounter
    101.01.202002.01.20200
    202.01.202002.01.20201
    303.01.202005.01.20202
    404.01.202004.01.20202
    505.01.202005.01.20204

     

    I know that I can word with rangesum(peek(, but I do not get this working, taking into account that I have the filter criteria which I need to get into this formula.

    What I started with:

    RangeSum(Above(TOTAL Sum(if(CreatedDate<=CreatedDate and CloseDate<=CreatedDate, Counter)), 0, RowNo(TOTAL)))

    Can anybody help me?

    Thanks
    Florian

    Show Less
Leaderboard

Customer Story

Instant Answers Empower Thousands of Users

Billion-dollar organization delivers quality service and consistency at scale with Qlik Answers, powered by Amazon Bedrock.

Customer Story

Empowering Students With Data Skills for Real-World Impact

Thomas More University works with the Qlik Academic Program and EpicData to encourage and inspire students.

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

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

Forums

Qlik Automate

Less manual work, more data flow. Welcome to Qlik Automate.

Forums

Qlik Predict

Discover how to leverage machine learning and AI to forecast outcomes directly in Qlik.

Forums

Move to Qlik Cloud Analytics

Get guidance, tips, and community support for your journey to Qlik Cloud Analytics.