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: 
  • 279,591 members
  • 45,897 online
  • 2,052,279 posts
  • 155,129 Solutions
Announcements
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here

Welcome to Qlik Community

Recent Discussions

  • forum
  • forum

    Visualization and Usability

    Qlik Pages

    Just had a hands-on go with Qlik's new Pages feature preview and I've got to say – this is genuinely a step in the right direction!  Whilst it's still... Show More

    Just had a hands-on go with Qlik's new Pages feature preview and I've got to say – this is genuinely a step in the right direction! 

    Whilst it's still in preview and has its limitations (no cross-object filtering yet), I can absolutely see this growing into something really valuable for the analytics community.

    What impressed me most:
    ✓ Single landing page for cross-app content
    ✓ Live data feeds from multiple sources
    ✓ Date comparison functionality (neat feature!)
    ✓ Easy to build – no coding required
    ✓ Navigation links for seamless drill-down

    The associative logic between sheets remains the gold standard, but Pages fills a genuine gap for static operational dashboards and status boards. Perfect for executives who need quick summaries without deep exploration.

    If Qlik continues developing this feature – especially around filter controls and cross-object selection – it's going to be a game-changer for how organisations build their analytics portfolios.

    Great work from the Qlik team. Looking forward to seeing where this goes! 

     

    NAM_climber_0-1789333522450.png

     

     

    Show Less
  • forum

    Qlik Replicate

    How to find the table affected by the error “Unable to get table definition for ...

    Hello,I have configured a Log Stream task that reads from an Oracle database.The task failed following a database maintenance activity that temporaril... Show More

    Hello,

    I have configured a Log Stream task that reads from an Oracle database.

    The task failed following a database maintenance activity that temporarily disabled the ARCHIVELOG log mode.

    After ARCHIVELOG was re-enabled, I resumed the Log Stream task. However, the task is unable to complete the resume successfully and remains in the recovering state.

    When reviewing the task log file, I can see the following error messages:

    • Unable to get table definition for table '0'
    • add table desc to the metadata manager has failed

    I found the following link in the Qlik Community, which explains that the error retrieving the table definition should be caused by a DDL operation that modified the structure of a table: https://community.qlik.com/t5/Official-Support-Articles/SOURCE-CAPTURE-E-Unable-to-get-table-definition-for-table-0/ta-p/1809603.

    I tried increasing the task verbosity to understand which tables might have been affected by this change. Specifically, I increased the verbosity of the SOURCE_CAPTURE, SORTER, METADATA_MANAGER and TARGET_LOAD parameters. However, I cannot find any indication in the log file of which tables were affected by the modification.

    Is there any way to identify in Qlik Replicate which tables were affected by the DDL operations that are causing a mismatch with the table metadata registered by Qlik Replicate?

    Thank you in advance for your support.

    Best regards

    Show Less
  • forum

    Talend Cloud

    Task Identification via Partial Info & CLI Safe Termination

    Hello team,Currently, we suspect that two tasks are updating a single table simultaneously, but we are unable to identify which specific tasks are cau... Show More

    Hello team,

    Currently, we suspect that two tasks are updating a single table simultaneously, but we are unable to identify which specific tasks are causing this conflict.
    We are also considering the possibility that it is not displayed on the GUI.

    Could you please assist us with the following two points?

    1. Task Identification Method
    We need to identify the exact tasks involved.
    Could you please advise on the procedure or command to uniquely identify a task using only the following parameters?
    - Partial Task ID (incomplete string)
    - Target table name being modified
    - Gateway information

    2. Safe Termination Procedure for Non-GUI Tasks
    If the identified task is not displayed on the GUI, what is the official and safe procedure (e.g., via CLI or administrative commands) to terminate ONLY that specific old task without impacting or disrupting other running tasks?

    Best Regards.

    Show Less
  • forum

    Administering and Monitoring

    Best Practices for Monitoring Dashboard Performance for Food Menu Data in Qlik C...

    Hi Qlik Community, I’m currently working with food service data that includes a detailed food menu across multiple locations, integrated into a Qlik d... Show More

    Hi Qlik Community,

    I’m currently working with food service data that includes a detailed food menu across multiple locations, integrated into a Qlik dashboard. As our data grows, I’ve noticed some lag in performance, especially during peak access times.

    Could anyone recommend best practices or tools within Qlik Cloud to monitor dashboard performance and identify what might be slowing things down? Is there a way to set up real-time alerts or logs when resource usage spikes?

    Appreciate any insights — especially from those managing content-rich dashboards!

    Thanks,
    Rabnawaz

    Show Less
  • forum

    App Development

    QlikSense app Sheet thumbnail

    How do you get the Sheet thumbnails to reflect the actual content of a sheet. I have 2 images attached. I got one from Operation monitor dashboard tha... Show More

    How do you get the Sheet thumbnails to reflect the actual content of a sheet. I have 2 images attached. I got one from Operation monitor dashboard that comes with QlikSense installation. You see sheet thumbnail reflects the actual content. Second image shows my dashboard which has generic thumbnail.

     

    2019-12-17_17-03-12.jpg2019-12-17_17-05-12.jpg

    Show Less
  • forum

    App Development

    Thumbnail / icon generation on Qlik Sense Enterprise with Butler Sheet Icons

    Hi folks, Could anyone please provide insight into a ERR_INVALID_AUTH_CREDENTIALS error when running Butler Sheet Icons? Butler authenticates with the... Show More

    Hi folks,

    Could anyone please provide insight into a ERR_INVALID_AUTH_CREDENTIALS error when running Butler Sheet Icons?

    Butler authenticates with the client.pem certificate and develops a PLAN, but fails after "closed virtual browser" with ERR_INVALID_AUTH_CREDENTIALS error.

    I have attached the full log from my session.  I have double-checked user id and password; I am using an account with ROOT ADMIN rights in the QMC; the same account owns the "Sales Dashboard" for which I'm trying to create thumbnails.

    Thanks for any available help!

    JR

    Show Less
  • forum

    Water Cooler

    Issues in Qlik after the DB2 LUW upgrade

    Problem Description The source IBM DB2 LUW database has been migrated to a new machine. The new machine retains the same connection configuration as ... Show More

    Problem Description

    The source IBM DB2 LUW database has been migrated to a new machine. The new machine retains the same connection configuration as the previous one, including the hostname, IP addresses, port, and database name.

    The new installation uses:

     

    DB2 LUW Server: 11.5.9
    Qlik Replicate: November 2025 Initial Release
    Qlik Build: 2025.11.0.285
    DB2 Client used by Qlik: 11.5.8
    Target: Kafka

     

    After the migration, the old transaction logs were not copied to the new machine. For this reason, a Reload Target was performed to fully reload the data and establish a new CDC starting point based on the logs generated after the migration.

    The Reload Target completed, and the task started replicating changes. However, the volume of data captured by Qlik is significantly lower than usual.

    During specific time periods, millions of changes were replicated before the migration. After the migration, only approximately 5,000 changes are being captured during those same time periods.

    Observed Behavior

    The issue does not appear to be related to latency:

    • Qlik does not show any significant delay when reading the logs.
    • The task is running.
    • Qlik continues to advance through the stream position.
    • There is no backlog of millions of changes waiting to be applied.
    • The issue is that Qlik is capturing far fewer changes than expected.
    • The reduction occurred after the migration to DB2 LUW 11.5.9.

    All tables included in the task have the following setting enabled:

     

    DATA CAPTURE CHANGES

     

    Therefore, the issue does not appear to be related to the absence of this setting.

    Information About the DB2 Client Used by Qlik

    The following information appears in the task log:

     

    2026-09-12T22:18:09 [SOURCE_CAPTURE]I:
    DB2 client version: 11.05.0800
    (db2luw_endpoint_capture.c:127)

     

    This confirms that Qlik Replicate is using:

     

    DB2 Client 11.5.8

     

    to connect to and read the logs from:

     

    DB2 LUW Server 11.5.9

     

    The current combination is therefore:

     

    Qlik Replicate: 2025.11.0.285
    DB2 Client: 11.5.8
    DB2 LUW Server: 11.5.9

     

    Qlik uses the native IBM API:

     

    db2ReadLog

     

    to read the DB2 LUW transaction log records.

    Impact

    The impact is critical because Qlik appears to be up to date, but the number of captured changes is significantly lower than the actual expected volume.

    The observed behavior is approximately:

     

    Typical volume before the migration: millions of changes
    Volume captured after the migration: approximately 5,000 changes

     

    This raises concerns about whether Qlik is correctly receiving or interpreting all propagatable log records returned by db2ReadLog.

    There is a risk that not all changes made to the source tables are being published to Kafka.

    Checks Performed

    The following points have been confirmed so far:

    1. The database was migrated to a new machine.
    2. The new database uses DB2 LUW 11.5.9.
    3. The hostname, IP addresses, port, and database name remain unchanged.
    4. The old transaction logs are not available on the new machine.
    5. A Reload Target was performed after the migration.
    6. The Full Load completed, and Qlik started processing CDC.
    7. The task does not have a latency issue.
    8. All tables have DATA CAPTURE CHANGES enabled.
    9. Qlik continues to capture some changes, but the volume is abnormally low.
    10. The DB2 client loaded by SOURCE_CAPTURE is version 11.5.8.
    11. The DB2 server is running version 11.5.9.
    12. The Kafka target is available, and Qlik successfully retrieves metadata from all three brokers.

    Kafka Target Evidence

    The log also shows that Qlik connects successfully to all three Kafka brokers:

     

    Kafka client version: 2.11.1
     
    Broker 0:
    b0.kafka.confluent.pro.allfunds.bank:443
     
    Broker 1:
    b1.kafka.confluent.pro.allfunds.bank:443
     
    Broker 2:
    b2.kafka.confluent.pro.allfunds.bank:443

     

    However, the issue appears to be in the DB2 source capture stage, as the number of changes detected at the source is significantly lower than expected.

    Request to Qlik Support

    We would like Qlik Support to confirm the following points:

    1. Whether Qlik Replicate November 2025 Initial Release, build 2025.11.0.285, officially supports a DB2 LUW 11.5.9 server when using the DB2 11.5.8 client.

    2. Whether there are any known compatibility issues involving the following combination:

     

    Qlik Replicate 2025.11.0.285
    DB2 Client 11.5.8
    DB2 LUW Server 11.5.9

     

    1. Whether there are any known issues with the db2ReadLog API or the Qlik parser when reading logs generated by DB2 LUW 11.5.9 through a DB2 11.5.8 client.

    2. Whether the DB2 client must be upgraded to version 11.5.9 to guarantee that all propagatable log records are read correctly.

    3. Whether Qlik Replicate November 2025 SR1 includes any DB2 LUW-related fixes that could affect change capture.

    4. Whether Qlik can continue advancing through the stream position even if certain DB2 log record types are not being correctly interpreted or counted.

    Show Less
  • forum

    Move to Qlik Cloud Analytics

    504 Gateway Time-out

    Hi, When I try to login to my Qlik account I face "504 Gateway Time-out" and I'm not able to login, can you please help me. Thanks   Show More

    Hi, 

    When I try to login to my Qlik account I face "504 Gateway Time-out" and I'm not able to login, can you please help me. 

    Thanks 

     
    Show Less
  • forum

    Visualization and Usability

    Showing both value and share in a pie chart

    Hi everyone, I’m trying to create a pie chart in Qlik Sense where I want to show both the value and the share for each category. For example, I have a... Show More

    Hi everyone,

    I’m trying to create a pie chart in Qlik Sense where I want to show both the value and the share for each category.

    For example, I have a calculated dimension like this:

    =If(
        region = 'REGION_A',
    
        If(
            buyer = 'BUYER_A'
            AND WildMatch(product_type, '*TYPE_01*', '*TYPE_02*'),
            'CATEGORY_A',
    
            If(
                (
                    buyer = 'BUYER_A'
                    AND NOT WildMatch(product_type, '*TYPE_01*', '*TYPE_02*')
                )
                OR buyer = 'BUYER_B',
                'CATEGORY_B',
    
                If(
                    buyer = 'BUYER_C',
                    'CATEGORY_C',
    
                    If(
                        buyer = 'BUYER_D',
                        'CATEGORY_D'
                    )
                )
            )
        )
    )
    

    My measure is:

    Count(DISTINCT transaction_id)

    Ideally, I want both the value and percentage to be displayed on the pie chart itself, or at least have both available in the tooltip.

    What would be the recommended way to achieve this in Qlik Sense? Should I use a custom label expression, a second measure, or another approach?

    Thanks!

    Show Less
Leaderboard

Qlik community MVPs

Qlik Community MVPs — trusted experts driving collaboration, learning, and innovation.

mvp-banner-side-image