I am working with a CDC task in Qlik Compose and wanted to understand how it handles NULL values when replicating data from the source to the target. If a source column contains NULL values but the corresponding target column has a NOT NULL constraint, the insert can fail. What is the recommended way to handle this situation? Should this be managed through mapping transformations or by adjusting the target table schema?

Are there any videos, demos, or demonstrated use case for using Talend Data Catalog and showing its use and capabilities instead of the learning paths on learning portal?

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:

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

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:

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!