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: 
  • 267,785 members
  • 7,514 online
  • 2,047,886 posts
  • 154,479 Solutions
Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    TRY_CAST resulting in a NULL value and causing the NULL result in a non-nullable...

    I have a SQL Server source table that has 5 columns:   3 non-nullable INTEGER columns  1 non-nullable DATETIME column that records the database inser... Show More

    I have a SQL Server source table that has 5 columns: 

    1.  3 non-nullable INTEGER columns
    2.  1 non-nullable DATETIME column that records the database insert date 
    3. 1 nullable DATETIME column that records the update date

    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

    Show Less
  • forum

    Move to Qlik Cloud Analytics

    Ballooned App Base RAM size

    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 dramat... Show More

    HI an amazing Qlik community :waving_hand:

    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 :folded_hands:

    Qlik Cloud 

    Show Less
  • forum

    Qlik Replicate

    How to export Qlik Enterprise Manager Server settings to JSON for version compar...

    EM version : v2024.11 , v2025.11. Hello support team.I would like to export the Enterprise Manager server-level settings (specifically notifications, ... Show More

    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,

    Show Less
  • forum

    Qlik NPrinting

    Getting Issue while use qlik nprinting on demand service

    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 hav... Show More

    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

    rohitbibe07_0-1768289390130.pngrohitbibe07_1-1768289411455.pngrohitbibe07_2-1768289447235.png

    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

    Show Less
  • forum

    Reporting Service & Alerting

    Fix / Patch for CVE-2025-61138 (Qlik Sense)

    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-61... Show More

    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!

    Show Less
  • forum

    Talend Studio

    Error Download jar talendagent, talendboot, talend CBP

    No se logra descargar jar talendagent, talendboot, talend CBP me pueden indicar en donde las puedo obtener
  • forum

    App Development

    Qlik Sense Permutations

    I have this table with Name and Color ColorData: LOAD * INLINE [ Name, Color Bob, Red Bob, Yellow John, Blue John, Red John, Yellow Linda, Blu... Show More

    I have this table with Name and Color

    ColorData:

    LOAD * INLINE [
    Name, Color
    Bob, Red
    Bob, Yellow
    John, Blue
    John, Red
    John, Yellow
    Linda, Blue
    Linda, Green
    Linda, Yellow ];

    I want to get all the distinct sorted combinations of each name. Joined by a pipe | symbol.

    ColorDataCombos:

    LOAD * INLINE [
    Name, ColorCombo
    Bob, Red|Yellow
    John, Blue|Red
    John, Blue|Yellow
    John, Red|Yellow
    John, Blue|Red|Yellow
    Linda, Blue|Green
    Linda, Blue|Yellow
    Linda, Green|Yellow
    Linda, Blue|Green|Yellow ];

    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

    Show Less
  • forum

    QlikView App Dev

    Load empty columns out of xlsx

    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 Q... Show More

    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?

    kris_vliegen_0-1767988936038.png

     

    Show Less
  • forum

    Management & Governance

    🔔 Streamlining user types in Qlik Cloud capacity-based subscriptions

    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 f... Show More

    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!

    Show Less
  • forum

    Move to Qlik Cloud Analytics

    🔔 Streamlining user types in Qlik Cloud capacity-based subscriptions

    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 f... Show More

    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!

    Show Less

FREE TRIAL

Data has stories to tell—let Qlik help you hear them. Start your FREE TRIAL today!

Leaderboard

Qlik community MVPs

Qlik Community MVPs — trusted experts driving collaboration, learning, and innovation.

mvp-banner-side-image

Customer Story

Afcons Boosts Efficiency with Qlik

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.

Customer Story

Enhancing Customer Experience Through Smarter Insights

By implementing Qlik Analytics, Atria Convergence Technologies improves insight into churn, revenue, and downtime, driving faster decisions and more proactive customer support.

Customer Story

Breaking Down the Data Bottlenecks

Hydronorth uses Qlik to replace disconnected data systems with a single source of truth, improving alignment, speeding up decisions, and reducing manual work.

Customer Story

French Ministry of Armed Forces Develops a Data-Centric Culture

With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.

Your Place, Your People

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

Did you know...

Catch the Latest from Qlik

The Qlik Product Recap showcases the newest features with quick demos and shareable resources to help you stay current?

Did you know...

Qlik Free Trials

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.

Did you know...

Turn change into opportunity

Salesforce’s acquisition of Informatica could put your flexibility on hold? Qlik makes it easy to keep your data initiatives moving forward.

Did you know...

Mastering Change Data Capture

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.