Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a SQL Server source table that has 5 columns:
The MERGE statement looks like this (the names were changed to protect the innocent):
MERGE INTO "dbo"."my_table_name" T
USING (
SELECT *
FROM "public"."attrep_changes6004D92ED521268C"
WHERE "table_id" = 1
) S
ON (T."ASSIGNMENTID" = IFF("table_id" = 1, TRY_CAST(S."seg1" AS NUMBER(38, 0)), NULL))
AND (T."PERIODID" = IFF("table_id" = 1, TRY_CAST(S."seg2" AS NUMBER(38, 0)), NULL))
WHEN MATCHED AND "replicate_op" = 0 AND "table_id" = 1
THEN DELETE
WHEN MATCHED AND "replicate_op" <> 0 AND "table_id" = 1
THEN UPDATE SET
T."NumericColumn1" = IFF("table_id" = 1, TRY_CAST(S."col1" AS NUMBER(38, 0)), NULL),
T."NumericColumn2" = IFF("table_id" = 1, TRY_CAST(S."col2" AS NUMBER(38, 0)), NULL),
T."NumericColumn2" = IFF("table_id" = 1, TRY_CAST(S."col3" AS NUMBER(38, 0)), NULL),
T."DatabaseInsertDate" = IFF("table_id" = 1, TRY_CAST(S."col4" AS TIMESTAMP(3)), NULL),
T."DatabaseUpdateDate" = IFF("table_id" = 1, TRY_CAST(S."col5" AS TIMESTAMP(3)), NULL)
WHEN NOT MATCHED AND "replicate_op" <> 0 AND "table_id" = 1
THEN INSERT (
"NumericColumn1",
"NumericColumn2",
"NumericColumn3",
"DatabaseInsertDate",
"DatabaseUpdateDate"
)
VALUES (
IFF("table_id" = 1, TRY_CAST(S."col1" AS NUMBER(38, 0)), NULL),
IFF("table_id" = 1, TRY_CAST(S."col2" AS NUMBER(38, 0)), NULL),
IFF("table_id" = 1, TRY_CAST(S."col3" AS NUMBER(38, 0)), NULL),
IFF("table_id" = 1, TRY_CAST(S."col4" AS TIMESTAMP(3)), NULL),
IFF("table_id" = 1, TRY_CAST(S."col5" AS TIMESTAMP(3)), NULL)
);
I figured that the issue is caused by TRY_CAST and that the TRY_CAST is returning a NULL for my DatabaseInsertDate. The FULL load works fine, but from what I can see the full load is doing a COPY INTO and not running a TRY_CAST. I have tried adding a transformation on the Table Settings for this table to
strftime('%Y-%m-%d %H:%M:%f', $DatabaseInsertDate)
...but that has not helped.
The public.attrep_changes6004D92ED521268C table goes away as soon as the error occurs so I cannot see the data behind the issue.
Please help. Thanks
HI an amazing Qlik community ![]()
For those who have migrated apps to Qlik Cloud - have you come across any major app design offenders that caused a dramatic increase in App Base RAM size (above 5 GB limit)?
We’re seeing an app with a ~0.2 GB file size consuming ~12GB of Base RAM.
Has anyone experienced something similar?
Which visualisations, design choices, data models etc did you find that significantly increased app base RAM ?
Any insights, lessons learned, or best practices would be greatly appreciated ![]()
EM version : v2024.11 , v2025.11.
Hello support team.
I would like to export the Enterprise Manager server-level settings (specifically notifications, logging configurations, etc.) into a JSON format to perform a diff comparison before and after the upgrade.
What I have tried: I attempted to use the following API endpoint: https://<localhost>/attunityenterprisemanager/api/v1/servers/<em-host>?action=export
The issue: The above command only seems to export the Replicate Server Settings, not the configurations for Enterprise Manager itself.
My question: Is there any way to export the QEM Server settings (Notification services, Log levels, etc.) to a JSON file?
I would appreciate any guidance or documentation on how to extract these QEM server settings.
Best regards,
Hi All,
I am getting issue while using Qlik N-printing on demand service, when i am trying to download report through on demand dashboard bundle, i have attached screen shot for your reference
As a workaround, if we log in to N-Printing in a separate window first, we are then able to download the report successfully. Otherwise, the system displays an error stating that it is unable to connect to the server.
I have tried using the FQDNs, localhost, and IP/domain configurations, and also attempted Windows authentication.
Regards,
Rohit
Good afternoon, everyone!
Happy New Year to you all.
I am a Cybersecurity Researcher/Red Teamer based in Brazil, and I recently identified CVE-2025-61138 in Qlik Sense (details here: https://nvd.nist.gov/vuln/detail/CVE-2025-61138).
So far, I haven't been able to find any official updates or a clear remediation path for this vulnerability.
Could anyone clarify if there have been any recent changes or if a fix is scheduled for upcoming versions?
Thank you, and have a great week!
I have this table with Name and Color
ColorData:
I want to get all the distinct sorted combinations of each name. Joined by a pipe | symbol.
ColorDataCombos:
Note: if it is not possible to get sorted and distinct ones that’s fine. I’ll take all permutations for each name even though there may be many
I have an xlsx where there is data from column A till column AR.
In the future there can be data till column BE.
So I will load all columns till AE in Qlikview.
If I do 'Data from data files' and select my xlsx and the correct tab then I see only till column AW.
If I put values in columns AX till BE I see the columns for adding in the script.
Bur if those are empty it's only till AW. How can I load the columns AX till BE even if there is no data in.
Who knows how I can load the empty columns?
Hi!
As part of our ongoing commitment to provide the best possible experience for Qlik Cloud users, we are removing the Basic and Full User construct from tenants on capacity-based subscriptions, simplifying to just User.
Read all the details here!
Hi!
As part of our ongoing commitment to provide the best possible experience for Qlik Cloud users, we are removing the Basic and Full User construct from tenants on capacity-based subscriptions, simplifying to just User.
Read all the details here!
FREE TRIAL
Data has stories to tell—let Qlik help you hear them. Start your FREE TRIAL today!
Dare to unleash a new professional you in 2026. Join Connect April 13–15 and supercharge your skill sets.
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Data Integration Tool.
Trends 2026 Alert! Plug into this rewired framework for driving ROI from AI.
Learn why legacy data platforms can’t meet today’s AI and analytics demands and how Qlik provides a modern, independent, future-ready alternative.
Solve the real-world need for real-time data with Change Data Capture (CDC). What is CDC and how to master it?
Your journey awaits! Join us by Logging in and let the adventure begin.
Afcons Infrastructure partnered with Qlik to unify its data and build dynamic dashboards, reducing review times from weeks to hours and enabling on-demand reporting across its global operations.
By implementing Qlik Analytics, Atria Convergence Technologies improves insight into churn, revenue, and downtime, driving faster decisions and more proactive customer support.
Hydronorth uses Qlik to replace disconnected data systems with a single source of truth, improving alignment, speeding up decisions, and reducing manual work.
With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.
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.
The Qlik Product Recap showcases the newest features with quick demos and shareable resources to help you stay current?
You can test-drive Qlik for free? Try Qlik Talend Cloud to integrate and clean data without code, or explore Qlik Cloud Analytics to create AI-powered visualizations and uncover insights hands-on.
Salesforce’s acquisition of Informatica could put your flexibility on hold? Qlik makes it easy to keep your data initiatives moving forward.
You can move beyond batch processing and harness real-time data to power AI and faster decisions? Discover how in our new eBook, Mastering Change Data Capture.