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.

Rename Change Table | Qlik Replicate Help
Information note
Globally renaming a Change Table will override the Change Table suffix defined in the task settings.
The Change Table name must be different from the source table names. Otherwise, a table error will occur.

Issue with Using a PostgreSQL-Based database as a target

Postgresql 17 driver as per documentation is used. https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/PostgreSQL/postgresql.htm#ar_postgresds_802412600_1325150

In Qlik Replicate 2024:

=======================

Once the Global variable is defined for renaming "change table". that is the only rule which is applied.

The suffix "__ct" in the Change Table Settings under TASK Setting == > Change processing is ignored.

Table name : ACTY

EX: Global rule for rename change table : 

In Qlik Replicate 2025:

=====================

I am trying to build a URL so i can link from a Cataloging app that we are building directly to an Apps lineage sheet.  A sample image of what i am trying to link to is attached. But so far i have been unsucessful in building a working URL.  For example, when i click on Tools-->Lineage the URL looks like this: 

https://mytenant.us.qlikcloud.com/lineage/qri%3Aapp%3Asense%3A%2F%2F876c4y32-3rj4-5t73-sr65-98k40d63j234?resourceName=My%20App%20Name 

But i don't know what this number is in the middle. The one that starts with 876c4... It's not the app id and it's not a number i can find in any of the App, Lineage or Item API's or from App/Item information in an Automation. Without it, it doesn't appear i can open that sheet.

Has anyone linked to this before?  is it even possible?

Thanks

Good Morning all,

this one might be better suited in the API section, but i dont know....I am trying to get the IDs of all QVDs in a given (subfolder) of a space from within my LOAD script. I tried setting up a REST connection (worked) and also giot to see a few QVDs, but these seemed to be only QVDs from my personal folder...Can anyone help 

If this will not work: My ultimate goal is to delete QVDs (using an automation) in a given space based on a list of QVD names that need to be deleted. (I tried that as well, but failed as i need the file IDs for the files i want to delete...which i dont know how to get)

Thanks for any kind of support!

Anyone experiencing high latency after the switch to Standard Time last weekend?   Any suggestions on how to resolve?  We just upgraded to Replicate version May 2026 a couple of weeks ago.  Thank you!

Flow data usually arrives as a table of from-to pairs, and the same table can become a Sankey, a dependency wheel, or an arc diagram. Which one to start with comes down to two questions: does the position of the nodes matter, and do you need to see how much moves or what connects to what?

Our new guide goes through five charts for flow data: Sankey diagram, flow map, arc diagram, dependency wheel, and network graph. For every chart there is the job it does best and the way it misleads, plus a worked example that runs one set of team handoffs through three of them.

👉 Flow & Process Charts: How Much Moves, What Connects

Hi,

I'm using TOS V7.3.1

After upgrading JRE from amazon-corretto 8.462.08.1 to amazon-corretto 8.512.09.1 on execution server, the excel components tFileOuputExcel and TFileInputExcel doesn't work anymore.

Below the message : 

Exception in thread "main" java.lang.UnsatisfiedLinkError: no freetype in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1860)
at java.lang.Runtime.loadLibrary0(Runtime.java:843)
at java.lang.System.loadLibrary(System.java:1136)
at sun.font.FontManagerNativeLibrary$1.run(FontManagerNativeLibrary.java:59)
at java.security.AccessController.doPrivileged(Native Method)
at sun.font.FontManagerNativeLibrary.<clinit>(FontManagerNativeLibrary.java:32)
at sun.font.SunFontManager$1.run(SunFontManager.java:346)
at java.security.AccessController.doPrivileged(Native Method)
at sun.font.SunFontManager.<clinit>(SunFontManager.java:342)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:348)
at sun.font.FontManagerFactory$1.run(FontManagerFactory.java:82)
at java.security.AccessController.doPrivileged(Native Method)
at sun.font.FontManagerFactory.getInstance(FontManagerFactory.java:74)
at java.awt.Font.getFont2D(Font.java:491)
at java.awt.Font.canDisplayUpTo(Font.java:2056)
at java.awt.font.TextLayout.singleFont(TextLayout.java:470)
at java.awt.font.TextLayout.<init>(TextLayout.java:531)
at org.apache.poi.ss.util.SheetUtil.getDefaultCharWidth(SheetUtil.java:273)
at org.apache.poi.xssf.streaming.AutoSizeColumnTracker.<init>(AutoSizeColumnTracker.java:117)
at org.apache.poi.xssf.streaming.SXSSFSheet.<init>(SXSSFSheet.java:82)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.createAndRegisterSXSSFSheet(SXSSFWorkbook.java:674)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:695)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:87)
at org.talend.ExcelTool.prepareXlsxFile(ExcelTool.java:130)
at bnppf.bnppf_abba_t9_t10_reports_0_1.Bnppf_Abba_T9_T10_Reports.tDBInput_1Process(Bnppf_Abba_T9_T10_Reports.java:4767)
at bnppf.bnppf_abba_t9_t10_reports_0_1.Bnppf_Abba_T9_T10_Reports.tWarn_2Process(Bnppf_Abba_T9_T10_Reports.java:4330)
at bnppf.bnppf_abba_t9_t10_reports_0_1.Bnppf_Abba_T9_T10_Reports.tWarn_1Process(Bnppf_Abba_T9_T10_Reports.java:4118)
at bnppf.bnppf_abba_t9_t10_reports_0_1.Bnppf_Abba_T9_T10_Reports.runJobInTOS(Bnppf_Abba_T9_T10_Reports.java:8828)
at bnppf.bnppf_abba_t9_t10_reports_0_1.Bnppf_Abba_T9_T10_Reports.main(Bnppf_Abba_T9_T10_Reports.java:8617)

But it works when I launch the jobs from Open Studio in my laptop.

Any suggestion please ?

Many thanks

Qlik Talend Cloud is being updated,

The first region is being deployed, it will take a few days for all regions to be updated.
Please refer to the latest Release notes to see what's new.

https://help.qlik.com/talend/en-US/release-notes/8.0/r2025