Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
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:
Could you please investigate this behavior and let me know if there is a workaround or a permanent solution?
Thank you for your support.
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
}
}
🎉 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!
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
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:
Is there currently an ongoing issue, service interruption, or maintenance affecting Talend Cloud connectivity?
Has anyone encountered this particular network connection error recently?
Could this be related to Talend Cloud server availability, network connectivity, authentication, or a problem with the Studio configuration?
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!
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:
But the installer still fails.
Can someone guide me on:
Thanks in advance for your support!
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?
Qlik is a Leader in the 2026 Gartner® Magic Quadrant™ for Data Integration Tools
See how agentic AI is changing business intelligence and analytics teams, and why trusted data and shared context matter most.
Here’s your agentic AI readiness check. (Got Qlik? You're closer than you think.)
Built for the builders: Modern data engineering is AI powered — and engineer led.
The pilot-to-production gap is real. From fragmented data to governance gaps Qlik and AWS break down what’s holding your enterprise AI back — and how to solve them.
Your journey awaits! Join us by Logging in and let the adventure begin.