Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I'm trying to replicate specific headers defined in the Store Changes option directly into the target tables in Snowflake, in addition to their presence in the __CT (Change Tables). Specifically, I’d like to have the Store Changes headers (e.g., header__change_seq, header__timestamp) added as new columns to the target tables. These new columns should have the same names of the headers defined for the Change Tables.
I tried using Global Rules within the task to add these headers as new columns, referencing their values from the Expression Builder (e.g., $AR_H_TIMESTAMP). However, when the task starts, the tables are suspended because Qlik Replicate attempts to create the Change Tables with duplicate fields, as these headers are already part of the Change Tables structure.
Is it possible, and if so, how, to filter out the Change Tables when applying Global Rules? This would allow the headers to be added as new columns exclusively to the target tables and not to the Change Tables.
I’ve found a few workarounds, but they are not without issues. I’m listing them below for the sake of clarity:
1st workaround: First, I disable the Global Rules. Then I start a Full Reload of the task with the “Keep old changes and store new changes in existing change table” option enabled in Store Changes. After that, I enable the Global Rules and start another Full Reload. In this case the headers are added to the target tables and no error is encountered for the Change Tables since they have been already created.
Problems:
2nd workaround: First, I remove the headers from the Change Tables by unchecking them in the Store Changes tab. Then I enable the Global Rules for all tables (including the Change Tables).
Problems:
I’m also adding that our setup involves an Oracle source database and a Snowflake target.
Thank you in advance for your assistance.
Bonjour,
Depuis la dernière mise à jour de l'application sur Android. Il est impossible de changer les filtres. Une erreur "Critical Issue" apparait. Celà rend l'application inutilisable :(. Est-ce qu'il existe une solution ? Ou une mise à jour est-elle prévue?
Merci !
Corentin
Hi,
We need to migrate Qlik Sense Enterprise (May 2025) from Server 2012 R2 to Server 2025.
I found the support articles that have detailed instructions but couple of questions.
1. When I install Qlik Sense May 2025 to new server can I use the same licence temporarily on the new and old server before we shut down the old server?
2. When I do the backup of Qlik Sense on the old server I understood it does backup of everything (repository database, Qlik Share folder, QMC settings etc). Is that correct?
Hello
I need help figuring out how to accomplish the following:
We have 2 root containers: RC1 and RC2
Is there a way to prevent developers from other than team1 to make DCGV calls to RC1?
I have 3 fields
Client
Month
Revenue
I'm trying to pull into a straight table a chart that will list the CLIENTS and show REVENUE for the latest month where the client had revenues.
Some clients don't have revenues in the latest month and instead of showing a blank, I'd like to show the monthly revenue for the latest month where it existed.
firstsortedvalue does the trick for the earliest month, but is there a function for the latest month?
Thanks in advance!
I have being trying to setup automation for 2 application to be refreshed every 5 mins (Extract and UI), using Loop and every automation will run for 4 hours as maximum execution time for an automation is 14400 seconds, so we are ending our automation run when Runtime goes beyond 14300 second, keeping 100 seconds, buffer for next run to be scheduled,
But sometimes the automation stop premautrely, Like around 2 hr and 30 mins in or 47 min run, it got finished,
without throwing any error, and the condtion was still false for (Runtime >= 14300), so It woulnt have ended.
In the DO Reload block I have tried both wait for reload to complete and Start reload and continue, as we need 48 reloads per 4 hours, Start reload and continue seems the best option. but when the reload gets queued, the Loops keep giving output Reload Ongoing, till its finished, but soemtimes, its just ends the automation on the Loop without throwing any error, or sometimes, it just end on Sleep block.
I'm attaching screenshots and Automation Template for your reference,
I would really appreciate if someone can help me on this issue.
We’re excited to welcome Brett to the Qlik Community team this summer! Brett is joining us as an IT Community Intern and will be working closely with us to support engagement, manage content, and keep things running smoothly behind the scenes.
He’s currently a senior at Penn State, where he studies Human-Centered Design and Development. Outside of the classroom, Brett enjoys skiing, playing basketball, making music on the piano, and watching movies. (Bonus fun fact: he can juggle!)
You’ll see him around the Community this summer, so feel free to say hello and help us give him a warm welcome—we’re thrilled to have him on board! @Brett_Cunningham @Sue_Macaluso @Melissa_Potvin @Jamie_Gregory @nicole_ulloa @Tammy_Milsom
Within Chart --> Table I am trying to highlight rows based on the content (string) like below table. By using following expression within "Background color expression"
If(Product='Apple', Yellow(), If(Product='Samsung', Green(), If(Product='Google', Blue(), Red())))
However, I get below output,
If I use my calendar to display only August and July then I get below output,
Meaning only the latest month is getting displayed with right colors. I don't know what am i missing here. Can someone please help. I tried using Pick and match functions but still getting same result.
I have a Qlik Sense application with a template sheet that contains a series of table and chart objects. Each day, depending on certain conditions, I need to duplicate this template sheet and update specific parameters within the expressions of each object. I’ve created an Automation process that successfully duplicates the template sheet, but I’m unsure how to modify the expressions of the objects within the new sheet or how to change the sheet’s show/hide condition. Do you have any suggestions or ideas on how to achieve this?
Data Flow simplifies, democratizes, and accelerates the last mile of data preparation for analytics, machine learning, and AI.
Read how to embed AI-powered analytics to innovate, enhance customer satisfaction, and fuel business growth.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik empowers Foodbank Victoria with real-time data insights, optimizing food acquisition and distribution to deliver 25 million meals annually while reducing waste and costs across its statewide relief efforts.
Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.
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!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!