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: 
  • 283,899 members
  • 4,699 online
  • 2,036,288 posts
  • 155,198 Solutions
Announcements
Catch up on the newest Qlik features and improvements: Learn More

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Help with adding lookup values to main table (ApplyMap + Set Analysis returning ...

    Hi everyone,I'm trying to adjust an amount in my main table by adding a value from a lookup file whenever a few key fields match. I've hit a wall thou... Show More

    Hi everyone,
    I'm trying to adjust an amount in my main table by adding a value from a lookup file whenever a few key fields match. I've hit a wall though my Set Analysis expression keeps returning 0, and a normal Sum gives me a completely unexpected number.
    Here is what I’m working with:

    Here is what I’m working with:
    My Tables:
    • Lookup file: Date, Account Number, Contract Reference, AmountToAdd
    • Main table: Date, Account Number, Contract Reference, AmountOriginal, AccountType (and a bunch of other fields)
    What I need to happen:
    I want to create a new field called AmountAdjusted. When Date, Account Number, and Contract Reference match between the two tables, it should add AmountOriginal + AmountToAdd. If there's no match, it should just keep AmountOriginal.
    What I've tried in the script:

    ApplyMap(
    'MapAmountadjusted',
    Trim([Contract Reference]) & '|' & Trim([Account Number]) & '|' & Num(Floor(Date)),
    AmountOriginal
    ) AS AmountAdjusted

    Where I'm stuck:
    1. When I use this expression on the front end, I just get 0:qlik
    Sum({$<Year={'$(vMaxYear)'}, %Date={'$(vMaxDate)'}, AccountType={'001','002'}>} AmountAdjusted)

    2. If I just use Sum(AmountAdjusted) and manually filter the Year and Date in the app, I get a number, but it doesn't make sense compared to what I expect.
    Am I going about the ApplyMap addition the wrong way, or is something off with my Set Analysis? Any pointers would be hugely appreciated!

     

     

    Show Less
  • forum

    Management & Governance

    Data Usage Analysis

    Hello everyone,We are currently in the process of preparing to switch from a user-based to a data volume-based licensing model.To this end, we would l... Show More

    Hello everyone,

    We are currently in the process of preparing to switch from a user-based to a data volume-based licensing model.

    To this end, we would like to identify the main drivers of data usage at present. Unfortunately, such an analysis can only be carried out once the model has already been changed, and not beforehand.

    Does anyone already have a suitable solution for this?

    Thanks.

    Show Less
  • forum

    App Development

    How can I display values ​​for specific months in my report using a ValueList?

    Good afternoon, community.I am creating a report in which I am using a `ValueList` within my dimension—for example: `ValueList('RESULTADO 2026', 'VS 2... Show More

    Good afternoon, community.

    I am creating a report in which I am using a `ValueList` within my dimension—for example: `ValueList('RESULTADO 2026', 'VS 2025', 'VS KPI 2026')

    And in my measure, I include this formula:

    =If(
    ValueList(
    'RESULTADO 2026',
    'VS 2025',
    'VS KPI 2026'
    ) = 'RESULTADO 2026',

    Num(Sum({<Mes=,Año = {'$(vAñoActual)'},fecha = {"<=$(vMaxFechaActual)"}>} Numero_Entradas),'#,##0'),

    If(
    ValueList(
    'RESULTADO 2026',
    'VS 2025',
    'VS KPI 2026'
    ) = 'VS 2025',

    Num((Sum({<Mes=,Año={'$(vAñoActual)'},fecha = {"<=$(vMaxFechaActual)"}>} Numero_Entradas) - Sum({<Mes=,Año={'$(vAñoAnterior)'},fecha = {"<=$(vMaxFechaAnterior)"}>} Numero_Entradas))
    /Sum({<Mes=,Año={'$(vAñoAnterior)'},fecha = {"<=$(vMaxFechaAnterior)"}>} Numero_Entradas),'0.0%'),

    Num((Sum({<Mes=,Año={'$(vAñoActual)'},fecha = {"<=$(vMaxFechaActual)"}>} Numero_Entradas)/Sum({<Mes=,Año={'$(vAñoActual)'},fecha = {"<=$(vMaxFechaActual)"}>}Total_Presupuesto)),'0%')
    )
    )

    If I don’t select a specific month, my results appear correctly in the report. However, if I select a month—for example, September—the data for September is displayed correctly, but the data for the preceding months is shown as percentages instead of the correct values.
    The measure I am using represents a cumulative total from January to September.
    How can I ensure that, when I select a specific month, the data for the unselected months is also displayed correctly?

    I have attached images showing how my report looks.

    I look forward to your suggestions.
    Thanks.

     

    Show Less
  • forum

    Data Movement & Streaming

    Issue when downloading table data in Qlik Cloud

    Hello Qlik Support Team,I am experiencing an issue when trying to download data from tables in Qlik Cloud.When I try to download a table for the first... Show More

    Hello Qlik Support Team,

    I am experiencing an issue when trying to download data from tables in Qlik Cloud.

    When I try to download a table for the first time, the only available download options are Image and PDF. The Data option is not displayed.

    However, if I close the download window (by pressing ESC) and try again, the Data option becomes available, allowing me to download the table data normally.

    This issue happens on the first attempt, and I have to repeat the process to access the Data download option.

    Environment:

    • Platform: Qlik Cloud
    • Browser: Google Chrome

    Could you please investigate this behavior and let me know if there is a workaround or a permanent solution?

    Thank you for your support.

    Show Less
  • forum

    App Development

    [ARTICLE] How to Create a Fully Transparent Button in Qlik (Button Over Button)

    Sometimes, the best solutions are not the most obvious ones. 😉If you want to create a 100% transparent button in Qlik, here's a little trick that inv... Show More

    Sometimes, the best solutions are not the most obvious ones. 😉

    If you want to create a 100% transparent button in Qlik, here's a little trick that involves tweaking the button's properties directly.

    Follow these steps:

    - Add a Layout Container to your sheet.

    - Add two buttons inside the container.

    - Activate Options / Developer mode.

    - Set any background color for one of the buttons.

    - Right-click the button and select Open Developer.

    - Go to Properties and look for the following section:

    "background": {
        "useColorExpression": false,
        "color": {
            "index": 9,
            "color": "#a16090",
            "alpha": 1
        }
    }

     

    - Now, change the color and alpha values to:

    "background": {
        "useColorExpression": false,
        "color": {
            "index": 9,
            "color": "#000000",
            "alpha": 0.00001
        }
    }

     

    botao transparente.gif

     

    🎉 And that's it! Enjoy your fully transparent button!

    A little unconventional? Definitely.
    Effective? Absolutely!

    Sometimes, knowing where to tweak things makes all the difference in Qlik.

    💡 Have you ever used a similar workaround in Qlik? Share your tricks in the comments!

    Show Less
  • forum

    Talend Cloud

    Talend Cloud To Qlik Talend Cloud Migration

    Hi I need to acquire guidance on how a Talend Cloud customer is migrated to QTC.  Cant find it via searching. 
  • forum

    Talend Cloud

    Migrate from TAC to TMC using Qlik Talend® Cloud migration toolkit

    Hi every one,I would like to migrate Jobs from TALEND ADMINISTRATION CENTER (TAC) to TALEND MANAGEMENT CONSOLE (TMC) using Qlik Talend® Cloud migratio... Show More

    Hi every one,

    I would like to migrate Jobs from TALEND ADMINISTRATION CENTER (TAC) to TALEND MANAGEMENT CONSOLE (TMC) using Qlik Talend® Cloud migration toolkit.

    I have access to TAC and I know I must have access to TMC with administrator previleges.

    I wa wondering if someone has already used the Qlik Talend® Cloud migration toolkit and if so, I wonder if I can get some pointers on how to go about it.

    Thank you,
    Rui

    Show Less
  • forum

    Talend Studio

    Subject: Talend Studio Connection Error – Network Issue Occurred When Connecting...

    Hello Qlik Community,I'm currently experiencing a connection issue in Talend Studio V8 (Talend Cloud Data Management Platform – R2025-12).While workin... Show More

    Hello Qlik Community,

    I'm currently experiencing a connection issue in Talend Studio V8 (Talend Cloud Data Management Platform – R2025-12).

    While working on my Talend job, a pop-up message suddenly appears:

    "Network Issue Occurred – Meet network issue during connecting to server, do you want to retry?"

    It also provides an option to set the connection timeout (currently set to 500 seconds).

    I'm signed in to Talend Cloud (Asia Pacific on AWS), and the issue occurs while working in Talend Studio. Even after increasing the connection timeout, the connection issue persists.

    I would like to ask the community:

    1. Is there currently an ongoing issue, service interruption, or maintenance affecting Talend Cloud connectivity?

    2. Has anyone encountered this particular network connection error recently?

    3. Could this be related to Talend Cloud server availability, network connectivity, authentication, or a problem with the Studio configuration?

    4. What troubleshooting steps or configuration changes would you recommend to resolve this issue?

    I would appreciate any insights, suggestions, or solutions from anyone who has experienced the same problem.

    Thank you in advance for your assistance!

    Prince001_1-1794552625476.png

     

     

     

     

    Show Less
  • forum

    Management & Governance

    Upgrade Failed: Issue While Upgrading Qlik Sense from Nov 2023 to May 2026 SR1

    Hi Team,I am trying to upgrade our Qlik Sense environment from November 2023 to May 2026 SR1, but the upgrade is failing. During the setup process, it... Show More

    Hi Team,

    I am trying to upgrade our Qlik Sense environment from November 2023 to May 2026 SR1, but the upgrade is failing. During the setup process, it stops and shows an “Update Failed” message without giving detailed logs on the screen.

    I have already checked basic prerequisites like:

    • Service account permissions
    • PostgreSQL service status
    • Qlik services running before upgrade
    • Enough disk space and memory

    But the installer still fails.

    Can someone guide me on:

    1. What are the common failure causes while upgrading to May 2026 SR1?
    2. Which installation logs should I check (and exact path)?
    3. Any known issues or patches for upgrading from Nov 2023?

    Thanks in advance for your support!

    Show Less
  • forum

    QlikView

    QlikView Desktop September 2025 IR/SR1/SR2 – Severe Performance/Responsiveness I...

    Hi,We have QlikView Server and QlikView Desktop installed on a Windows Server 2022 machine, which we access via Remote Desktop.Earlier this year, I up... Show More

    Hi,

    We have QlikView Server and QlikView Desktop installed on a Windows Server 2022 machine, which we access via Remote Desktop.

    Earlier this year, I upgraded our QlikView installation from May 2023 to September 2025 SR1. After the upgrade, I noticed that QlikView Desktop had become extremely slow and unresponsive.

    When QlikView Desktop is started, the menus and the application itself initially seem to work normally. However, as soon as I open a QlikView document, the application becomes very sluggish. On AccessPoint everything works fine.

    For example:

    - Clicking the QlikView > About menu can take 2–4 seconds before anything happens.
    - Right-clicking an object on a report can take several seconds before the context menu appears.
    - Scrolling in list boxes is very jerky and noticeably delayed.
    - In general, there is a significant delay between clicking something and QlikView responding.

    At the time, I did not have time to investigate the issue further.

    Today I uninstalled QlikView Desktop and installed the May 2023 version again. The performance immediately returned to normal. When clicking objects or menus in a QlikView document, everything responds almost instantly.

    I then upgraded QlikView Desktop to May 2024 SR1, and the performance was still normal.

    After that, I upgraded to September 2025 IR, and the performance problem immediately returned.

    So far, my testing looks like this:

    - May 2023: Good performance
    - May 2024 SR1: Good performance
    - September 2025 IR: Very slow / significant UI delays
    - September 2025 SR1: Very slow / significant UI delays
    - September 2025 SR2: Very slow / significant UI delays

    I have also disabled the antivirus temporarily, but this did not make any difference.

    Has anyone else experienced similar QlikView Desktop performance or UI responsiveness issues with the September 2025 releases?

    Show Less
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image