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: 
  • 278,227 members
  • 11,375 online
  • 2,051,550 posts
  • 155,085 Solutions
Announcements
Meet Qlik's New CEO. The Future Is Bright — Here's What to Expect

Welcome to Qlik Community

Recent Discussions

  • forum

    Water Cooler

    What Customers and Partners Can Expect from new Qlik CEO Saugata Saha

    A clear vision, candid communication, strong execution, and a focus on creating value together.  In his first interview as Qlik CEO, Saugata Saha shar... Show More

    A clear vision, candid communication, strong execution, and a focus on creating value together. 

    In his first interview as Qlik CEO, Saugata Saha shares what customers and partners can expect from his leadership and why collaboration across the Qlik ecosystem will be central to the opportunity ahead. 

    In the full conversation, Saugata also discusses: 

    • What drew him to Qlik  
    • His perspective on data and AI  
    • The importance of Qlik’s customers and partner ecosystem  
    • His priorities for the first 90–100 days  
    • Some of his interests outside work  

    Watch the full conversation:

     

    As Saugata shares, the future is bright! To help you look ahead in style, we're sending Qlik sunglasses to our Qlik Community members 😎 

    Please join us in welcoming Saugata to Qlik and the Qlik Community. Share your reactions and thoughts with Saugata below, and we will send you a pair of Qlik shades (while supplies last). 

     

     

    Show Less
  • forum

    App Development

    Current year vs previous year cumulative sales

    Hi all, good evening, I need to compare the cumulative sales between a year and the year before. This for many years stored in my database. The sales ... Show More

    Hi all, good evening,

    I need to compare the cumulative sales between a year and the year before. This for many years stored in my database.

    The sales had already been normalized by the month of each year.

    This is the expression I created to generate the information for each year:

    Aggr(RangeSum(Above(Sum(QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])

    YEAR/MONTH SALES YEAR QTY
    (other year months) ... ...
    2026/01 2024 1
    2026/02 2024 10
    2026/03 2024 25
    2026/04 2024 8
    2026/05 2024 14
    ... ... ...
    2026/01 2025 0
    2026/02 2025 3
    2026/03 2025 12
    2026/04 2025 11
    2026/05 2025 7
    ... ... ...
    2026/01 2026 4
    2026/02 2026 5
    2026/03 2026 8
    2026/04 2026 12
    2026/05 2026 20

     

    And this is the generated graphic:

    andrelfg_0-1786559771694.png

     

    What I need is to created a new graphic that shows, for each year, the % growth between that year vs its last year, using the same rule (acumulated sales for each month).

    I have already tried many solutions here in the topics, but I couldn't get the right result.

    For exemple: Aggr(RangeSum(Above(Sum(QTY) / Sum({<[SALES YEAR] = {"$(=Only([SALES YEAR])-1)"}>}QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])

    Thanks in advance for any help.

     

    Show Less
  • forum

    Water Cooler

    High Five - August 2026, Gwen Stamp

      Featured Member · August 2026 Meet Gwen Stamp, our August Featured Member   From the moment you dive into the Qlik Community this month, Gwen Stam... Show More
     
    Featured Member · August 2026

    Meet Gwen Stamp, our August Featured Member

    Screenshot 2026-08-03 152058.png

     

    From the moment you dive into the Qlik Community this month, Gwen Stamp's presence is hard to miss! An active member of the Women Who Qlik group, Gwen has spent more than 15 years leaving her mark on the Qlik ecosystem: showing up, sharing what she's learned, and helping others do the same. We're thrilled to name her our Featured Member for August 2026!

    Gwen's relationship with Qlik goes back over 15 years, and she's seen the platform from nearly every angle along the way, working as a developer, consultant, platform owner, customer, educator, and community advocate. Today, she leads a Data & Analytics Center of Excellence within financial services, focusing on analytics strategy, governance, and enablement, helping people get more value from their data. She's also an adjunct professor teaching Business Statistics, driven by a passion for data literacy and helping others build the confidence to make data-informed decisions.

    “We learn more when we learn from each other.”

    — Gwen Stamp

    Community has always been central to Gwen's Qlik journey. She notes that no matter how long someone has worked with Qlik, there's always another perspective, another problem solved, or a better approach waiting to be discovered. The Community has been a steady resource throughout her own journey, whether she's troubleshooting an issue, exploring a new capability, or keeping up with how the platform evolves. It's also given her a way to give back, sharing the successes and lessons she's picked up along the way. But for Gwen, it ultimately comes down to the people, some of the professional relationships and friendships she's built through the Community have lasted for years.

    Outside of work, Gwen loves traveling and trying new things with her family. She's almost always learning something new or working on a creative project, and she enjoys roasting her own coffee. True to form, her curiosity doesn't stay contained to the day job, as she puts it, data and technology tend to sneak into her hobbies too, always wondering how things work and how they could work better.

     

    Thank you, Gwen!

    Thank you for your years of contributions and engagement in the Qlik Community. Please join us in celebrating Gwen Stamp as our August 2026 Featured Member — leave a comment below!

    @GSTAMP @SarahUrbiss @Jamie_Gregory 

    Show Less
  • forum

    Qlik Replicate

    Optimization on Change data capture (200 million records or so in 5-6 transactio...

    The amount of change data that is being captured from source is very large. 200 million records or so for about 20 tables. And this is causing a laten... Show More

    The amount of change data that is being captured from source is very large. 200 million records or so for about 20 tables. And this is causing a latency of about 4 hrs or 5 hrs to commit this to target. Is there any way we can speed up this CDC commits? I am attaching a photo of the current monitor screen and my change capture settings. Please let me know of any tuning that can be performed. Source is SQL server (MS-CDC) and target is Snowflake.

    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

    QlikView

    QlikView Server out of duty, license not reflecting

    Hello, I'm running QlikView server and publisher on a windows VMOur license is renewed successfully as we confirmed with our contact in Qlik customer ... Show More

    Hello,

    I'm running QlikView server and publisher on a windows VM
    Our license is renewed successfully as we confirmed with our contact in Qlik customer service management.
    However i'm unable to apply the license, i have all the needed info (serial number, control number, LEF, owner information)
    LEF should be correct as it was shared by our contact in Qlik.
    Also tried to generate it from here with same results https://lef1.qliktech.com/manuallef/default.aspx

    Tried restarting the QlikView windows services many times and applying the license again with no success.
    worth noting the license for publisher is working fine with no issues.

    Thanks in advance for any help or advise

    Show Less
  • forum

    Make Your Data Work for AI

    What's Next for Your AI Journey?

    We hope you've enjoyed our Make Your Data Work for AI discussions! Every organization is at a different stage of its AI journey.   What's the next mil... Show More

    We hope you've enjoyed our Make Your Data Work for AI discussions! Every organization is at a different stage of its AI journey.

     

    What's the next milestone you're working toward? It could be improving data quality, expanding adoption of agentic capabilities, demonstrating business value, strengthening governance, or launching a new use case.

     

    If you haven't already, watch the Make Your Data Work for AI story here!

     

    Tell us what's next for your team in the comments. Share your response for a chance to win a pair of sneakers. Winner announced August 14.

      

    calebjlee_0-1785848586542.jpeg

     

     

     

    Show Less
  • forum

    Move to Qlik Cloud Analytics

    Qlik Cloud Custom Theme - Tab Container Selected/Unselected Tab Background Color

    I'm not sure if this is the correct forum, but I'll give it shot.  We are moving to Qlik Cloud from QlikView.  I am attempting to create a custom them... Show More

    I'm not sure if this is the correct forum, but I'll give it shot.  We are moving to Qlik Cloud from QlikView.  I am attempting to create a custom theme, which does utilize a CSS file.  I have been able to figure out the few things we need in a theme, but have stumbled on customizing a tab container.  I want to change the tab background for the selected and unselected tabs, but this code does not work.  This is my first exposure to CSS/JSON so I don't know what is keeping it from working.  Any suggestions would be appreciated.

    My JSON code:

    {
    "_inherit": true,
    "_id": "custom-image-theme",
    "name": "Custom Background Theme",
    "description": "App theme featuring a global sheet background image.",
    "type": "theme",
    "version": "1.0.0",
    "customStyles": [
    {
    "cssRef": "theme.css",
    "classRef": "custom-theme"
    }
    ],
    "_variables": {
    "@objectBackground": "#FFFFFF"
    },
    "backgroundColor": "@objectBackground",
    "object": {
    "backgroundColor": "@objectBackground"
    }
    }

    My CSS code:

    /* 1. Global font configuration
    .qv-object * {
    font-family: 'Helvetica Neue', Arial, sans-serif !important;
    }*/

    /* 2. Customizing sheet backgrounds and structures */
    .qvt-sheet, .qv-panel-sheet {
    background-image: url("QlikSense_SheetBackground.jpg") !important;
    background-size: 100% 100% !important;
    background-repeat: no-repeat;
    background-position: top left;
    }

    /* 3. Main header and top-bar formatting */
    #sheet-title.sheet-grid:after {
    content: "";
    display: block;
    height: 30px; /* Adjust height to fit your logo */
    width: 200px; /* Adjust width to fit your logo */
    background-image: url('SMClogo285blue.png');
    background-repeat: no-repeat;
    background-size: contain;
    background-position: left center;
    position: absolute;
    left: 20px; /* Adjust to move logo left or right */
    top: 50%;
    transform: translateY(-50%);
    }

    /* 4. Right-align the sheet title text */
    .qv-object-header, .sheet-title-text {
    text-align: right !important;
    justify-content: flex-end !important;
    font-size: 30px !important;
    font-weight: bold !important;
    color: #0071CE !important;
    }

    .qv-object .qv-object-title {
    background-color: #FFFFFF !important;
    padding: 8px 12px !important;
    }

    /* 5. Target the title text globally across standard visualization cards */
    .qv-object-title .qv-object-title-text {
    color: #000000 !important;
    font-family: 'Helvetica Neue', Arial, sans-serif !important;
    font-size: 16px !important;
    font-weight: normal !important;
    }

    /* 6. Styling for the standard, unselected container tabs */
    .qv-object-nav .tab-container .tab {
    background-color: #b0afae !important;
    color: #333333 !important;
    }

    /* Styling for the ACTIVE / SELECTED tab background color */
    .qs-container .qsc-tab.active {
    background-color: #0076ce !important; /* Set your hex color here */
    color: #ffffff !important; /* Text color for active tab */
    border-bottom: 2px solid #005699; /* Optional bottom indicator line */
    }

     

    Thanks in advance!

    Show Less
  • forum

    QlikView

    Scaling QlikView Apps on Legacy Hardware: Latency vs. Capacity Bottlenecks

    Hi everyone, I’ve been a long-time advocate for QlikView, and even with the push toward newer platforms, I still find the Associative Engine in cla... Show More

    Hi everyone,

    I’ve been a long-time advocate for QlikView, and even with the push toward newer platforms, I still find the Associative Engine in classic QlikView to be incredibly snappy for specific types of complex, local data discovery. I’m currently working on a project where I’m trying to optimize a fairly large .qvw for a small non-profit that is running their infrastructure on some older, repurposed enterprise hardware.

    As someone who genuinely enjoys the challenge of "hardware recycling"—the idea of squeezing every bit of utility out of older machines rather than just buying into the latest cloud subscription—I’ve hit a bit of a performance wall that I'm hoping the veterans here can help me navigate.

    The specific point I’m struggling with is the calculation time for objects using heavy Set Analysis and nested Aggr() functions. On my development machine, everything is fluid, but on the production host—an older workstation we’ve beefed up—the lag is becoming noticeable to the end users.

    To give you some context on the environment, the server is running on a legacy DDR3 architecture. I’ve recently maxed out the board using PC & Server memory I had in my spare parts bin: specifically 8GB DDR3 1333MHz (PC3-10600) modules. I’ve managed to get the total capacity up to 64GB, which theoretically should be plenty of room for our 2GB (compressed) data model once it expands in-memory.

    My personal insight from years of tinkering is that QlikView is almost entirely dependent on RAM throughput. However, I’m starting to wonder if the lower frequency of the PC3-10600 (1333MHz) is creating a latency bottleneck that no amount of capacity can fix. I’m seeing high CPU wait times during selections, even though the RAM isn't being fully utilized and the CPU usage isn't hitting 100%.

    Specifically, I’m curious if anyone has experience deploying QlikView apps on older 1333MHz RAM. Does the Associative Engine suffer significantly from the lower bus speed of DDR3 compared to DDR4, or should I be looking more closely at my data model’s "Density" and "Cardinality" in the Document Analyzer? I’m trying to determine if it’s worth hunting down slightly faster RAM for this old motherboard, or if I just need to get more aggressive with script-level optimizations to reduce the reliance on complex UI expressions.

    Has anyone else noticed a "stutter" in selection response times specifically tied to memory clock speeds rather than just raw volume?

    Looking forward to hearing your thoughts on whether I should keep tuning the app or if the hardware has finally met its match.

     
    Show Less
  • forum

    Management & Governance

    StdServer: Writing dump and continue execution

    Hi -I'm getting the following error message in the logs:WARN System.Engine.Engine StdServer: Writing dump and continue execution.I can't find wher... Show More

    Hi -

    I'm getting the following error message in the logs:

    WARN   System.Engine.Engine   StdServer: Writing dump and continue execution.

    I can't find where Qlik is creating the dump files.

    Regards,

    Show Less
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image

Customer Story

Data Drives the Reconstruction of an Entire State

Data Restores Confidence: How SEFAZ-RS Used Qlik to Support the Rebuilding of a State.

Customer Story

Qlik platform helps structure an analytics ecosystem to support diagnostic medicine and healthcare.

AFIP revolutionizes management, optimizes resource allocation and strengthens data-driven culture

Customer Story

Hapag-Lloyd Enables Smart Decisions With Qlik

Global container shipping giant delivers data transparency to enable confident decision-making and operational efficiency.

Customer Story

Students See Data Come to Life With Qlik Academic Program

Qlik turns raw data into valuable learning experiences, empowering both students and faculty at TTUHSC.

Customer Story

MillerKnoll Unifies Data with Qlik Talend

MillerKnoll partnered with Qlik Talend® data solutions to unify data across its diverse systems, accelerating critical processes and nearly eliminating data integration issues organization-wide.

Customer Story

Radiall Embraces the Cloud and Improves Operational Efficiency

Migration to Qlik Cloud Analytics optimizes analytics applications within months.

Customer Story

French Ministry of Armed Forces Develops a Data-Centric Culture

With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.

Your Place, Your People

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

AI Reality Tour

Zurich

Join data and AI leaders in Zurich on June 10, 2026 to learn how to scale AI and drive real enterprise impact.