下記のようなピボットグラフを作成しています。

当月売上の背景カラーを、「前月差異_売上」がマイナスになればなるほど赤に、プラスになればなるほど青にグラデーションで設定する方法はありますか？

＝＝＝＝＝＝＝＝＝＝

＜行＞

カテゴリ1、カテゴリ2、カテゴリ3、値

＜列＞

年度、半期、四半期、年月

＜値＞

当月売上

使用する計算フィールド

当月売上：Sum({<データソース=[当月データ]::データソース>}[売上])

前月売上：Sum({<データソース=[前月データ]::データソース>}[売上])

前月差異_売上：当月売上ー前月売上

Hi All, @rubenmarin 

in  operation monitor dashboard all data is restricted but not in user table data is not looking  due to data not in sync . 

my tables is lined with userid  with different format    like some text and right side   below is data 

Table1   ,                      Table 2

userID                             User ID 

hbap\245362                    3452648

hbeu\352727                    5375828

        563836                     hbap\345274

        453739                     hbeu\546896

i tried this but not working 

num(SubField(userId,'\',2)) as UserId,

Begini cara membatalkan pinjaman Lazbon, bisa menghubungi Call center via WhatsApp (0813) 61112643. Setelah itu sampaikan alasan pembatalan anda. Lalu siapkan juga data diri untuk mendukung proses pembatalan nya, dan ikuti prosesnya sampai selesai. 

Hi Team,

I'm facing an issue accessing the Qlik Replicate web UI from outside the Remote Desktop (RD) environment. The application works perfectly fine within RD, but when I try to access it from my local machine, the page does not load as expected. If I access the application by including the port number, the page loads but appears completely blank — just a white screen with no content. On the other hand, if I try to access it without specifying the port, I receive a DNS probe error and the page doesn't load at all.

The server hostname resolves correctly to the expected IP address, and I'm able to ping it from outside RD successfully. I’ve also tried accessing the interface using the IP address and port number 443 directly, but the result is the same — just a white page.

Internally, the server appears to be listening on port 443, and the Qlik Replicate UI functions as expected. However, from any external machine, the web UI is unresponsive beyond loading a blank screen. I have also enabled SSO for Qlik Replicate but still the same

I have tried all standard troubleshooting steps like verifying network connectivity, checking host resolution, confirming port availability, and updating local mappings but the issue still persists.

I would appreciate any guidance on whether there are specific configuration changes required to allow the Qlik Replicate web UI to function properly outside RD.

Thanks in advance!

Dear Qlik Support,

We are currently replicating data from DB2 iSeries to Oracle using Qlik Replicate.

We noticed the following warning keeps appearing:
"Source changes that would have had no impact were not applied to the target database. Refer to the 'attrep_apply_exceptions' table for details."

We checked and confirmed that no one has modified the target database directly.

The issue seems to happen on one column (let’s call it column A), defined as NUMBER(13,2) in Oracle.
For example:

• The update value is '-6642500.00', but the value in Oracle is '-66425'.

• Similarly, update value is '6720900.00' , but becomes '67209'.

So far, this only happens to this column. Other numbers are updated correctly. Because of the difference in values, Oracle is not being updated.

Can you help us understand why this is happening?

Thank you for your assistance.

Hi Experts,

I need to values to be in next line when the values has the space, in other words, wrap the text automatically when the text doesn't to the chart and should be shown as new line. if you notice below values in pie chart, full value doesn't appear in the chart but can see in the tool tip, instead i want to see as new line.

Hi Support,

We are seeing an issue in which data is not being replicated to Eventhubs. The Replicate logs show a series of errors like so: "[TARGET_APPLY ]I: Failed to produce Eventhubs message with record id <xx> to partition <-1> in hub '{hub-name}'. One or more errors occurred. Value cannot be null." The errors appear constantly as the task runs, however they don't cause the task to stop.

I'd like to understand 3 things:

• What is the "value" referencing in the error message? Is it a value in the data record or something in the connection that is Null?
• Is this data validation coming from Event Hubs or is Replicate able to identify an issue prior to sending the data to Event Hubs? i.e. Does Event Hubs reject the message or is Replicate blocking the message from being sent?
• Considering that data isn't being sent to Event Hubs, why is the error classed as an Info (I:) rather than an error message (E:)?

Any assistance with the above questions is greatly appreciated.

Thanks,

Nak

Hi

I use Extension, Reboot Timeline, to generate Gantt chart.

I have some questions about visualization.

1. the name of each progress stage appears directly on each bar, but I’d prefer to hide those labels and display them as a legend instead.

2.Time is set as a dimension, but I’d like to exclude certain hours—for example, 12:00 PM to 1:00 PM.

This is because the Gantt chart represents manufacturing data, and I want to remove break times from the timeline.

Hi,

We have the following table:

messages:
LOAD
    country,
    message_count,
    client_cost,
    sent_month
FROM [lib://QVDFOLDER/messages.qvd] (qvd);

sent_month is a Date in format MMM YYYY (e.g. Jun 2025) :

and Data model viewer shows the following tags:

On the sheet we added a table, and as the first column (dimension) we added country.

Now we want to add a new column (measure) that will display Sum([message_count]) for the previous month only. 

We tried using the following expression:
Sum({<[sent_month] = {"=$(Date(MonthStart(AddMonths(Today(), -1)), 'MMM YYYY'))"}>} message_count)

But it doesn't work:

We checked the data and there are messages that were sent in the previous month, but when we use the above expression - it shows an empty table. 

We tested this part of the expression by adding it to be a label - and it works:

Date(MonthStart(AddMonths(Today(), -1)), 'MMM YYYY')

Do you know why the above expression doesn't work, what might need to be changed to make it work?