Hi,

Talend Studio

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

Thanks

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

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

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

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.

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.

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.

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!

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?

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.

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.

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)