Hello,

I’ve configured a Log Stream task to read from a Microsoft Azure SQL database, along with a replication task that reads from this Log Stream and replicates data to a Databricks Lakehouse (Delta) endpoint.

Among the replicated tables, there is one with about 380 million records and 18 columns, which accumulates between 200,000 and 400,000 changes during the full load, which typically takes several hours.

Over the past few weeks, once the full load of this table completes, the task has been unable to apply the changes to Databricks. Specifically, the task tries to apply the DELETE operations on the table and remains in running state for tens of hours without completing the operation successfully.

The DELETE operation has this form:

DELETE FROM my_database.target_table T
WHERE EXISTS (
    SELECT C.seg1
    FROM my_database.attrep_changes_table C
    WHERE (
        T.primary_key = CAST(C.seg1 AS INT)
        OR (T.primary_key IS NULL AND C.seg1 IS NULL)
    )
    AND C.seq >= 1
    AND C.seq <= 200100
);

We have tried several alternatives to solve the problem, including:

• reducing the change batch size;
• increasing the query timeout of the operations;
• optimizing the large table to make delete operations more efficient;
• replicating only the last 6 months of data for the large table.

Unfortunately, none of these attempts was successful.

However, we verified that the following DELETE operation runs in 30 seconds on Databricks:

DELETE FROM my_database.target_table
WHERE primary_key IN (
    SELECT CAST(seg1 AS INT)
    FROM my_database.attrep_changes_table
    WHERE seq BETWEEN 1 AND 200100
      AND seg1 IS NOT NULL
);

Is it possible to configure the replication task to run DELETE operations using the syntax above?

I understand that Qlik Replicate provides internal parameters to customize the SQL syntax it generates, such as $info.query_syntax.create_table for table creation. Is there an equivalent parameter for DELETE operations? If so, how could we set it so that the task uses the syntax shown above? If no such parameter exists, is there an alternative way to achieve the same result?

Thank you in advance for your support.

Best regards

Hello , I have a Button object in Qlik Sense . I want to display a tooltip text when hovering the mouse over the button (for example : display "Mobile" when hovering the Mobile button).

We're challenging our Qlik Community: put agentic AI to work. 

We saw lots of great posts in our recent Make Your Data Work for AI forum. We’re building on that momentum with a new board focused on the next step: driving real impact with agentic AI.

This is the place to get started with agentic capabilities, try them out, and share your experience with the rest of the Community.

Here's the challenge:

1. Get started. Toggle on Qlik Answers, activate Qlik’s MCP Server, or get started with whichever capability fits your work, and see how easy it really is.
2. Build your first workflow. Identify a use case and put the capabilities to work on a real problem or task.
3. Share your experience. Tell the Community what you learned, what worked, and what surprised you.

Ask questions, share screenshots (obscuring any sensitive data), get ideas, and help your Qlik Community peers on their journeys.

You'll earn NEW Community badges along the way: Agentic AI Adopter when you share your first workflow or use case, and Agentic AI Expert when you share your learnings and results.

Plus, we’ll be awarding some fun surprises and new Qlik swag along the way!  

I am going to retrive metadata of a qlikview files existing in an organization server.
i wanna declare a connection and extrac all thier metadata.
but i didnt find any way from qlikview to expose metadata of thier dashboard and reports.
is there any body who did that?

Is it possible to per default disable the data preview when opening the script editor on a Qlik Sense on Windows installation?

When a developer navigates to the Data Load Editor of an Qlik Sense application then the default view is to see script section to the left, the data connections to the right and the data preview tables in the bottom. Populating these views, sometimes  makes the data editor page use substantial amount of time to fully render it self so it is possible for the developer to do script changes or initiate a reload.

We handle some very large applications and we believe being able to disable the data preview in the load script editor would speed up the rendering of the load script editor page. 

I have not found any documentation on how to set the default state to disable disable the preview. Is it possible to configure Qlik Sense to do this, either on environmental or by app level. 

(The environment is running Qlik Sense November 2024 on multiple nodes)

Hi,
We are facing the issue with context menu after upgrading Qlik Sense Enterprise from November 2025 to May 2026 version.
Users can't export data anymore.
We just tried using different versions of iOS (even the latest one 27) but the problem is still unresolved.
We are using both SAFARI and CHROME browser on iPad 9.
Long-touching a visualization (ex. pivot table) should open the options menu, but it doesn't.
How it could be fixed? @Daniele_Purrone 
Please let me know.
Best Regards

Hi all, good evening,

I need to compare the cumulative sales between a year and the year before. This for many years stored in my database.

The sales had already been normalized by the month of each year.

This is the expression I created to generate the information for each year:

Aggr(RangeSum(Above(Sum(QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])

And this is the generated graphic:

What I need is to created a new graphic that shows, for each year, the % growth between that year vs its last year, using the same rule (acumulated sales for each month).

I have already tried many solutions here in the topics, but I couldn't get the right result.

For exemple: Aggr(RangeSum(Above(Sum(QTY) / Sum({<[SALES YEAR] = {"$(=Only([SALES YEAR])-1)"}>}QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])

Thanks in advance for any help.

Hi everyone,

I am facing a critical security concern regarding Section Access and Binary Loads, and I would like to know if there is a way to prevent it.

The Scenario: I have a base application with Section Access properly applied to restrict data visibility. Another developer user consumes this app's data model using a Binary Load.

The Problem: The issue happens when this developer uses the STORE statement in their script to export the loaded tables into QVD or TXT files. The exported files are created without any access restrictions. The Section Access rules are completely bypassed in the stored data.

The Security Concern: Because of this behavior, a developer can easily extract restricted data into unrestricted files. I consider this a severe security risk and data leakage problem, and I am very concerned about the platform's data governance in this scenario.

My Questions:

1. Is there any way to block, disable, or restrict the use of the STORE command for developers who are using a Binary Load?

2. Are there any configurations, security rules, or best practices at the QMC/Tenant level to prevent this specific type of data extraction?

I understand that we could segregate access using Spaces. However, these developers need to access the data spaces to perform the Binary Load and consume the data model. Even if we restrict their write access to corporate Shared/Data Spaces, they might still be able to STORE the data into their Personal Spaces. How do you handle this architectural dilemma without completely stopping the use of Binary Loads?

Any insights or workarounds to secure this architecture would be greatly appreciated.

Thanks in advance!

Hi,

Thank you