I have a pivot table that I am trying to cumulate the sum of rows for YTD Tonnes and Margin %.
I need it to look like below:

I use these for a normal straight table.
RangeSum(Before(TOTAL Sum({<FYMonth>}Tonnes), 0, Rowno(TOTAL)))
and
RangeSum(Above(TOTAL Sum({<FYMonth>}Margin), 0, Rowno(TOTAL)))
/Rangesum(Above(TOTAL Sum({<FYMonth>}Sales), 0, Rowno(TOTAL)))

I have tried this for the pivot table but it is not working. I have also tried “Before” rather than “After”.
RangeSum(After(TOTAL Sum({<FYMonth>}Tonnes), 0, ColumnNo()))
And
RangeSum(After(TOTAL Sum({<FYMonth>}Margin), 0, ColumnNo(TOTAL)))
/Rangesum(After(TOTAL Sum({<FYMonth>}Sales), 0, ColumnNo(TOTAL)))

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!

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?

Setup

We created a Mixpanel connector pointing to our Mixpanel project, configured with:

• Historical backfill start date: 10 Aug 2025 (approximately one year of data)
• Replication schedule: daily

What we observed

We triggered a manual run to load the historical data. That run continued for 24 hours without completing the historical sync, and was still in progress when the next scheduled run was triggered.

The following day's run did not resume from where the previous run stopped. It started again from the beginning and attempted to load the entire year of historical data from scratch. This repeated for several days. On some days the Mixpanel API errored partway through, which also forced the next run to restart from the beginning.

Impact

Across those few days, more than one billion rows were loaded, the large majority of which are duplicates of the same historical data re-ingested on each run. The connector never advanced far enough to reach current data.

What we would like to understand

1. Why does the connector behave this way — specifically, why is progress from an incomplete run not retained, so that each subsequent run restarts from the original start date rather than resuming?
2. What is the recommended way to configure this connector so the historical backfill completes reliably and the pipeline then stays current — without re-ingesting the same data on every run?

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.

Hi all,

In Qlik Cloud Analytics I created a data alert that triggers when the supplier changes for an item-warehouse combination. The alert works, but the View in application link in the notification fails to apply the selection.

Setup

• The alert is created from a master dimension that is a plain field (no expression), and it has measures Sum(SupplierChanged), Only([Previous Supplier]) and Only([New Supplier]).
• The alert is split by that dimension under Show by dimension.
• Condition: Supplier Changed Flag greater than 0. Schedule: when data changes.
• The notification itself is correct: it lists the key and the old and new supplier.

Problem
Clicking View in application opens the app and shows:
“A field you are trying to make a selection in could not be found. The selection has not been applied.”

Link generated from the alert - .../sheet/<sheetId>/bookmark/<bookmarkId>/select/[ItemWarehouseKey]/400000021000001-1CH

What I tested

• Editing the first link to remove [ ] so it ends /select/Item%20Warehouse%20Key/400000021000001-1CH opens the app with the key selected correctly. The field and data are fine.
• Recreating the alert from scratch, with a plain-field master dimension and with a field name without spaces, did not remove the brackets.
• Test with brackets and no =: [fails]
• Test without brackets: [works]

Questions

1. Does the data alert link support a selection on a field when the alert is split by a master dimension or table dimension? Is it expected to include =[ ] or [ ] in the link?
2. Is there a way to make the alert write the plain field name in the link?
3. Is this a known limitation or a bug?

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 

Background:
1. Qlik Sense Core-Based License: Embedded Qlik Charts and Dashboards on their website (mashups).
2. Current Web Frontend:
- Mashups
- RequireJS v2.3.6
- NuxtJS v2
- Capability APIs v1.8 (Qlik Sense API)

Questions:
1. Can the website be developed to use the Visual Exploration menu on the customer’s website? (Images from customer as attached)
2. If yes, is it necessary to write additional functions? What are the steps involved?
3. If not, what APIs are currently in use, or which ones can be recommended to enable the use of the Visual Exploration menu?

Hi Support,

In the GetTableStatuses QEM API call which monitors Replicate tasks, there are 3 metrics returned in the response body called cached_insert_count, cached_update_count and cached_delete_count.  

I'd just like to understand the meaning of these metrics further. Do the counts represent the inserts/updates/deletes that have been picked up from the source and are yet to be applied to the target (i.e. in flight changes)? Or are they a historical count of all cached inserts/updates/deletes?

Thanks,

Nak