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: 
  • 282,999 members
  • 25,086 online
  • 2,036,003 posts
  • 155,184 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

    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

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

    Qlik Replicate

    SQL MERGE and updates on primary keys

    Hello,I’ve configured a replication task that reads from a Log Stream and replicates data to a Snowflake target with Apply Changes Processing enabled,... Show More

    Hello,

    I’ve configured a replication task that reads from a Log Stream and replicates data to a Snowflake target with Apply Changes Processing enabled, meaning that changes are applied directly to the target tables in Snowflake. The source of the Log Stream is an Oracle database.

    Moreover, I’ve implemented a soft-delete logic in this task by adding a technical field defined as follows:

    CASE ifnull(operation_indicator('DELETE','UPDATE','INSERT'),'null')
    WHEN 'null' THEN 'INSERT'
    ELSE operation_indicator('DELETE','UPDATE','INSERT') END

    Occasionally, operations are performed on the source that modify primary key fields. I’d like to understand if it’s possible to transform the UPDATE into a DELETE of the record with the previous key, followed by an INSERT of the record with the new key.

    As I understand it, the “DELETE and INSERT when updating a primary key column” option available in Apply Changes Processing cannot be used to achieve this because for the Snowflake target endpoint this option applies only to Change Tables, not to the actual target tables.

    However, I noticed that there is also an “Apply changes using SQL MERGE” option. If I understand correctly, this option works as follows: “for a standard UPDATE, Qlik Replicate generates a MERGE INTO statement. However, if the UPDATE modifies primary key values, Qlik Replicate will not use MERGE INTO; instead, it will apply the change as a DELETE + INSERT pair for that row”.

    This behavior is described in the following article:
    https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-Implementing-UPSERT-and-MERGE-modes-by-applying-a/ta-p/1780009.

    If this is how SQL MERGE operates, would implementing a soft-delete logic mean that, when a primary key changes, the target table would contain the record with the old primary key marked as deleted (soft-deleted) and the record with the new primary key inserted as a new record?

    Thank you in advance for your support.

    Best regards

    Show Less
  • forum

    Qlik Automate

    Automation Settings - Unauthorized. Account user is owner of automations.

    Hi, we have several automations under development, each of which were fine last week.  Today, we wanted to change the name of one of them, so attempte... Show More

    Hi, we have several automations under development, each of which were fine last week.  Today, we wanted to change the name of one of them, so attempted to open the automation settings, and it raised the alert "Unauthorized: You do not have access to this automation. Contact your system administrator for more information."
    We have tried opening these settings on other automations, and get exactly the same.  Edits to the automation blocks are working fine, so why are they being shown as unauthorized for the settings?

    Note:  I am the administrator and, as far as I can see, the account attempting to open the automation settings is the owner of the automation, and no roles or permissions have been changed between last week and this.

    Thanks.

    Show Less
  • forum

    App Development

    Versiona CuboPlus: your Qlik load script history in your GitLab or GitHub (free ...

    Hi everyone!If you develop in Qlik Sense, you know the scene: the load script changed, the number on the dashboard changed with it, and nobody knows w... Show More

    Hi everyone!

    If you develop in Qlik Sense, you know the scene: the load script changed, the number on the dashboard changed with it, and nobody knows who changed it, when or why. To solve this, we built Versiona CuboPlus, a free extension for Chrome and Edge that keeps the history of your load script in your company's Git repository.

    Intro video: 

    How it works

    • You open the app in Qlik, and a mascot tells you when the script has changed and has no version yet.
    • You write what changed and why, and the version becomes a commit in GitLab or GitHub, with you as the author.
    • You can see the line-by-line differences before saving, browse the history and restore a previous version.
    • Optional: the expressions of master measures and dimensions and the app variables go along, in a file next to the script (read-only).

    Where it works

    • Qlik Sense Enterprise on Windows and Qlik Cloud.
    • GitLab, including self-managed, and GitHub.
    • In English, Portuguese and Spanish.

    Security

    • The script goes from your browser straight to Qlik and to the Git you configured: it goes through no other server, and there is no telemetry.
    • The extension does not write to public repositories: the repository must be private.
    • The Git token is encrypted in the browser, and you can require the Windows Hello PIN or biometrics to use it.
    • IT can distribute the configuration by policy (GPO).

    For client-managed, there is also an optional nightly routine in PowerShell for GitLab, open source, that stores overnight whatever changed without going through the extension.

    Download and more

    It is free. If you try it, tell us here what you think, and leave a review on the Chrome Web Store.

    Suggestions and bug reports are very welcome.

    Follow CuboPlus on Instagram: @cubo.plus

    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

    Brasil

    Versiona CuboPlus: o histórico do script de carga do Qlik no seu GitLab ou GitHu...

    Olá, pessoal!Quem desenvolve no Qlik Sense conhece a cena: o script de carga mudou, o número do painel mudou junto, e ninguém sabe quem alterou, quand... Show More

    Olá, pessoal!

    Quem desenvolve no Qlik Sense conhece a cena: o script de carga mudou, o número do painel mudou junto, e ninguém sabe quem alterou, quando nem por quê. Para resolver isso, criamos o Versiona CuboPlus, uma extensão gratuita para Chrome e Edge que guarda o histórico do script de carga no repositório Git da sua empresa.

    Vídeo de apresentação:

    Como funciona

    • Você abre o app no Qlik, e um mascote avisa quando o script mudou e ainda não tem versão.
    • Você escreve o que mudou e por quê, e a versão vira um commit no GitLab ou no GitHub, com o seu nome como autor.
    • Dá para ver as diferenças linha a linha antes de salvar, consultar o histórico e restaurar uma versão anterior.
    • Opcional: as expressões das medidas e dimensões mestres e as variáveis vão junto, num arquivo ao lado do script (só leitura).

    Onde funciona

    Segurança

    • O script vai do seu navegador direto para o Qlik e para o Git que você configurou: não passa por nenhum servidor diferente do que configurou, e não há telemetria.
    • A extensão não grava em repositório público: o repositório precisa ser privado.
    • O token do Git fica criptografado no navegador, e dá para exigir o PIN ou a biometria do Windows Hello para usá-lo.
    • O TI pode distribuir a configuração por política (GPO).

    Para quem usa client-managed, há também uma rotina noturna opcional em PowerShell para GitLab, com o código aberto, que guarda de madrugada o que mudou sem passar pela extensão.

    Onde baixar e sobre

    É gratuito. Se testarem, contem aqui o que acharam e deixem uma avaliação na Chrome Web Store.

    Sugestões e relatos de problema são muito bem-vindos.

    Sigam a CuboPlus no Instagram: @cubo.plus

    Show Less
  • forum

    Management & Governance

    QlikSense Node JS Vulnerability

    Hello Qlik Community,I'm reaching out for help with some vulnerability issues identified by our Infosec team using the Qualys tool. We're currently us... Show More

    Hello Qlik Community,

    I'm reaching out for help with some vulnerability issues identified by our Infosec team using the Qualys tool. We're currently using QlikSense May 2024 Patch 21, and the issues are related to the Node JS version used by Qlik to build its application.

    Node JS Version Issues

    The QlikSense version we're using relies on Node JS 1.7.8, which has numerous vulnerabilities and has reached its end of life, as stated in the article. One specific issue is related to Angular JS, but our team has also identified around 80 security/vulnerability open points for other dependencies like Koa, body-parser, Braces and many more, out of which some of them have received fixes for the issues.

    Request for Information

    My assumption is that these issues are all bundled together and are a problem with the NodeJs version being used and that they might be resolved if Qlik upgrades the Node JS version used in QlikSense. I'd like to know if Qlik has already addressed these issues in a recent version of QlikSense on Windows or if they plan to fix them in an upcoming patch.

    Critical and High Issues

    The vulnerability list shared with me contains many Critical (6), High (30), Medium (34) & Low (10) priority issues I'd appreciate any guidance on how to proceed with resolving these issues.

    If anyone has information on this topic or knows what steps I can take next, please let me know.

    Thank you in advance for your help!

    Best regards, Charvick

    Show Less
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image