Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
下記のようなピボットグラフを作成しています。
当月売上の背景カラーを、「前月差異_売上」がマイナスになればなるほど赤に、プラスになればなるほど青にグラデーションで設定する方法はありますか?
==========
<行>
カテゴリ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:
Any assistance with the above questions is greatly appreciated.
Thanks,
Nak
Hi,
We're embarking on an upgrade of our Qlik Replicate platform to 2024-11
We have the endpoint "Confluent Cloud" now available to us.
My question is - what does the "Confluent Cloud" endpoint has to offer over our existing Kafka endpoints that are going to Confluent cloud?
Is there a reason to switch our existing connections over?
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?
Watch expert-led sessions from Qlik Connect 2025 to see how our latest innovations help you integrate and analyze data.
Salesforce's acquisition of Informatica brings change. Explore options for a smoother transition.
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Analytics and Business Intelligence Platforms.
We’re excited to introduce the ability to manage automations in shared spaces, enabling collaboration and execution through the context of a shared space.
A one-day focused event designed to give you practical strategies and real-world use cases for transforming data, analytics, and AI.
Your journey awaits! Join us by Logging in and let the adventure begin.
Billion-dollar organization delivers quality service and consistency at scale with Qlik Answers, powered by Amazon Bedrock.
Thomas More University works with the Qlik Academic Program and EpicData to encourage and inspire students.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.
Discover how to leverage machine learning and AI to forecast outcomes directly in Qlik.
Get guidance, tips, and community support for your journey to Qlik Cloud Analytics.