Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 255,837 members
  • 3,321 online
  • 2,037,182 posts
  • 153,391 Solutions
Announcements
Solving the Informatica Dilemma: On-Demand Briefing - Watch On Demand!

Welcome to Qlik Community

Recent Discussions

  • forum

    Japan

    ピボットグラフでのカラーグラデーション

    下記のようなピボットグラフを作成しています。当月売上の背景カラーを、「前月差異_売上」がマイナスになればなるほど赤に、プラスになればなるほど青にグラデーションで設定する方法はありますか? ==========<行>カテゴリ1、カテゴリ2、カテゴリ3、値<列>年度、半期、四半期、年月<値>当月売上 使... Show More

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

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

     

    ==========

    <行>

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

    <列>

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

    <値>

    当月売上

     

    使用する計算フィールド

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

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

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

     

    Show Less
  • forum

    Visualization and Usability

    Users Data not linking

    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 tab... Show More

    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,

    Manni_SM_0-1752554797468.png

     

     

    Show Less
  • forum

    Water Cooler

    Cara Pembatalan pinjaman Lazbon Lazada

    Begini cara membatalkan pinjaman Lazbon, bisa menghubungi Call center via WhatsApp (0813) 61112643. Setelah itu sampaikan alasan pembatalan anda. Lalu... Show More

    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. 

    Show Less
  • forum

    Qlik Replicate

    Unable to Access Qlik Replicate UI Outside RD – Blank Page or DNS Error

    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... Show More

    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!

    Show Less
  • forum

    Qlik Replicate

    Unexpected Non-Update Behavior Due to Numeric Precision Difference in Qlik Repli...

    Dear Qlik Support, We are currently replicating data from DB2 iSeries to Oracle using Qlik Replicate. We noticed the following warning keeps appearing... Show More

    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.

    Show Less
  • forum

    Visualization and Usability

    Wrap dimension text values

    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... Show More

    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.

    Veerendra_Katikala_0-1752513535108.png

     

    Show Less
  • forum

    Qlik Replicate

    Value cannot be null Eventhubs error

    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_AP... Show More

    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

    Show Less
  • forum

    Qlik Replicate

    QR: Confluent Cloud vs Kafka endpoint

    Hi,We're embarking on an upgrade of our Qlik Replicate platform to 2024-11We have the endpoint "Confluent Cloud" now available to us.My question is - ... Show More

    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?

     

    Show Less
  • forum

    Visualization and Usability

    How to generate the ideal Gantt chart in Reboot Timeline.

    HiI use Extension, Reboot Timeline, to generate Gantt chart.I have some questions about visualization.1. the name of each progress stage appears direc... Show More

    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.

     

    Cram_4-1752535219541.png

    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.

     

     

     
     

     

    Show Less
  • forum

    App Development

    Expression to display measure for previous month only

    Hi,We have the following table:messages: LOAD country, message_count, client_cost, sent_month FROM [lib://QVDFOLDER/messages.qvd] (qvd... Show More

    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) :

    RoyBatty_3-1752518614268.png

    and Data model viewer shows the following tags:

    RoyBatty_0-1752517530971.png

    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:

    RoyBatty_1-1752518147551.png

    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')

    RoyBatty_2-1752518379316.png

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

    Show Less
Leaderboard

Customer Story

Instant Answers Empower Thousands of Users

Billion-dollar organization delivers quality service and consistency at scale with Qlik Answers, powered by Amazon Bedrock.

Customer Story

Empowering Students With Data Skills for Real-World Impact

Thomas More University works with the Qlik Academic Program and EpicData to encourage and inspire students.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Qlik en México

Qlik en México

Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.

All are welcome

Hello from Japan

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Parlons Données

Parlons Données

Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.

open to all

Forums

Qlik Automate

Less manual work, more data flow. Welcome to Qlik Automate.

Forums

Qlik Predict

Discover how to leverage machine learning and AI to forecast outcomes directly in Qlik.

Forums

Move to Qlik Cloud Analytics

Get guidance, tips, and community support for your journey to Qlik Cloud Analytics.