I have a table that currently works - it allows the user to select WeekStartShipDate, which is loaded in the load script with a Floor value, filtering the table to just one week:

The variables vStartSixWk and vEndSixWk determine the date range for the 6 Week column. 

vStartSixWk  =(WeekStartShipDate) -42

vEndSixWk  =(WeekStartShipDate)

The 6 Week column is then calculated as follows:

Sum({<WeekEndShipDate={">=$(vStartSixWk)<=$(vEndSixWk)"}>} EquivalentUnits) / 6

The % of 6Wk Total column is calculated as follows:

Num(
Sum({<WeekEndShipDate={">=$(vStartSixWk)<=$(vEndSixWk)"}>} EquivalentUnits) / 6
/
Sum(
TOTAL
Aggr(
Sum({<WeekEndShipDate={">=$(vStartSixWk)<=$(vEndSixWk)"}>} EquivalentUnits) / 6,
ShipTo
)
),
'##0.0%'
)

So, that all works fine until I add another dimension column, such as SalesOrder. Once I do that, the date filter breaks, and the 6 Week expressions return zeroes.

Please advise.

One of users have created new columns not existing in source but added on the target table. They are seeing NULLS overriding the values in these columns. Is there anyway to exclude writing data to these columns in Qlik Replicate.

FYI - We are using May 2025 Replicate

Appreciate your assistance !

Thank you,

Pranathi Yerragudi

Hi team,

I tried to set up this LLM but currently, to make the test with Swagger on Power Automate to authorize the OAuth session, it indicates that the redirect URI is not registered, and I made this in the before steps.

Some have the same problem or know other steps to work with Qlik Cloud MCP and Copilot.

Thanks

Qlik nPrinting upgrade from February 2024 sr1 to May 2026 sr2 creating issues.

Updtaed fine but at the first startup looks like I have communication issues between the engine and Rabbit.

Windows server 2019 and all running on same machine.

For example opening connections list, is blank and spinning and loading for ever.

Not sure someone else has same problems. Same issue if I try to upgrade to February 2025.

Log attached.

Hi,

I am using button object in layout container over a text object to apply some actions and sheet navigation in Qlik Cloud. This works perfectly in browser but not in SaaS mobile app. I have noticed that actions such as set variable value works perfectly in mobile app however only navigation functionality is not working either I choose sheet navigation or apply bookmark action.

Can anyone confirm that this is a known bug or please suggest some solution or workaround. 

Hello!

We are using Qlik Sense on Windows and  the user authentication is managed by Keycloak (method: OIDC).

We user Keycloak groups to define user type: Analizer and Professional and automatically assign a license.

However, we didn't find any possibility to revoke the license if the user is removed from the respective group.

Could you suggest a way to synchronize license allocation according to the user groups not just once but on a continuous scale?

Thanks.

A project plan can have every date right and still be impossible: the dates and the people's time sit on different charts.

Our new guide covers both sides. For the work: Gantt chart, PERT chart, and timeline. For the people: resource chart, capacity heatmap, and stacked column chart. Each comes with the question it is built for, the way it can mislead, and the closest related chart.

👉 Project and Resource Planning Charts: Who Does What, When

(Tool-agnostic, so the same choices hold in a Qlik Sense or any other app.)