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,428 members
  • 13,609 online
  • 2,052,223 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

    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

    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

    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

    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

    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

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

    Qlik Automate

    Pass current selections from Qlik Application to Qlik Application Automation

    I am using the template "Store a straight table as a .csv file on Amazon S3" to store straight table data to S3 bucket. What is working: I am able to ... Show More

    I am using the template "Store a straight table as a .csv file on Amazon S3" to store straight table data to S3 bucket.


    What is working: I am able to store a .csv file to S3 bucket on the click of a button configured in Qlik application.

    What is not working / Need help with:

    1. There are filters (MonthYear, Plant) provided to user in front end after which the user would click on the button to run the automation and the automation will take the straight table object and store the data in .csv on S3 without applying the filters that was selected on front end before running the automation.

    2. Filters will always have one value selected and the same needs to be used for .csv file naming. for e.g. file name needs to be MonthYear_Plant_Test_TimeStamp.csv where test would be the actual file name and MonthYear_Plant_ as prefix and _TimeStamp as suffix

    Show Less
  • forum

    Qlik Automate

    Automation to receive selections from App and pass it to a report

    Good day Qlik community, I have an unusual requirement. I want my users to be able to click on a button on an app and call an automation sending their... Show More

    Good day Qlik community,

    I have an unusual requirement. I want my users to be able to click on a button on an app and call an automation sending their selections to the automation and applying the selections to the report. The first part is easy and it is working. I can pass and receive the selections in the automation.

    The part that I cannot get it right is the one to pass the selection to the report. For some strange limitation, if I apply a bookmark to my automation, the report totally ignores it. I have to explicitly pass each field selection to the report using the Add Selections to report.

    It does work if I create one of these blocks for each field but would require for me to know fields the user will select, which I don't. What I want is to loop through each field and apply the selection for that field.

    I am using the block "List Current Selections" to loop these fields. This seems to work. Inside that loop, I am trying to use the block Add Selectiction to Report". That one does not work. It forces me to pick a field by the index (0, 1, 2) instead of do what any loop does and get the index for the corresponding loop iteration.

    Ideas?

    These are some screenshots that might help:

    igoralcantara_1-1711725061434.png

    igoralcantara_2-1711725085340.png

     

    igoralcantara_3-1711725107227.png

     

    Show Less
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image