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: 
  • 283,028 members
  • 5,383 online
  • 2,036,022 posts
  • 155,183 Solutions
Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!

Welcome to Qlik Community

Recent Discussions

  • forum

    Installing and Upgrading

    PostgreSQL 14 reaches EOL in November 2026

    Hello, I have a question about the upcoming End-of-Life of PostgreSQL 14 that has been announced last week (see https://www.postgresql.org/docs/releas... Show More

    Hello,

    I have a question about the upcoming End-of-Life of PostgreSQL 14 that has been announced last week (see https://www.postgresql.org/docs/release/14.24/)

    Does anyone know if there will be an update that includes a newer DB version before we reach EOL for PostgreSQL 14 on November 12, 2026? As far as I'm aware, the most recent version of QlikSense still comes with PostgreSQL 14.22.2 included.

    If not, do you have any recommendations on how to proceed? We do not want to risk running an outdated system database that cannot be patched.

    If possible, we would also prefer not to migrate to a separate PostgreSQL installation as discussed e.g. in this thread: https://community.qlik.com/t5/Management-Governance/Moving-a-PostgreSQL-version-14-toward-version-17/m-p/2541205#M32534.

    If there are no other options, I would be very interested in hearing from someone who has successfully moved to a separate DB installation and who is willing to share their experience.

    Thanks!

    Show Less
  • forum

    Qlik Automate

    Unknow Service when accessing api/data-governance/trust-scores/results/data-sets...

    I'm trying to setup a block to retrieve trust score information from datasets in my tenant. According to documentation I need to use a Qlik Cloud Serv... Show More

    I'm trying to setup a block to retrieve trust score information from datasets in my tenant. According to documentation I need to use a Qlik Cloud Services - Raw API Request and point to  

    api/data-governance/trust-scores/results/data-sets/actions/filter

    After running the automation this is the response

    { "response": { "status": 404, "body": { "error": "Unknown Service (url: https://mytenantid.us.qlikcloud.com/api/data-governance/trust-scores/results/data-sets/actions/filter)" } }, "external error": false }

    I've tried using curl to call this endpoint externally and it works fine. 

     

    Show Less
  • forum

    Qlik Predict

    Qlik Predict – Unable to Configure 12-Month Forecast for 2025

    I am working on a Qlik Predict forecasting use case using monthly historical data from 2021 to 2024.The dataset contains:DATE (For Each Month of the Y... Show More

    I am working on a Qlik Predict forecasting use case using monthly historical data from 2021 to 2024.

    The dataset contains:

    DATE (For Each Month of the Year), PRODUCT_ID,  Customer_NAME,  Amount_USD

    Our requirement is to use the historical monthly Amount_USD values to predict January–December 2025 for each Customer_NAME , Product combination.

    Currently, while configuring the ML experiment, the Desired Forecast Window Size allows only 1, whereas our requirement is 12.

    Additionally, the data is loaded from a database, and during validation we found that some values/counts in Qlik are not matching the source database.

    Could you please provide detailed steps for:

    • Preparing the historical dataset
    • Configuring the date index and forecast groups
    • Configuring the target as Amount_USD
    • Setting up a 12-month forecast window
    • Training and deploying the model
    • Preparing the 2025 apply/prediction dataset
    • Generating monthly predictions from Jan–Dec 2025
    • Troubleshooting why the maximum forecast window is currently restricted to 1
    • Validating the difference between Qlik data and database data

    This is my first use case in Qlik Predict, so a step-by-step implementation guide would be very helpful.

    Show Less
  • forum

    Visualization and Usability

    Trellis container can't hide the dimension has null value

    Hi guys i can't upload the image here, currently i faced an issue that trellis container can't hide dimension with null value. eg: i have 10 categorie... Show More

    Hi guys i can't upload the image here, currently i faced an issue that trellis container can't hide dimension with null value. eg: i have 10 categories, and 3 of them has value, so only want to display 3, right now it displays all 10 categories. Even i do follow Trellis container | Qlik Sense on Windows Help instruction, do calculated column, turn off include null in dimension, turn off show all possible dimensions, nothing can help me archive that. Any answer for this issue?

    Show Less
  • forum

    Management & Governance

    The Brotli vulnerability: Qlik Sense node.js update

    Qlik Sense: standalone Node.js update following the October 2026 security releaseFollowing the Node.js security release of October 21, 2026, including... Show More

    Qlik Sense: standalone Node.js update following the October 2026 security release

    Following the Node.js security release of October 21, 2026, including the Brotli vulnerability CVE-2026-111497, I tested updating the Node.js binary bundled with Qlik Sense independently of a Qlik patch.

    The test passed on Qlik Sense Enterprise on Windows May 2026 Patch 7, updating Node.js 24.18.1 to 24.22.1 This is a result from one environment, not a compatibility guarantee for every deployment.

    This method is not validated by Qlik. Qlik's documented approach is to update bundled Node.js through a Qlik Sense upgrade. Test in development first, with a maintenance window and a recoverable full backup.

    Check your current bundled Node.js version

    Run in PowerShell:

    & "$env:ProgramFiles\Qlik\Sense\ServiceDispatcher\Node\node.exe" --version

    Using the full path checks Qlik's copy rather than another Node.js installation on the PATH.

    Run the scripts

    1. Extract the attached scripts into one folder.
    2. Download the [official Windows x64 node.exe](https://nodejs.org/dist/v24.22.1/win-x64/node.exe).
    3. Edit `NodeUpdate.config.psd1`: set the binary, backup and log paths, and the official SHA256 for "win-x64/node.exe" from SHASUMS256.txt.
    4. In Windows PowerShell 5.1 as administrator, run:

    .\01_Backup_Node.ps1


    Continue only after BACKUP VERIFIED.
    .\02_Update_Node.ps1

    Leave the Service Dispatcher running before Update: the script handles stopping and restarting it. Relative paths are resolved against the configuration folder; execution is local to each machine.

    Test Hub, QMC, application access, exports, reloads and your usual connectors, and check Qlik logs. These are recommended checks, not a list of checks confirmed by the test above.

    For rollback, set `RestoreBackupDirectory` to the exact original backup folder and run:


    .\03_Restore_Node.ps1

    The scripts target the main Service Dispatcher on Node.js 24 only. They do not update EAPowerTools, Package Cache or npm dependencies. A binary backup is not a full site backup, and automatic rollback is not guaranteed. Recheck the installed version after subsequent Qlik maintenance.

    References:

    • Qlik Support, article updated August 14, 2024, linked above
    • The Node.js Project, October 21, 2026 security bulletin, linked above
    • Node.js 24.22.1 release notes, October 21, 2026: https://nodejs.org/en/blog/release/v24.22.1
    Show Less
  • forum

    Qlik Replicate

    MS-CDC source. CDC does not resume after reloading a recreated table, resulting...

    Hello Qlik Community,We would like discuss about a suspected issue in Qlik Replicate. After a source table is recreated and explicitly reloaded, Full ... Show More

    Hello Qlik Community,

    We would like discuss about a suspected issue in Qlik Replicate. After a source table is recreated and explicitly reloaded, Full Load completes successfully, but subsequent changes to that table are not captured. CDC resumes only after an additional Stop → Resume.

    Environment

    • Qlik Replicate: 2026.5.0.423.  Sourse and Target use same  Microsoft SQL Server 2019, Microsoft SQL Server (MS-CDC) 

    • Task  Full Load + Apply Changes + Store Changes enabled. DDL action all ignored 

      The test uses two tables:

      • dbo.VersionTest — the table being recreated.

      • dbo.CdcHeartbeat — an unaffected control table. A stored procedure continuously generates committed updates to this table so that the task’s LSN position continues to advance.

      •  

      The heartbeat procedure remains running throughout the experiment, including periods when the Replicate task is stopped.

      VersionTest has a primary key and simple text/numeric columns, without LOB or rowversion columns. We reproduced this behavior in a laboratory while investigating replication recovery after BAS application table restructuring.

      Steps to reproduce

      1. Start the Replicate task and confirm that CDC works for both tables. Start the procedure generating continuous committed updates to CdcHeartbeat.

      2. While the Replicate task is running, drop dbo.VersionTest.

      3. Create a new table named dbo.VersionTestNG.

      4. Rename dbo.VersionTestNG to dbo.VersionTest. The table now has the original name but a different SQL Server object_id.

      5. Manually enable MS-CDC for the new dbo.VersionTest. Verify that changes to this table appear in the source cdc.dbo_VersionTest_CT.

      6. Stop the Replicate task and wait until it is Stopped. Mark VersionTest for Reload while the task is stopped, then select Resume Processing.

      7. Wait for Full Load to complete successfully. Execute and commit an UPDATE setting the test value to PROBE_A. This event appears in the source CDC table but does not appear in the target VersionTest__ct. Meanwhile, heartbeat changes continue reaching the target and advance the saved task position beyond the LSN of PROBE_A.

      8. Perform another Stop → Resume Processing, without an additional Reload.

      9. Execute and commit another UPDATE setting the value to PROBE_B. This change is captured successfully. The target VersionTest__ct contains the transition PROBE_A → PROBE_B, but the previously missed event that changed the value to PROBE_A is not recovered.

      Expected behavior

      After an explicit Reload refreshes the recreated table’s metadata, CDC should resume for that table.

      If this DDL scenario requires additional recovery steps, we need a documented, supported procedure that prevents missed changes and clearly identifies when capture remains inactive.

      Observed mechanism

      At the first Resume, the capture component detects the missing old object and removes its registration. Reload subsequently refreshes the metadata for the new object, but the new CT is not added to the running capture component’s polling list.

      The additional task restart establishes the correct registration and restores polling.

      The task continues processing other tables and advancing its LSN while capture of VersionTest remains inactive. This creates a gap in the change history, which is critical for downstream historical processing.

      An additional Stop → Resume restores future CDC processing but does not recover the missed interval. The current workaround therefore requires keeping writes to the recreated tables paused until Reload, the additional restart, and CDC verification have completed.


      what is best
      supported recovery procedure after replacing a source table with a new object under the same name?


    Show Less
  • forum

    Management & Governance

    Qlik Sense patches regarding eMudhra CA issue (CVE-2026-111943, CVE-2026-91403, ...

    See e.g. https://www.heise.de/en/news/eMudhra-incident-compromises-eight-CA-certificates-11494689.htmlQlik Sense seems to use node.js and go. Thus, I ... Show More

    See e.g. https://www.heise.de/en/news/eMudhra-incident-compromises-eight-CA-certificates-11494689.html

    Qlik Sense seems to use node.js and go. Thus, I expect qlik needs to be patched, right?

    Please let us know which patches are necessary and their ETA if not yet released.

    Show Less
  • forum

    App Development

    Trellis container shows all dimension values (even excluded)

    Hi everybody! I'm struggling with the trellis container extension from the dashboard bundle. I've got a dimension populated with months (jan to dec) a... Show More

    Hi everybody!

     

    I'm struggling with the trellis container extension from the dashboard bundle. 

    I've got a dimension populated with months (jan to dec) and I've selected 3 of them.

    No matter what I try, the trellis container keeps showing me 12 charts, 3 of then with values and the rest of them with a message like this "Actual selections hasn't got any data for this chart" (sorry, my Qlik Sense is configured in spanish so thats' just a translation)

     

    What I expected to have is a three charts container, not a 12 charts container with eleven empty charts.

    Am I doing something wrong?

     

    I'm using the lastest Qlik Sense version (february 2020)

    Thanks in advance

     

     

    Show Less
  • forum

    Women Who Qlik

    Celebrate Ada Lovelace Day 2026 with Women who Qlik!

    Ada Lovelace Day celebrates the achievements of women in STEM and inspires the next generation of women in technology. This year, we’re celebrating b... Show More

    WomenWhoQlik_AdaLovelaceDay_1366x200.png

    Ada Lovelace Day celebrates the achievements of women in STEM and inspires the next generation of women in technology. This year, we’re celebrating by growing our Women Who Qlik community and connecting even more women and allies across Data, Analytics, and AI. 

    Know someone who would benefit from Women Who Qlik? Refer them!  Tag a colleague in the comments who you think would find this content valuable and would love to be part of the Women Who Qlik community. When they subscribe, both you and your colleague will be entered into a draw to win a Women Who Qlik varsity jacket. Two jackets will be drawn and awarded on October 30!  We will notify the winners via this Women Who Qlik community post. If your referral is not yet a member of Qlik Community, please ask them to join and subscribe before tagging them.  

    Whether you refer one person or several, every invitation helps us build a stronger, more connected community and create more opportunities for women and allies across the Qlik ecosystem.  Celebrate Ada Lovelace Day by helping another woman find her community.  Also, show your support by going to the Ada Lovelace Women Who Qlik post on social. 

    Thank you for being such an important part of Women Who Qlik. We appreciate your partnership and look forward to continuing to learn, connect, and grow together! 

    Who are you planning to refer to join the program? Tag them below! 

    Show Less
  • forum

    Management & Governance

    Open-source MCP server for Qlik Sense Enterprise on Windows (client-managed) — a...

    Years ago I wrote the QlikView Systems Monitor (ugly but one of the most downloaded apps of its era). This is the same itch, scratched with 2026 tools... Show More

    Years ago I wrote the QlikView Systems Monitor (ugly but one of the most downloaded apps of its era). This is the same itch, scratched with 2026 tools.

    Qlik Cloud has a native MCP endpoint for AI agents. Client-managed Qlik Sense on Windows has no official equivalent, so at Terenzi LLC we built one and open-sourced it under Apache-2.0. qseow-mcp exposes the QRS, Engine, and Proxy APIs as 44 agent tools across analyst, troubleshooting, developer, and admin personas. There is other community work in this space, and more of it is a good thing; our focus is the support and troubleshooting surface, full JWT-mode coverage, and a hard security posture.

    The part we care most about is the troubleshooting loop. When a number is wrong, an agent can walk KPI to object to sheet to app to script to source, evaluating the governed definition at every step. In our demo estate it traces a $50M reconciliation mismatch to a double-loaded batch and ties it back out in seconds of tool time.

    Two practical notes for anyone who tries it:

    1. Published-app caveat: the engine hides a published app's script and lineage from user identities (GetScript returns empty, GetLineage denies, even for RootAdmin under a user identity). The workaround is copy_app and trace the owned copy. This is documented platform behavior, not a bug in the server, and it will bite any agent integration you build yourself.

    2. The engine validates expressions but never proves pixels. A hypercube the engine accepts can still render a blank chart client-side (nebula.js default property blocks). The server ships a validate_sheet gate and all 12 supported chart types are render-verified against a real browser.

    Repo: https://github.com/rmterenzi/qseow-mcp · Install: npm i qseow-mcp

    Read-only by default, mutating tools gated at registration, credential redaction on every output path, certificate and JWT auth both covered. Independent project by Terenzi LLC (we are a Qlik partner; this is not a Qlik product). Issues and PRs welcome, especially reports from multi-node sites — everything so far is validated on single-node May 2026.

    Show Less
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image