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,893 members
  • 12,423 online
  • 2,051,866 posts
  • 155,100 Solutions
Announcements
Meet Qlik's New CEO. The Future Is Bright — Here's What to Expect

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Which approach has better performance

    Hellogot the following requirement:the user has to select one fiscal year Current fiscal year is 2026if the user selects 2026 or abovethen the chart h... Show More

    Hello
    got the following requirement:
    the user has to select one fiscal year 
    Current fiscal year is 2026
    if the user selects 2026 or above
    then the chart has to display Budget Amount
    but is the user selects any fiscal year before 2026 then chart should display Actual Amounts
    I wrote the below expression:

    sum
        (
            {
                <scenario={actual},fiscal_year
    *={"<2026"}>
                +
               <scenario={budget},fiscal_year*={">=2026"}>

           }
    amount)
    but some suggest that I write the following:
    sum({<scenario={actual},fiscal_year*={"<2026"}>}amount)
    +
    sum({<scenario={budget},fiscal_year*={">=2026"}>}amount)

    which approach has better performance

    Show Less
  • forum

    Visualization and Usability

    Sheet Actions do not clear field selections when navigating using built-in Previ...

    Hi Team,   We have a Qlik Cloud application with two sheets:   1. Cloud Dashboard 2. Software Dashboard   Each sheet has its own FY selection field:  ... Show More
    Hi Team,
     
    We have a Qlik Cloud application with two sheets:
     
    1. Cloud Dashboard
    2. Software Dashboard
     
    Each sheet has its own FY selection field:
     
    Cloud:
    FYSelect
     
    Software:
    SoftwareFYSelect
     
    We configured sheet actions as follows:
     
    Cloud sheet:
    1. Clear selections in field -> SoftwareFYSelect
    2. Select FYSelect = Max(FYSelect)
     
    Software sheet:
    1. Clear selections in field -> FYSelect
    2. Select SoftwareFYSelect = Max(SoftwareFYSelect)
     
    When opening each sheet directly, the behavior works correctly.
     
    However, when users navigate between sheets using the built-in Previous (<) and Next (>) sheet navigation arrows, the selection from the previous sheet remains.
     
    Example:
     
    Software sheet:
    SoftwareFYSelect = 2025
     
    Navigate to Cloud sheet using built-in Previous arrow:
     
    Expected:
    FYSelect = 2025
    SoftwareFYSelect cleared
     
    Actual:
    FYSelect = 2025
    SoftwareFYSelect = 2025
     
    As a result, selections from both dashboards remain visible.
     
    Questions:
     
    1. Is this expected behavior in Qlik Cloud?
    2. Are sheet actions executed when navigating via the built-in sheet arrows?
    3. Is there a recommended approach for setting sheet-specific default selections when using built-in navigation?
     
    Thanks in advance.

    Show Less
  • forum

    Integration, Extension & APIs

    [Video] Qlik MCP Server is Here: Enable & Configure it with Claude

    Hi Qlik Community,The new Model Context Protocol (MCP) Server is now available in Qlik Cloud! This is a fantastic new capability that allows us to sta... Show More

    Hi Qlik Community,

    The new Model Context Protocol (MCP) Server is now available in Qlik Cloud! This is a fantastic new capability that allows us to standardize how we connect AI models to our Qlik data.

    To help everyone get started, I've recorded a complete, step-by-step video tutorial on how to enable, configure, and connect the Qlik MCP Server to Claude Desktop.

    📺 Watch the video tutorial here: https://youtu.be/eUo0y8j3ITU

    The video covers:

    1. Enabling the AI features in the Qlik Cloud Tenant.

    2. Creating a Qlik MCP permission and assign users.

    3. Adding Qlik MCP Connection to Claude Desktop

    4. Authenticating and testing the Claude Connection to Qlik MCP Server

    For a written companion to the video, you can also check out the full article on the Data Voyagers blog here: 
    https://www.datavoyagers.net/post/qlik-mcp-server-is-here-enable-configure-it-with-claude

    I'm excited to see what use cases you all come up with for this integration. Let me know your thoughts in the comments!


    Regards,

    Mark Costa

    Show Less
  • forum

    Scalability

    Qlik Sense Enterprise Scalability Tools

    This tool is being deprecated, updates will be received during 2026, but thenceforth be considered deprecated. The Qlik Sense Enterprise Scalability T... Show More

    This tool is being deprecated, updates will be received during 2026, but thenceforth be considered deprecated.


    The Qlik Sense Enterprise Scalability Tools (QSEST) are used to create and run load and performance tests towards Qlik Sense Enterprise on Windows (QSEoW).

    Included parts are:

    • Documentation on how to use the package
    • Command line tool for Windows, Mac and Linux. This command line tool (gopherciser) is open source and can be found here .
    • GUI for Windows and Linux.

    Downloadable files can be found here:
    📎 Qlik Sense Enterprise Scalability Tools 


    Qlik Sense documents to help analyze result and log files can be found here :https://community.qlik.com/docs/DOC-15451

    Change log

    v1.14.1

    • Bugfix for entering JWT key path
    • Gopherciser v0.21.23 -> v0.22.2
      • Avoid errors with JWT keys when running as wasm in GUI
      • improved IPv6 handling
      • bugfixes

    v1.14.0

    • Added linux arm64 binaries
    • Removed osx binaries
    • Updated scheduler including support for linux arm64
    • Support for QSEoW Nov 2025
    • Gopherciser v0.20.1 -> v0.21.23
      • Bugfixes
      • Support nl insights objects
      • Support Treedata calculation condition
      • Add sn-nav-menu to supported objects.
      • Add arm64 linux binaries
      • Add scheduler and CPU metrics to prometheus pushed metrics
      • Add configurable thinktime inbetween publishing and unpublishing sheets
      • Add optional timeout settings to open app action
      • Add possibility to generate empty script to template command
      • Autodetect privatekey type and update default signing algorithm when using jwtsettings
      • Support for PS256,PS384,PS512,ES256,ES384,ES512 and EdDSA JWT signing algorithms
      • Duplicatesheet improvements
      • Limit request concurrency while getting app structure

    v1.13.0

    • Gopherciser v0.18.7 -> v0.20.1
      • QSEoW Nov24 support
      • Support sn-tabbed-container object
      • Openapp changed for Nov24 api compliance
      • New default websocket reconnect backoff pattern
      • Bugfixes

    v1.12.0

    • Updated scheduler
    • Gopherciser v0.18.5 - v0.18.7
      • performance enhancements
      • new action stepdimension
    •  

     

    Your use of Qlik Sense Enterprise Scalability Tools will be subject to the same license agreement between you and Qlik for your Qlik Sense License. Qlik does not provide maintenance and support services for the Qlik Sense Enterprise Scalability Tools, however please check QlikCommunity for additional information on use of these products.

    Show Less
  • forum

    Integration, Extension & APIs

    Qlik Sense May 2026 IR contains Virtual Proxy issues regarding "Allow Anonymous"...

    Hi Qlik Community, ¡IMPORTANT!If you are on QAP and leverage anonymous authentication, do NOT upgrade to May 2026 Initial Release.We have upgraded one... Show More

    Hi Qlik Community, 

    ¡IMPORTANT!

    If you are on QAP and leverage anonymous authentication, do NOT upgrade to May 2026 Initial Release.

    We have upgraded one of our TEST environments and noticed this issue:

    even if the Virtual Proxy is configured to Allow Anonymous Users, they are being prompted for authentication.

    So, please check your virtual proxy configuration before upgrading, or wait for the fix.

    The Virtual proxies that are configured as Always anonymous users are working as expected.

    @Giuseppe_Novello | @Sonja_Bauernfeind | @Ray_Strother 

    @Eduardo_Monteiro | @SergioProba | @kauenascimento | @AnaSilva 

    Show Less
  • forum

    Women Who Qlik

    Changing the Narrative: Women Who Qlik On Telling a Better Career Story

      Ashleigh Chapman (CEO, Engage Together), @GSTAMP  (Associate Director, Qlik Center of Excellence, Raymond James), and Ruthann Wry (Chief People Off... Show More

    spot-blog-Changing_the_Narrative_Women_Who_Qlik_On_Telling_a_Better_Career_Story-image1_ueaf8n.jpg

     

    Ashleigh Chapman (CEO, Engage Together), @GSTAMP  (Associate Director, Qlik Center of Excellence, Raymond James), and Ruthann Wry (Chief People Officer, Qlik) get candid and vulnerable at Qlik Connect 2026, sharing the career experiences that shaped who they are today.

    Their conversation offers powerful takeaways we can all learn from:

    • Big career moves often start with taking a risk
    • Instead of chasing “balance,” aim for integration
    • Confidence is built through action not by waiting for it
    • Sharing your wins is about visibility, not bragging
    • Mentorship is a two-way street

    Want to hear more from these inspiring women? Dive deeper into their stories in the blog and share your own career growth tip in the comments!

     

    Show Less
  • forum

    Connectivity & Data Prep

    Qlik Sense - OLE DB connector

    Hello, community.Does anyone else have the same issue where, when creating an OLE DB connection via Data Manager to a SQL Server database, after succe... Show More

    Hello, community.
    Does anyone else have the same issue where, when creating an OLE DB connection via Data Manager to a SQL Server database, after successfully testing the connection, it does not list the databases? When creating the same connection via Data Load Editor, this same behavior does not occur.
    Qlik Sense Enterprise Client-Managed May 2025

    Data Manager:

    makunii_0-1787315963154.png


    Data Load Editor

    makunii_1-1787316026895.png


    Regards,
    Marco

    Show Less
  • forum

    Visualization and Usability

    QlikSenseCLI 38.38.26128 not working with Qlik 31.62.0.0 (May 2026)

    I'm running using the QlikSenseCLI, but I still get the error "Get-QSAbout : Cannot convert type 'System.Management.Automation.PSObject' to 'string'At... Show More

    I'm running using the QlikSenseCLI, but I still get the error 

    "Get-QSAbout : Cannot convert type 'System.Management.Automation.PSObject' to 'string'
    At line:2 char:12
    + $QSAbout = Get-QSAbout
    + ~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Get-QSAbout], RuntimeBinderException
    + FullyQualifiedErrorId : Microsoft.CSharp.RuntimeBinder.RuntimeBinderException,QlikSenseCLI.GetQSAbout"

    This work:
    Invoke-QSGet "/qrs/about"

    SchemaPath : About
    BuildVersion : 31.62.0.0
    BuildDate : 5/8/2026 18:23:36 PM
    DatabaseProvider : Devart.Data.PostgreSql
    NodeType : Central
    SharedPersistence : True
    RequiresBootstrap : False
    SingleNodeOnly : False
    ExtensionData :

    I'm using the QlikSenseCLI from Program Files\Qlik\Sense\Tools\QlikSenseCLI

    Look like:

    • QRS is healthy.
    • Authentication is healthy.
    • Invoke-QSGet works.
    • You're running May 2026 (Build 31.62.0.0).
    • The failures are in the QlikSenseCLI DLL wrappers
    Show Less
  • forum

    Visualization and Usability

    qlik sense object scanner install and run

    was anyone able to generate the 3 files mentionned in the article https://help.qlik.com/en-US/sense-admin/May2026/Subsystems/DeployAdministerQSE/Conte... Show More

    was anyone able to generate the 3 files mentionned in the article https://help.qlik.com/en-US/sense-admin/May2026/Subsystems/DeployAdministerQSE/Content/Sense_DeployA...

    at this time i only get the "QlikObjecScanReport.csv"

    • QlikObjectScanOutput.parquet: Contains information about all visualizations used in all apps of the installation.

    • QlikObjectScanExtensionStatus.parquet: Contains information about all extensions available in the Qlik Sense installation and their deprecation status.

    • QlikObjecScanReport.csv: Contains meta data, including time stamp of the scan.

     

    any ideas? 

     

    @Eduardo_Monteiro thanks for suggesting 

    https://community.qlik.com/t5/Official-Support-Articles/Enable-parquet-file-support-for-existing-Apps-in-Qlik-Sense/ta-p/2085211

    but this gets me an error when running the ImportQlikSenseCLIModule.ps1

    mikaelsc_0-1779994377639.png

    similar error when running the AddParquetExtentionWhitelistTable.ps1

    mikaelsc_1-1779994433244.png

     

     

    Show Less
  • forum

    Integration, Extension & APIs

    KPCity: a KPI as a city. (Qlik Extension)

    In many dashboards, a KPI is simply a large, highlighted number; a subscript, a green or red arrow, etc. When used properly, it allows dashboard users... Show More

    In many dashboards, a KPI is simply a large, highlighted number; a subscript, a green or red arrow, etc. When used properly, it allows dashboard users to identify the most relevant data at a glance.

    MigueldelCampo_0-1787828552253.png

    While building a dashboard to monitor facilities, I came up with the idea of giving a KPI a different look by using Qlik extensions, which are basically a package (ZIP) containing a manifest, a CSS file, and the corresponding .js file.

    Unfortunately, although the result looked nice, it lost points in terms of readability. It made it harder to understand which KPI was being displayed and, honestly, the colors and shapes attracted more attention than the actual data itself.

    So, we ruled this out as a daily-use tool. But... there was no shortage of laughs along the way.

    It was a great opportunity to learn a little more about how Qlik works internally. Who knows, maybe someday it will be useful for something else.

    For quite some time, I have had an Android application installed on the screen at home called YoWindow, which displays different colorful scenes after a few minutes of inactivity, along with the time, weather, etc. I took inspiration from its city scenery for this extension.

    The idea is to have several buildings, facilities, pharmacies, etc., each with their own doors, decorations, and windows.

    Define a KPI, set a maximum value for it, and use the illuminated windows as the KPI: the closer the value gets to the defined maximum, the more windows are turned on.

    Visually appealing? Yes.
    Practical? Not at all.

    Pretty clear so far.

    I started from the ground up, testing the JavaScript integration and trying to "reach" what Qlik calls the hypercube (layout.qHyperCubeData).

    The hypercube provides the following data:

    • qDimensionInfo: information about each dimension in your application or dashboard.
    • qMeasureInfo: information about each measure.
    • qDataPages: the context containing the data.

    I used the simplest expression I could think of to bring a real piece of data from Qlik into Javascript&colon; ReloadTime().

    If I could display ReloadTime() inside my extension, I knew I was on the right track!

    Fortunately, there is quite a lot of documentation available to give Claude enough context to produce this:

    MigueldelCampo_1-1787828649853.png

     

    Here is the hypercube with all its definitions!

    Perfect! I could finally see the light at the end of the tunnel. I was now able to connect my JavaScript with Qlik.

    From this point on, things became much easier, because without all the complete definitions, the extension simply wouldn't work. Instead of displaying the function's result or calculation, it would show the expression itself.

    For the city, I defined SVG vectors directly inside the JavaScript, since this is much easier than importing images. And don't even get me started on loading external images without the appropriate tenant permissions — that's simply impossible for security reasons.

    So, our friends "the vectors" were the better option. After all... they're just simple shapes.

    Once the script was ready, including the variables I thought would be interesting for users to configure — such as colors, number of buildings, minimum and maximum values — I passed it to Claude and asked it to package everything for me.

    It made several suggestions, fixed some issues in the script, and gave me the ZIP file ready to import.

    Installation is straightforward: in Qlik Cloud, go to Administration → Extensions → Add. Once uploaded, the extension becomes available as an asset in the object gallery, ready to be dragged and dropped onto a sheet.

    I'm leaving the GitHub link here in case anyone is still interested:

    https://github.com/Miguelos2/extensiones/blob/main/KPCity/CiudadKPI.zip

    Have a great week!

    Show Less
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image