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: 
  • 281,706 members
  • 10,279 online
  • 2,052,246 posts
  • 155,170 Solutions
Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work

Welcome to Qlik Community

Recent Discussions

  • forum

    Administering and Monitoring

    udi fhdidi djof ijd fjka fj ejt iod fsji fij of osa foiasjf oiosfjs fj sjf jsa f...

    uis iuf uis fhui sauif huis fui sfuushfiu sufhus fui suif us fjs fh sjf jsa fjhsfhb s cbas uif us fusa uf usif sa
  • forum

    Water Cooler

    High Five - October 2026, Rafael Encinas

      Featured Member · October 2026 Meet Rafael Encinas, our October Featured Member     Some members make the Qlik Community a better place simply by ... Show More
     
    Featured Member · October 2026

    Meet Rafael Encinas, our October Featured Member

     

    Screenshot 2026-10-05 155145.png

     

    Some members make the Qlik Community a better place simply by showing up and lending a hand, and Rafael Encinas is one of them. Rafael has become a go-to presence for members looking for answers and fresh ideas. We're thrilled to name him our Featured Member for October 2026!

    Rafael works at Farol Data Analytics in Brazil, and the Community has become an important part of his day-to-day. For him, it's a place to pick up new skills, trade ideas, and connect with people who share his enthusiasm for data and technology. That mix of learning and connection is what keeps him coming back, and it's a big part of why his contributions have made such an impression on fellow members.

    “It's a great place to learn new things, exchange ideas, and connect with people who are also passionate about data and technology.”

    — Rafael

    Helping other members is where Rafael really shines. He makes a point of pitching in whenever he can, and he's quick to say the benefit goes both ways: he learns a lot from those interactions too. Every question he helps answer is a chance to see a problem from someone else's angle, and every conversation adds to what he knows. It's a great example of how the Community works best, with members teaching and learning from one another at the same time.

    Away from the keyboard, Rafael has plenty to keep him busy. He plays guitar, makes time for the gym, and loves to travel whenever he gets the chance. It's a well-rounded mix, and it's clear that the same energy and enthusiasm he brings to the Community carries over into everything else he does.

     

    Thank you, Rafael!

    Thank you for your contributions and engagement in the Qlik Community! Please join us in celebrating Rafael as our October 2026 Featured Member, leave a comment below!

    @rafaelencinas 

    Show Less
  • forum

    App Development

    Set Analysis - Row comparison

    I know this has been discussed multiple times, but I was wondering whether anything has changed in recent releases.Is there any way to force a Qlik se... Show More

    I know this has been discussed multiple times, but I was wondering whether anything has changed in recent releases.
    Is there any way to force a Qlik set expression to evaluate row by row for a field-to-field comparison? I need to write a complex expression that compares multiple fields within a single record, and I have run into the known issue  (or feature, by design 🙂 ) that set expressions evaluate across the full set of distinct values.
    Please see the image below. We resolved the issue by replacing part of the set expression with if statements. The comparison involves a number of fields, so I was wondering whether any new set modifiers are available that would force row-level comparison when comparing two fields within a record.

    Show Less
  • forum

    App Development

    Dynamic Year‑to‑Date and Month Range Set Analysis in

    Hi everyone,I’m working in QlikView and need help building a set analysis measure that adjusts its date range dynamically based on Year and Month sele... Show More

    Hi everyone,

    I’m working in QlikView and need help building a set analysis measure that adjusts its date range dynamically based on Year and Month selections.

    Here’s the behavior I’m aiming for:

    No Year and no Month selected → Show current year‑to‑date (from 1 Jan of the current year up to today).

    Year selected, no Month → Show year‑to‑date for that year (from 1 Jan up to the latest available date in that year).

    Year and Month(s) selected → Show from the first day of the earliest selected month through the last day of the latest selected month.

    Example: Selecting Year = 2025 with Oct, Nov, and Dec should return 01/10/2025 to 31/12/2025.

    Show Less
  • forum

    App Development

    Butler Sheet Icons: ERR_INVALID_AUTH_CREDENTIALS error with Sense Enterprise on ...

    Hi folks, Could anyone please provide insight into a ERR_INVALID_AUTH_CREDENTIALS error when running Butler Sheet Icons from Ptarmigan Labs? Butler su... Show More

    Hi folks,

    Could anyone please provide insight into a ERR_INVALID_AUTH_CREDENTIALS error when running Butler Sheet Icons from Ptarmigan Labs?

    Butler successfully authenticates with the client.pem certificate and develops a PLAN, but fails after "closed virtual browser" with ERR_INVALID_AUTH_CREDENTIALS error.

    I have included the full verbose log from my session, below.  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 thumbnail icons.

    And insights would be appreciated!

    Thanks,

    Jeff R. Robbins

    The full command as used on Windows 11 workstation targeting a Sense Enterprise on Windows running on Windows Server 2002 is:

    .\butler-sheet-icons.exe qseow create-sheet-thumbnails^
      --host host.domain.com^
      --apiuserdir DOMAIN^
      --apiuserid user999^
      --logonuserdir DOMAIN^
      --logonpwd PASSWORD^
      --logonuserid user999^
      --log-level verbose^
      --appid aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa^
      --sense-version 2026-May
    

    The verbose log is: 

    c:\Qlik local\util\butler-sheet-icons>.\butler-sheet-icons.exe qseow create-sheet-thumbnails  --host host.domain.com  --apiuserdir DOMAIN  --apiuserid user999  --logonuserdir DOMAIN  --logonpwd PASSWORD  --logonuserid user999  --log-level verbose  --appid aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa  --sense-version 2026-May
    2026-09-09T02:14:11.467Z verbose: appid=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa
    2026-09-09T02:14:11.470Z info: ============================================================
    2026-09-09T02:14:11.471Z info:  BUTLER SHEET ICONS 5.2.0 -- QSEoW sheet thumbnails
    2026-09-09T02:14:11.471Z info: ============================================================
    2026-09-09T02:14:11.472Z info: Starting creation of thumbnails for Qlik Sense Enterprise on Windows (QSEoW)
    2026-09-09T02:14:11.472Z verbose: Running as standalone app: true
    2026-09-09T02:14:11.475Z verbose: Certificate file c:/Qlik local/util/butler-sheet-icons/cert/client.pem exists
    2026-09-09T02:14:11.475Z verbose: Certificate key file c:/Qlik local/util/butler-sheet-icons/cert/client_key.pem exists
    2026-09-09T02:14:11.476Z verbose: Certificate files found
    2026-09-09T02:14:11.530Z verbose: Content library 'Butler sheet thumbnails' exists
    2026-09-09T02:14:11.542Z info:
    2026-09-09T02:14:11.543Z info: PLAN
    2026-09-09T02:14:11.543Z info:   server        host.domain.com   https, no virtual proxy
    2026-09-09T02:14:11.543Z info:                 engine 4747, qrs 4242, schema 12.612.0
    2026-09-09T02:14:11.544Z info:   api user      DOMAIN\user999 via ./cert/client.pem
    2026-09-09T02:14:11.544Z info:   logon user    DOMAIN\user999
    2026-09-09T02:14:11.544Z info:   apps          1   1 named by --appid
    2026-09-09T02:14:11.544Z info:   sheet part    1 of 4 -- sheet objects only
    2026-09-09T02:14:11.545Z info:   exclude       none
    2026-09-09T02:14:11.545Z info:   blur          none
    2026-09-09T02:14:11.545Z info:   browser       chrome (version: recommended), headless, 5s per sheet
    2026-09-09T02:14:11.545Z info:   images        ./img/qseow/<app-id>
    2026-09-09T02:14:11.545Z info:   uploads to    content library "Butler sheet thumbnails"
    2026-09-09T02:14:11.546Z info:   WILL OVERWRITE existing sheet thumbnails in 1 app(s), 0 of them published
    2026-09-09T02:14:11.546Z info:
    2026-09-09T02:14:11.546Z info: app 1/1  aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa
    2026-09-09T02:14:11.548Z verbose: Created qseow image directory './img/qseow/aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa'
    2026-09-09T02:14:11.580Z verbose: Using certificates for authentication with Enigma
    2026-09-09T02:14:11.657Z info: Created session to server host.domain.com, engine version is 12.2759.5
    2026-09-09T02:14:13.662Z verbose: Opened app aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa
    2026-09-09T02:14:13.662Z verbose: App name: "Sales Dashboard"
    2026-09-09T02:14:13.665Z verbose: App is published: false
    2026-09-09T02:14:13.693Z info:   "Sales Dashboard" -- 10 sheet(s), not published
    2026-09-09T02:14:13.695Z info: Browser cache directory: c:\Qlik local\util\butler-sheet-icons\browser-cache (default location next to the Butler Sheet Icons executable)
    2026-09-09T02:14:13.696Z info: Browser version "recommended" resolved to chrome build 151.0.7922.71 (the build this version of Butler Sheet Icons is tested with)
    2026-09-09T02:14:13.696Z info: Checking for available browsers...
    2026-09-09T02:14:13.700Z info: Found 1 cached browser(s)
    2026-09-09T02:14:13.702Z info: Using cached browser: chrome 151.0.7922.71
    2026-09-09T02:14:13.703Z info: Browser ready from cache: chrome 151.0.7922.71
    2026-09-09T02:14:13.703Z info: Browser setup complete. Launching browser...
    2026-09-09T02:14:13.703Z verbose: Using browser at c:\Qlik local\util\butler-sheet-icons\browser-cache\chrome\win64-151.0.7922.71\chrome-win64\chrome.exe
    2026-09-09T02:14:13.704Z verbose: Skipping --single-process flag on Windows to keep Chromium stable
    2026-09-09T02:14:14.694Z verbose: Browser launch took 989 ms
    2026-09-09T02:14:14.702Z verbose: Browser responded to version query: Chrome/151.0.7922.71
    2026-09-09T02:14:15.553Z verbose: Closed virtual browser
    2026-09-09T02:14:15.557Z error: QSEOW: qseowProcessApp: net::ERR_INVALID_AUTH_CREDENTIALS at https://host.domain.com/sense/app/aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa
    2026-09-09T02:14:15.558Z error: QSEOW PROCESS APP: Failed to process app aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa: net::ERR_INVALID_AUTH_CREDENTIALS at https://host.domain.com/sense/app/aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa
    2026-09-09T02:14:15.558Z error: Failed to process 1 of 1 app(s)
    2026-09-09T02:14:15.559Z info:
    2026-09-09T02:14:15.559Z info: RESULT  FAILED
    2026-09-09T02:14:15.560Z info:   apps          0 ok, 1 failed
    2026-09-09T02:14:15.560Z info:   sheets        0 seen, 0 captured, 0 excluded
    2026-09-09T02:14:15.560Z info:   elapsed       4s
    2026-09-09T02:14:15.561Z info: ============================================================
    2026-09-09T02:14:15.561Z verbose: QSEOW MAIN 1: command reported failure, exit code set to 1

     

    Show Less
  • forum

    Water Cooler

    QlikSense Pivot Table - How to repeat row labels

    Hello, I'm hoping this community can help me. We are migrating apps from QlikView into QlikSense. I'm having an issue with a QlikSense pivot table whe... Show More

    Hello, I'm hoping this community can help me. We are migrating apps from QlikView into QlikSense. I'm having an issue with a QlikSense pivot table where users need row labels to repeat on each line instead of grouping them together. 

    For instance: 

    Year, Month, Day

    Output is showing:

    2026, January, 01

     , , 02

     , , 03

     

    Expectation:

    2026,  January,  01

    2026,  January,  02

    2026,  January,  03

     

    We would like 2026 to repeat on each line returned.  Is this possible?

    Show Less
  • forum

    App Development

    which approach is faster

    Hello I got a dashboard with star schema and a one fact/linktable with 64M records so far I have the following expression: sum(    {        <         ... Show More

    Hello I got a dashboard with star schema and a one fact/linktable with 64M records so far

    ali_hijazi_0-1791552602472.png

     

    I have the following expression:

     
    sum
    (
        {
            <
                KPI={$(vL.KPI.Effort.Spent.MD)}
                >
            }
            AMOUNT
        )

    this expression is put in a variable named vL.Spent.Mandays because I'm using it in severa charts that have different / addiotnal filters defined:
    for example

    {<
    FLAG_ID={[0],[-1],[6],[7],[8]}
    ,SCENARIO_TYPE={[ACTUAL]}
    ,[Portfolio Level 1 ID]={22}
    ,TASK_NAME=-{'9.0-SAAS TECHNICAL ALLOCATION'}

    >}
    $(vL.Spent.Mandays)

     

    the field FLAG_ID is in the linktable above
    the field SCENARIO is linked to linktable via a key and is in the table SCENARIO_TYPE table
    the field [Portfolio Level 1 ID] is in the table PROJECT_HISTORY
    and the field TASK_NAME is located in the table DIM_TIMESHEET


    this expression is causing the pivot table to respond very slowly
    is it because of the variables I'm using in the expressions
    do I need to write it as follows:

    sum
    (
        {
            <
                KPI={$(vL.KPI.Effort.Spent.MD)}
    ,FLAG_ID={[0],[-1],[6],[7],[8]}
    ,SCENARIO_TYPE={[ACTUAL]}
    ,[Portfolio Level 1 ID]={22}
    ,TASK_NAME=-{'9.0-SAAS TECHNICAL ALLOCATION'}
                >
            }
            AMOUNT
        )

    but in this way I won't reuse the variable vL.Spent.Mandays
    Show Less
  • forum

    Qlik Answers

    Rest Connection

    Em:https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Create-REST-connection/Create-REST-connection.htmCons... Show More

    Em:

    https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Create-REST-connection/Create-REST-connection.htm

    Consta:

    Step 5: Define request parameters and headers

    1. Add query parameters:
      • Enter a unique Name and Value for each parameter.
      • For duplicate parameter names, add them directly into the URL.
    2. Enable Add missing query parameters to final request to include all specified parameters.
    3. Add query headers:
      • Enter Name and Value for each header.
      • Enable Encrypt for sensitive headers (e.g., authorization).
    4. Enable Allow "WITH CONNECTION" for advanced scripting in load statements.
    5. Enable Retry failed requests to handle transient errors (e.g., 429, 503).

      Em minha instalação (a mais recente), e em versões anteriores não aparece na interface para Encriptar parâmetros do Header

      • Enable Encrypt for sensitive headers (e.g., authorization).

        rafaelsigaapp_0-1790886482974.png

         



    Show Less
  • forum

    Administering and Monitoring

    Enabling shared mode studio error: can't find Profile: profile

    Hello,I am using Talend 8 Studio with 2 concurrent user licences. Now I need to enable the shared mode. I've enabled it by following the steps in this... Show More

    Hello,

    I am using Talend 8 Studio with 2 concurrent user licences. Now I need to enable the shared mode. I've enabled it by following the steps in this description:

    https://help.qlik.com/talend/en-US/installation-guide-windows/8.0/enabling-the-shared-mode-for-studio-for-the-first-time

    I have windows administrative rights on the machine.

    When I log in, the system successfully connects to git and shows the branches. However, when I click open, I get an error message:

     

    MauerwegRunnerBerlin_0-1743499362583.png

     

    The new folder p2 remains empty:

    MauerwegRunnerBerlin_1-1743499090829.png

    I've looked into this issue with a devops colleague, but we haven't found an answer. So now the question is what could be the problem and how to solve it.

    Thanks in advance, Matthias

     

    Show Less
  • forum

    App Development

    Upgrading to version May 2026 Patch 2 15.13.13

    HelloI'm working on Qlik SEnse on-premise we recently upgrade the server to May 2026 Patch 2 15.13.13 versionI noticed that the performance of the das... Show More

    Hello
    I'm working on Qlik SEnse on-premise 
    we recently upgrade the server to May 2026 Patch 2 15.13.13 version

    I noticed that the performance of the dashboard degraded signifcantly
    I have a sheet that got 16 KPIs and 2 charts (pivot table, and a scatter chart) all got the same expression but with different filter conditions

    these charts and KPIs are calculated sequentially so you wait for the pivot table, then the KPIs you need to wait for each one to display the results

    isn't it supposed that each chart got its own thread

    Show Less
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image