Hi All,

Greetings!

I have Date dimension in Qliksense straight table, and measures are Production, Sales and Consumption of Stock Material for Inventory in metric tons....

I am getting all values correct. For opening stock column, I have written the formula in the table expression as 

if(Date=min(total Date), Sum([Initial Stock (MT)])
,
RangeSum(
Above((
Sum([Initial Stock (MT)]) + Sum([VCM Arrival (MT)])
- Sum([Consumption SPVC (MT)])
- Sum([Consumption PPVC (MT)])),
1,
RowNo()
)
))

which is giving correct values.. But, I need to execute the same in Qlik backend script. I tried this :

Kindly Help!!

Thanks in advance!!

Niranjana

Pessoal, estou com a seguinte situação, tenho uma aplicação que possui diversos gráficos e indicadores onde consigo demonstrar valores de receita e de custo por responsável financeiro de contratos, porem ao solicitar ao answers um top 20 dos responsáveis financeiros para valores de resultado negativo ( receitas - custos) para todos os responsáveis as receitas são consideradas como sendo zero, o que não é verdade, em uma das análises realizadas o answers citou haver um problema de modelagem de dados.

I have a task that perform a full load once a month. In the past, I have experienced multiple instances where the EC2 instance hosting replicate task was restarted in the middle of the task execution as part of the scheduled monthly maintenance.

When this happens, once the EC2 instance comes back online, the replicate task automatically restart from the beginning. As a result, duplicate records are inserted into the target tables for the data that had already been loaded before the interruption.

To prevent this, I configured abnormal_count": 0 under recoverable_error_behavior and tested the scenario by simulating and unexpected restart. However, even with abnormal_count set to 0, the task still restart automatically after the EC2 instance is back online.

Is there a way to prevent the task from automatically restarting after the EC2 reboot, or is there a recommended approach to handle this scenario and avoid duplicate data? Any suggestion would be greatly appreciated.

Hi everyone,

I am testing the official Qlik Cloud MCP server with several AI clients and have encountered a schema validation issue that appears to affect Gemini Enterprise specifically.

Environment and configuration:

• Official Qlik Cloud MCP endpoint:
  https://<TENANT>.<REGION>.qlikcloud.com/api/ai/mcp
• Qlik Cloud EU region
• Authentication configured with an OAuth Web client https://community.qlik.com/t5/Official-Support-Articles/How-to-connect-Qlik-MCP-to-Gemini-Enterprise/ta-p/2552930
• Gemini Enterprise web interface

The MCP configuration in Gemini Enterprise completes successfully. The connection test also succeeds, with no warnings or schema validation errors.

However, when I submit a request involving a Qlik application from the Gemini Enterprise web interface, Gemini understands and plans the request but stops before invoking the MCP tool.

The following error is returned:

LLM RPC failed: Unable to submit request because

qlik_create_measure functionDeclaration

parameters.colorSpec.gradient schema didn't specify

the schema type field.

[INVALID_ARGUMENT]

The Gemini Enterprise diagnostic information confirms that the failure occurs during a model plan step. For example:

{
  "createTime": "2026-07-15T10:15:48.570356021Z",
  "planStep": {
    "role": "MODEL",
    "parts": [
      {
        "text": "LLM RPC failed: Unable to submit request because qlik_create_measure functionDeclaration parameters.colorSpec..."
      }
    ]
  }
}

This suggests that Gemini Enterprise performs schema validation when submitting the available MCP tool declarations to the model. It appears to reject the schema because parameters.colorSpec.gradient does not contain an explicit type field.

The same schema validation problem also occurs with qlik_update_measure.

At present, Gemini Enterprise is the only tested client that rejects these tool declarations.

Other MCP clients may accept or normalize the same schema, while Gemini Enterprise appears to require an explicit type for nested schema nodes.

As a workaround, if I disable both qlik_create_measure and qlik_update_measure, the Qlik MCP integration in Gemini Enterprise appears to work correctly.

Has anyone else tested the official Qlik MCP server with Gemini Enterprise and encountered the same issue?

I would also be interested to know whether anyone has found a different workaround.

Thanks in advance for sharing your experience or any possible workaround

Cristian

Hi Team,

We have a Qlik mashup which we have developed and there is an export button though which we are exporting table to PDF. Currently it is exporting single page pdf. There is a requirement to generate multi page export (new feature for export to pdf in SaaS Straight tables). We are using Qlik Embed technology. Has someone implemented multi page export to pdf? Can you please share reference code.

Hi everyone,
I'm currently working on a Qlik PixelPerfect report and would like users to be able to add commentary directly within the app and have that commentary included in the generated report.
What I've tried so far:

Added a Variable Input Box to the app.
Entered a comment into the variable.
Added the variable to the PixelPerfect report template.

When I preview the report manually, the comment is displayed correctly in the report.
However, when the app is reloaded and the report is generated automatically and distributed via email, the comment is not included in the report attachment.
I'm wondering if variable values entered by users are only stored for the current session and therefore not available during automated report generation.
Has anyone implemented user-entered comments in PixelPerfect reports before?

What's the best way to persist the commentary so it's available during scheduled report generation?
Should I be storing comments in a data source (QVD, database, writeback table, etc.) instead of using a variable?
Are there any specific PixelPerfect Reporting limitations I should be aware of?

Any guidance or examples would be greatly appreciated.
Thanks in advance!

Mikael is a familiar face in the Qlik Community for those who are on it often, regularly contributing through insightful questions and helpful responses to other members. He is based in Halle, near Brussels, Belgium, and he has been a part of the community for over ten years now.

As a Business Intelligence Coordinator at AZ Sint-Maria Halle, a local hospital, Mikael’s work combines data and real-world decision making. His role centers around turning operational, clinical, and financial data into meaningful insights, on dashboards in Qlik, so that his colleagues can better understand activity, performance, and processes across the hospital. He enjoys “digital transformation projects, process improvement, and finding practical ways to make complex data easier for non-technical audiences.”

Mikael’s journey with Qlik began during his time at Agilos, a Belgian company that specialized in business intelligence and data analytics. He expressed how “that experience gave me a strong foundation in Qlik and helped shape the way I look at data: not just as reports or numbers, but as practical tools that support better decisions.”

He values the Qlik Community because of the quality of learning that it offers. It is a place to find innovative ideas, learn from real problems that others are solving (sometimes problems he did not even know he had yet), and discover approaches he may not have considered on his own. Staying connected also helps him keep up with the latest Qlik news, product updates, and tips from people using Qlik in different environments. Mikael does not only stay up to date on the platform, but he contributes to discussions and offers his insights.

Outside of work, Mikael enjoys spending time with his family, walking his dog, and playing padel. All these things help him “disconnect, stay active, and recharge.”

Mikael, thank you for your continued contribution and engagement in the Qlik Community. Please join us in celebrating Mikael as our July 2026 Featured Member and leave a comment below!

@Jamie_Gregory @mikaelsc