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,563 members
  • 31,545 online
  • 2,052,276 posts
  • 155,128 Solutions
Announcements
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here

Welcome to Qlik Community

Recent Discussions

  • 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
  • forum

    App Development

    [ARTICLE] How to identify duplicated fields in Qlik Cloud ?

    After a long wait, Qlik Cloud has finally introduced a feature that can save a LOT of time for developers! 🙌When loading data, if a field is duplicat... Show More

    After a long wait, Qlik Cloud has finally introduced a feature that can save a LOT of time for developers! 🙌

    When loading data, if a field is duplicated, Qlik now tells you exactly which field is causing the problem. 🎯

    Before this update, I had to manually search for the duplicated field — and sometimes there were hundreds of fields to go through. 😩🔎

    Now? Qlik simply shows you the exact name of the duplicated field. 💥
    Less manual work.
    Less frustration.

    More time to focus on what really matters: building things. 👨‍💻
    This may look like a small improvement, but for anyone working with large data loads, it’s a BIG deal! 🚀

     

    Screenshot_1.png

     

    Show Less
  • forum

    App Development

    Selecting a view in Qlik Maps by Default, rather than using Geoanalytics

    What exists today — in GeoOperations (Travel Areas)Qlik Cloud's GeoOperations already supports transportation mode types for calculating Travel Areas.... Show More

    What exists today — in GeoOperations (Travel Areas)

    Qlik Cloud's GeoOperations already supports transportation mode types for calculating Travel Areas. These modes include: Bird (a flying bird at 10 m/s), Car (road restrictions for cars), Bike (bike road restrictions), Pedestrian (pedestrian road restrictions), and Truck (truck road restrictions). Qlik Help

    However, this capability only exists as a back-end data operation — it's used to compute a geographic polygon (a travel area zone) based on cost (time or distance). It is not a front-end map visualization property that a developer or end-user can set on a map chart as a "view type."


    The Gap — What's Missing

    When you build a Map chart in Qlik Cloud Analytics, maps enable you to view data geographically using multiple layers. You can limit the pan of a map to a specific view and scope, such as a region of interest. But there is no current setting that lets a developer pre-configure — or allows an end user to switch — the transportation perspective/view type of the map at the visualization level. Qlik Help

    In other words:

    • The "Bird" perspective (top-down satellite/aerial view) is effectively the implicit default for all map charts.
    • There is no UI toggle or property panel option to set the default view mode (Bird, Car, Pedestrian, etc.) on the map chart itself.
    • End users cannot switch the view context dynamically within a published dashboard.

    What Your Feature Request Should Cover

    Here's the structured context you can use to write the request:

    Problem Statement:
    Qlik Cloud map charts only support a single implicit view type (bird's-eye / top-down). For use cases like logistics, field operations, urban planning, or accessibility analysis, users need the map to visually reflect the perspective relevant to their workflow — car routing view, pedestrian walkability, etc.

    Requested Feature:
    A "Default View Type" property in the Map chart property panel, allowing developers to set one of the following as the default rendering perspective for a map visualization:

    • 🐦 Bird — top-down aerial (current implicit default)
    • 🚗 Car — road-network focused view
    • 🚶 Pedestrian — walkway/footpath focused
    • 🚲 Bike — cycling path focused
    • 🚛 Truck — freight road network view

    Additionally, optionally expose a runtime toggle so end users can switch the view type within a published app, without needing to go into edit mode.

    Why It Matters:

    • Aligns the map visualization with the transportation mode already used in GeoOperations Travel Area calculations.
    • Improves analytical context — a logistics analyst using a Truck travel area should see a truck-perspective map, not a bird's-eye view.
    • Reduces cognitive load and makes dashboards more purpose-fit.
    Show Less
  • forum

    Data Movement & Streaming

    How to exclude the subtotal line when all values are 0?

    Hi everybody,I've configured a straight table in a Qlik Cloud app.I have activated the new "Subtotals" option for 3 dimensions.For all dimensions, I h... Show More

    Hi everybody,

    I've configured a straight table in a Qlik Cloud app.
    I have activated the new "Subtotals" option for 3 dimensions.
    For all dimensions, I have excluded null values.

    All null values are no longer displayed, which is what I wanted, but subtotals with a value of 0 are still being listed.

    Does anyone have an idea how to get these excluded as well in the straight table?

    Show Less
  • forum

    Water Cooler

    Data Voyagers: Qlik Predict ML Models from Any Source

    I found this video by @igoralcantara  about MCP and Qlik Predict really interesting and wanted to share it here.It shows how MCP can connect different... Show More

    I found this video by @igoralcantara  about MCP and Qlik Predict really interesting and wanted to share it here.

    It shows how MCP can connect different data sources to Qlik Predict and use them both for predictions and as outputs after deployment.

    I found the practical example of how MCP, LLMs, and Qlik Predict can work together really helpful.

    Sharing it here if you're interested in the topic!

    Link: https://www.youtube.com/watch?v=roheA8YfDKg

     

    Show Less
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image