I came across this video by @marksouzacosta about using the Qlik MCP Server and Agentic Skills to work with Qlik Automations.

He walks through a practical example of creating an automation to reload tables in a Shared Space, testing it, and then using Cloud Code to edit and test the automation again.

I thought it was a really nice example of how these new capabilities can be used in practice, especially for making the development and maintenance of Qlik Automations easier.

Link: https://www.datavoyagers.net/post/new-video-manage-qlik-automations-with-claude-and-qlik-mcp-server

Link: https://youtu.be/FwgpjHETWHU

Hello, we are using Qliksense Enterprise version 14.254.6. But some extensions like multi kpi, input variable, date picker are getting removed automatically and we need to ad them again and again. This issue occurs on frequent basis.Tried the solution suggested:Exclude the Qlik Sense folders from your antivirus scanning. This is the most frequent cause of recurring extension removal.

Multi node structure

Central, 2 Proxies, 2 Schedulers

Extensions are getting removed from QMC itself. It is not dependent on any specific activity. It happens randomly on daily basis.

Hi,

I am trying to automate the generation of a PDF report from one specific sheet in a Qlik Cloud app.

Currently, our manual monthly process is:

1. Open the Qlik Cloud app.
2. Select/filter a Delivery Organisation.
3. Open the sheet that has been designed for the PDF report.
4. Generate/export the report.
5. Repeat the process for each Delivery Organisation.

I am testing the Qlik Automate template “Send a simple multi-page report by email”.

I have configured Create Report with:

• App ID = my Qlik app
• Sheets mode = Custom

I then added an Add Sheet To Report block and linked the Report input to the output of the Create Report block.

However, when I go to:

Add Sheet To Report → Sheet → do lookup

the lookup remains on:

“Lookup is taking a while…”

and never returns the list of sheets.

The app itself is accessible to me and I can open/edit the required sheet normally.

My questions are:

• Is there a way to manually provide the Sheet ID to the Add Sheet To Report block instead of using do lookup?
• Why might the Sheet lookup continuously load even though I have access to the app?
• Is Create Report → Add Sheet To Report → Generate Report the recommended approach if I only want to generate a PDF from one specific Qlik sheet?
• Once this works, can I use Add Selection To Report to apply a Delivery Organisation filter before generating the PDF?
• Ultimately, I need to repeat this for around 19 Delivery Organisations, generating a separately filtered PDF for each. Is Qlik Automate the recommended approach for this, or is there a better native Qlik Cloud reporting method?

Any advice or example automation would be really appreciated.

Thanks!

We are using Qlik Replicate with Microsoft SQL Server MS-CDC as the source. Replicated data is then consumed by Qlik Compose to build a DWH, including Type 2 historical tables.

In our source system, platform upgrades may change table structures not by using ALTER TABLE, but by dropping the existing table and recreating it with a new structure. The existing data is then copied into the newly created table.

During this process, new columns may be added. In some cases, these new columns are populated with default or calculated values during the upgrade itself, before CDC is enabled again for the recreated table.

After the upgrade is completed, the source system is started and new business transactions begin immediately.

For us, it is critical to:

• not lose any changes that occur after the source system is started;

• capture the values of newly added columns that were populated during the upgrade before CDC was enabled again;

• preserve the existing Type 2 history in Qlik Compose.

We would like to understand the Qlik-supported best practice for restoring replication after such table recreation.

The obvious approach would be to remove/re-add the table in Replicate and perform a new Full Load. However, this is very expensive in our environment.

Some of the affected tables contain hundreds of millions of rows. A Full Load in Qlik Replicate takes significant time and generates considerable load on both the source and target. In addition, because the replicated data is consumed by Qlik Compose with Type 2 history, a new Full Load may require additional Full Load / Handle Duplicates processing in Compose, including hash recalculation. For large tables, this process is also very resource-intensive and time-consuming.

Could you please advise on the following:

1. What is the recommended and supported Qlik procedure for recovering MS-CDC replication after a source table has been dropped and recreated?

2. Is it possible to restore replication for such a table without performing a complete Full Load of the entire table?

3. What is the recommended way to capture values in newly added columns that were populated during the upgrade, before CDC was enabled again?

4. Is there any supported mechanism for performing a partial or limited reload/synchronization only for the recreated or affected data, and then continuing Change Processing from a specific LSN?

5. Is the following type of workflow supported:

   • record the LSN before the upgrade;

   • stop Replicate;

   • perform the source-system upgrade and table recreation;

   • enable CDC again;

   • refresh the table metadata in Replicate;

   • synchronize the data that was created or changed outside CDC;

   • continue Change Processing from the saved LSN,

   without performing a complete Full Load of the large tables?

6. What is the recommended approach when the downstream Qlik Compose DWH contains Type 2 historical tables and we need to preserve the existing history without rebuilding large portions of the DWH?

We are specifically looking for a Qlik-supported best practice with minimal manual intervention in the target tables and minimal need for a complete Replicate + Compose reload cycle.

We are not looking for an unsupported manual manipulation of Replicate change tables, Compose metadata, or internal processing tables.

If a complete Full Load cannot be avoided in this scenario provide the recommended Qlik procedure to minimize downtime, source-system load, and reprocessing of large historical tables in Compose?

Hi to everyone,

After upgrading Qlik Sense for Windows to the release May 2026 Patch 3, when I try to open the Load Script for any published app, I can't. The option "Load Script Editor" is missing. This option was present for the release Nov 2025 Patch 6.

I tried to create new rules to permit it with no luck. 

I know, that the way can be to duplicate the app, and see the script, but I would like to know if this behaviour was set by design, and any workaround can't be set via security rules, or so on, or if it's possible.

Was anyone able to set the behaviour I'm missing? if so, can you explain me how to set it?

Thanks in advance

Thanks

Qlik Replicate: May 2025 (2025.5.0.247)
Source: IBM DB2 LUW 11.5.9
Target: IBM DB2 (ODBC)
Architecture: Log Stream Staging → Downstream CDC

Background

We are implementing replication for approximately 35 DB2 LUW databases between MAIN and DR using Qlik Replicate Log Stream Staging + downstream CDC.

The requirement is to keep replication ready in both directions. Application traffic will be active on only one server at a time (MAIN or DR), but we need the replication infrastructure to remain synchronized so that traffic can be switched between servers without rebuilding the replication setup.

1. Start from Timestamp

We tried to start a Log Stream Staging task from a specific timestamp using both:

• Replicate UI → Advanced Run Options → Start processing changes from Date and Time

• Qlik Enterprise Manager (QEM) API

Both return the following error:

"start from timestamp was blocked, when using IBM DB2 LUW as source endpoint, ‘start from timestamp’ is only supported if change was captured after the CDC task started."

Could someone clarify the expected behavior for timestamp-based positioning with DB2 LUW, particularly with a Log Stream Staging → downstream CDC architecture?

2. Log Stream Task Cannot Start

To keep the replication infrastructure ready in both directions, we started the DR → MAIN Log Stream tasks.

For 25 out of 35 databases, we have:

• MAIN → DR Log Stream: Running

• MAIN → DR CDC: Running

• DR → MAIN Log Stream: Running

However, for the remaining 10 databases, the DR → MAIN Log Stream task cannot start. The console only shows:

"Task cannot be started"

There are no additional useful errors in the console.

The affected databases are on the same DB2 server and have the same general configuration as the databases where the tasks are working successfully.

Could someone advise what could cause this behavior for only specific DB2 databases and how we can obtain more detailed diagnostics?

Any guidance on these two issues would be greatly appreciated.

What Makes Someone a Featured Member in the Qlik Community?

I’ve been exploring the Qlik Community recently and noticed the Featured Members section. It made me curious about what actually makes someone stand out enough to be recognized by the community. Is it mainly based on technical knowledge, the number of questions they answer, or the quality of their contributions?

I’m especially interested in learning whether Featured Members are selected because they help other users solve problems, share useful tutorials, participate in discussions, or contribute to the wider Qlik ecosystem. For someone who is still building their knowledge of data analytics and business intelligence, understanding this would be really helpful.

I also spend time exploring data analytics, business intelligence, digital tools, and technology-related topics through websites. I’d love to know whether participating in communities like Qlik can also help people improve their professional knowledge and discover useful resources.

What do you think makes a Qlik Community member truly valuable? Are there any specific achievements, contribution levels, or qualities that usually lead to Featured Member recognition

Hi,

within security rules you can use "like" to evaluate the rule.

Example

user.group like "*text*"

Like works great with a hard coded text.

But is it somehow possible to use it with custom properties?

What I want to do is: Grant every user access if the custom propery is part of the user.group.

E.g. Custom Property = "Finance" and user.group = "CompanyName_Finance_Europe"

Something like this:

user.group like *resource.@CustomProperty* 

I was not able to find any documentation or solution for this, so I am afraid this is not possible?