topic Re: [Filter][Expression Builder] About Evaluating Numeric Conditions. in Qlik Replicate

[Filter][Expression Builder] About Evaluating Numeric Conditions.

HNAKAGAW — Tue, 23 Jun 2026 01:59:42 GMT

Hello support team

[Environment]

Source : Oracle 19c

Target : Oracle 19c

Qlik Replicate 2026.05

It seems that the Test Expression feature in Expression Builder does not work properly with numeric types.

ID column data type is INT1. (Oracle Datatype is number(1))

1. For $ID==1, the result is false (0) whether ID value is 1 or 0.

2. For $ID=1, the result is false (0) whether ID value is 1 or 0.

* Since I wasn’t sure whether to use “==” or “=” for numeric comparisons, I tried both.

* In both cases, adding spaces before or after the equals sign did not change the result.

I expected that at least one of these two cases would return true (1) when ID value is 1. Am I misunderstanding something?

Best Regards

Nakagawa

Re: [Filter][Expression Builder] About Evaluating Numeric Conditions.

DesmondWOO — Wed, 24 Jun 2026 03:49:45 GMT

Hi @HNAKAGAW san,

Using $ID == 1 is correct, you can ignore the failed test result. While adding double quotes (e.g., $ID == "1") allows the test to pass, it will cause the actual comparison logic to fail while the task is running.

Regards,
Desmond

Re: [Filter][Expression Builder] About Evaluating Numeric Conditions.

HNAKAGAW — Wed, 24 Jun 2026 04:41:35 GMT

Hi Desmond san

Thank you for your reply.

Is the fact that “$ID == 1” isn’t evaluated correctly (the test expression returns false (0) when the ID value is 1) a bug in Replicate?

Best Regards

Nakagawa

Re: [Filter][Expression Builder] About Evaluating Numeric Conditions.

DesmondWOO — Wed, 24 Jun 2026 05:49:13 GMT

Hi Nakagawa san @HNAKAGAW,

I searched the user guide but couldn't find this specific limitation documented. I recommend opening a support ticket so we can verify this behavior for you.

Regards,
Desmond

Re: [Filter][Expression Builder] About Evaluating Numeric Conditions.

HNAKAGAW — Mon, 29 Jun 2026 01:55:20 GMT

Hi Desmond san

Thank you for your reply.

I created a support ticket, and they are currently looking into it.

Best Regards

Nakagawa