Hi,

I have Current Sales Value and Previous Value in the Pivot table.

The problem is: when there is no current sales value 12.01.2026 then there is no values for the previous day value while there is previous day sales value. The problem is my assumption Qlik has no value for today then it is like - for the current date and it is not showing anymore for the previous value. While, I see there are values for the 11.01.2026.

I enclosed expression with "alt" while it is not working because there is no values:

alt(sum({<previous_flag = {1}>} sales), 0)

How to fix this situation?

Thanks

hello

i need some information about resolution of this issue Qlik Enterprise Manager disconnects from Qlik Replicate and fails to monitor

Version 2025.5 or 2025.11 of Qlik replicate/EM are also affected by this issue or is it definitively resolved with them ?

Are there any news/update about QB-26321 and/or  QB-27571 ?

We are migrating Qlik EM+Replicate from 2024.5 to 2025.5 and we like tro know if in the targer version this issue is resolved.

Thanks in advance

Alessandro

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