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,620 members
  • 11,671 online
  • 2,047,787 posts
  • 154,470 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

    Talend Studio

    Talend studio merge results dialog closed by accident

    Hi,Talend StudioVersion: 8Build id: 20250218_0945-patchSometimes developers close the merge results dialog by accident.Is it possible to re-open the m... Show More

    Hi,

    Talend Studio

    Version: 8

    Build id: 20250218_0945-patch

    Sometimes developers close the merge results dialog by accident.

    Is it possible to re-open the merge results dialog without re-doing the merge?

    Thanks

    Show Less
  • forum

    Talend Studio

    Talend Context Variable not loading from file data

    Hi,I am trying to load context variable value from file data, getting null value. I don't want load File data via any talend components. Please check ... Show More

    Hi,

    I am trying to load context variable value from file data, getting null value. I don't want load File data via any talend components. Please check & suggest.

    File Name : test.properties

    File Data:

    kafkaUser=testUser

     

     

    Show Less
  • forum

    App Development

    Help with filtering Data in Qlik

    Hello, Can anyone please help me how can i get filter below data sets into two outputs using QLik. Sample Data: Date            ID      Amount1/1/2025... Show More

    Hello,

    Can anyone please help me how can i get filter below data sets into two outputs using QLik.

    Sample Data:

    Date            ID      Amount
    1/1/2025    AAA       2
    2/1/2025    AAA       5
    12/1/2025  AAA       2
    12/1/2025  AAA       5
    12/1/2025  AAA       2
    23/1/2025  AAA       2
    24/1/2025  AAA       5

    Output1
    Date            ID     Amount
    1/1/2025    AAA       2
    12/1/2025  AAA       2
    12/1/2025  AAA       2
    23/1/2025  AAA        2


    OutPut2
    Date           ID     Amount
    2/1/2025    AAA      5
    12/1/2025  AAA      5
    24/1/2025   AAA      5

     

    Thanks in Advance

    Show Less
  • 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

    Qlik Automate

    Users can't trigger an automation execution via a button in a published app

    Hello allI have a button in my Qlik Cloud app that executes an automation in triggered mode. When I publish the app to a managed space so that end use... Show More

    Hello all

    I have a button in my Qlik Cloud app that executes an automation in triggered mode. When I publish the app to a managed space so that end users can trigger it themselves, they click the button, but the automation won't be executed.

    It seems like only the owner of the automation is allowed to execute it.

    I did everything in this video: https://youtu.be/uwtpmjumejc?si=9kLwfiOoab4Ywhr0 in manual mode and trigger mode, also nothing.

    How can I resolve this? Also is this a limitation of the Analyzer License?

    Thanks

    Important Update: The automation trigger works inside the tenant but not in the embedded app. I forgot to mention that I'm embedding the app inside and iframe in my web app, and I think the limitation comes from this.

    Show Less
  • forum

    QlikView App Dev

    Wrong week numberin QlikView

    Hi everyone,Using this code blow :WeekName([Calendar date],0,-4)I got the last week of the year 2025 from 25 december to 31 december 2025 as the 1st w... Show More

    Hi everyone,

    Using this code blow :

    WeekName([Calendar date],0,-4)

    I got the last week of the year 2025 from 25 december to 31 december 2025 as the 1st week of the year 2026 instead of the last year.

    Nourrahmcnean_1-1768320220078.png

    I tried this code below, but it didn't work:

    if(       date <= date('31/12/2025', 'DD/MM/YYYY') AND date >= date('25/12/2025', 'DD/MM/YYYY')         
            ,        53,
           if(date <= date('01/01/2026', 'DD/MM/YYYY') AND date >= date('07/01/2026', 'DD/MM/YYYY') 
           ,1,Week(date, 0, -4)-1 )

    Is there another way to solve this? Thanks in advance.

    Show Less
  • forum

    Qlik Automate

    Call PostgreSQL procedure from Qlik Automation Block

    HI, In Qlik Automation I’m calling a PostgreSQL procedure using the Postgre>Do Query block:I simply put into 'Query *' field:call schema.procedure_nam... Show More

    HI, In Qlik Automation I’m calling a PostgreSQL procedure using the Postgre>Do Query block:

    I simply put into 'Query *' field:
    call schema.procedure_name();

    The block usually keeps running for a 2 hours 5 minutes or eventually times out, even though in PostgreSQL the procedure is triggered immediately and finishes in less than a millisecond (based on my logs).

    Do you have any experience or recommended block/workaround for this?

    Thanks!

     

    Show Less
  • forum

    App Development

    Master Measures & Dimension Definitions

    Is there a way we can update Master Item descriptions for Master dimensions & Measures like we can add { Comment Field } descriptions for Table dimens... Show More

    Is there a way we can update Master Item descriptions for Master dimensions & Measures like we can add { Comment Field } descriptions for Table dimensions & measure in Qlik script?

    Show Less
  • forum

    Visualization and Usability

    How to Create an Excel-Style Spreadsheet in Qlik Sense

    Your Qlik apps keep getting smarter.But users still ask for Excel.What if that spreadsheet work stayed in Qlik?Dashboards can look great, insights flo... Show More

    Your Qlik apps keep getting smarter.
    But users still ask for Excel.
    What if that spreadsheet work stayed in Qlik?

    Dashboards can look great, insights flow in real time, reports run on autopilot.
    Then someone needs spreadsheet flexibility, and Excel is back to:

    • Run a quick what-if
    • Add a formula or tweak a value
    • Format it the way they want

    So the loop begins 🔁

    • Export data
    • Edit in a file
    • Share copies
    • Bring results back into the app

    That is how version sprawl and context switching creep into an otherwise clean analytics flow.

    🎯 That is why we built an Excel-style spreadsheet experience for Qlik Sense.

    spreadsheets-excel-for-qlik-sense-by-anychart.png

    Spreadsheet work can now happen right inside your Qlik app:
    Excel-like grid with cell editing
    Formulas & functions
    Rich formatting & keyboard shortcuts
    Multi-sheet workbooks
    Sparklines & full charts

    And more familiar spreadsheet essentials, connected to live Qlik data.

    New on our blog: a step-by-step tutorial (with video 🎥) showing how to create an Excel-style spreadsheet in Qlik Sense with our Spreadsheets extension. Check it out.

    Show Less
  • forum

    Talend Studio

    [Article] The Art of the Match (and How to Survive It)

    Good day, Qlik Community!I have a new article on Data Voyagers, the first of 2026! It is about Matching algorithms. Although we can use Talend Studio ... Show More

    Good day, Qlik Community!

    I have a new article on Data Voyagers, the first of 2026! It is about Matching algorithms. Although we can use Talend Studio for these tasks, this article is valid even for non-talend users.

    It breaks down each method to verify if two records are simular. It is a very detail article, another one of my series "the theory behind Qlik".

    Read it here:

    The Art of the Match (and How to Survive It)

    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.