Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!)
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!
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
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?
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.
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.
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?
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)
Will Qlik capture deletes that happen during or after the purge (from DB2 logs) and apply them to emp_incremental
?
How can I define and apply a last_updated_dt = GETDATE()
field in both full load and CDC using the Derived Column transformation?
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
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?
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?
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:
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?
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.
ID | Created | Closed | Counter |
1 | 01.01.2020 | 02.01.2020 | 0 |
2 | 02.01.2020 | 02.01.2020 | 1 |
3 | 03.01.2020 | 05.01.2020 | 2 |
4 | 04.01.2020 | 04.01.2020 | 2 |
5 | 05.01.2020 | 05.01.2020 | 4 |
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
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Analytics and Business Intelligence Platforms.
We’re excited to introduce the ability to manage automations in shared spaces, enabling collaboration and execution through the context of a shared space.
A one-day focused event designed to give you practical strategies and real-world use cases for transforming data, analytics, and AI.
Salesforce's acquisition of Informatica brings change. Explore options for a smoother transition.
Your journey awaits! Join us by Logging in and let the adventure begin.
Billion-dollar organization delivers quality service and consistency at scale with Qlik Answers, powered by Amazon Bedrock.
Thomas More University works with the Qlik Academic Program and EpicData to encourage and inspire students.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
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.
Discover how to leverage machine learning and AI to forecast outcomes directly in Qlik.
Get guidance, tips, and community support for your journey to Qlik Cloud Analytics.