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,474 members
  • 7,495 online
  • 2,052,232 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

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

    App Development

    Inputsum function

    I have an expression which is given below:(Sum({<Year={$(=Max(Year))},Company={"ITC"},DTNo={$(=Min(DTNo))} >}Contr)/Sum({<Year={$(=Max(Year))},Company... Show More

    I have an expression which is given below:

    (Sum({<Year={$(=Max(Year))},Company={"ITC"},DTNo={$(=Min(DTNo))} >}Contr)

    /

    Sum({<Year={$(=Max(Year))},Company={"ITC"},DTNo={$(=Min(DTNo))} >}Volume))
    /1000

    Please let me know is InputSum works here because in a single expression InputSum is working but in that type of calculation logic it's not working.

     

    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

    Management & Governance

    is qlik sense prepared for next-generation code signing - KB 5125813

    Hi. I have got this letter from Microsoft Azure:https://support.microsoft.com/en-us/servicing/os/windows/docs/2026/08/next-generation-code-signingPrep... Show More

    Hi. I have got this letter from Microsoft Azure:

    https://support.microsoft.com/en-us/servicing/os/windows/docs/2026/08/next-generation-code-signing

    Preparing the Windows ecosystem for next-generation code signing

    Could you please let us know which versions of Qlik Sense and Nprinting are prepared for this change coming with:

    KB 5125813

    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

    QlikView

    How to attach a file on qlik community discussion

    Hi GuysI know this might sound silly but how do you attach a csv file to one of my discussions?Which icon do I use? I don't see any? ...Regards,Magen
  • forum

    Connectivity & Data Prep

    Google Ads Connector - CustomerID Error

    Hi,I'm trying to get data from Google Ads using the built-in connector. I'm using Qlik Sense Enterprise on-premises, November 2025.The connection seem... Show More

    Hi,

    I'm trying to get data from Google Ads using the built-in connector. I'm using Qlik Sense Enterprise on-premises, November 2025.
    The connection seem to be working - when I click "Test Connection", I get the message "Connection Susseeded".
    However, I can't connect to my Google Ads account - when I try to select a value (account) under CustomerID, I get the error "Error retrieving error".

    I'd appreciate any help or advice.

    Thanks!

    Show Less
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image