Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 277,013 members
  • 5,790 online
  • 2,051,129 posts
  • 155,033 Solutions
Announcements
Data Works for AI is here - Join the discussion and enter to win a pair of Qlik kicks: Join the Conversation!

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Rolling Inventory/Stock

    Hi All,Greetings!I have Date dimension in Qliksense straight table, and measures are Production, Sales and Consumption of Stock Material for Inventory... Show More

    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....

    niranjana_0-1783751313959.png

     

    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 :

     

    If(
     
    RowNo() = 1,
    [VCM Arrival (MT)] - [Consumption SPVC (MT)],
    Peek('Final_Stock') + [VCM Arrival (MT)] - [Consumption SPVC (MT)]
    ) as Final_Stock
     
    But its giving me all 0 values for Final_Stock...... 
     
    The logic for Current Stock (Opening stock column) is : for first day, Current Stock = Initial stock, from next day onwards, Stock for current date = [Previous day Stock + Previous Day VCM Arri (if it exists)] - (Daily consumption of previous day)

     

     

    Kindly Help!!

    Thanks in advance!!

    Niranjana

     

     

    Show Less
  • forum

    Qlik Answers

    QLIK ANSWERS X APP QLIK CLOUD (MODELO DE DADOS)

    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... Show More

    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.

    Show Less
  • forum

    Qlik NPrinting

    What is N-Printing  where we use give me an example

    Hi AllI am new to QlikviewWhat is N-Printing  where we use give me an exampleplz help.
  • forum

    Qlik Automate

    Start automation from automation

    Hi all,is it possible to start an automation "B" at the end of another automation "A" ?And if it is: How would i do it ?Thanks for sme help! 
  • forum

    Qlik Replicate

    Task Restart After EC2 Restart or Crash

    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 ... Show More

    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.

    Show Less
  • forum

    App Development

    Unexpected MERGE behavior: UPDATE becomes INSERT after CONCATENATE

    Hi everyone,I am trying to understand an unexpected behavior of MERGE during a normal reload. In the example below, the first MERGE works as expected ... Show More

    Hi everyone,

    I am trying to understand an unexpected behavior of MERGE during a normal reload. In the example below, the first MERGE works as expected and updates an existing row. Then I add another row to the same target table using a regular CONCATENATE. After that, I run another MERGE with operation U for the newly added row.

    Although the row already exists in the target table, Qlik reports the operation as an insert rather than an update.

    Here is a minimal example:

    Target:
    LOAD *
    INLINE [
        Key1, Key2, Attr
        1, p1, a
    ];
    
    
    // Key 1 / p1 already exists.
    // This is processed as an update, as expected.
    MERGE ON Key1, Key2 CONCATENATE (Target)
    LOAD
        'U'  AS Operation,
        1    AS Key1,
        'p1' AS Key2,
        'x1' AS Attr
    AUTOGENERATE 1;
    
    
    // Add a new row using a regular CONCATENATE.
    CONCATENATE (Target)
    LOAD
        2    AS Key1,
        'p1' AS Key2,
        'b'  AS Attr
    AUTOGENERATE 1;
    
    
    // Key 2 / p1 now exists in Target.
    // I expected this to be processed as an update.
    MERGE ON Key1, Key2 CONCATENATE (Target)
    LOAD
        'U'  AS Operation,
        2    AS Key1,
        'p1' AS Key2,
        'x2' AS Attr
    AUTOGENERATE 1;

    The reload log shows:

    First MERGE:
    Merged updates: 1
    Merged inserts: 0
    Merged deletes: 0
    
    Second MERGE:
    Merged updates: 0
    Merged inserts: 1
    Merged deletes: 0

    MergeUpdate_insert.jpg

    I expected the second result to be:

    Merged updates: 1
    Merged inserts: 0

    The row with Key1 = 2 and Key2 = 'p1' is already present in Target before the second MERGE, but the U operation is still counted as an insert.

    Is this expected behavior during a normal reload?

    Does MERGE only recognize records that existed before the first MERGE statement? Or is mixing regular CONCATENATE statements with subsequent MERGE statements against the same table unsupported?

    I could not find this specific behavior in the documentation, so any explanation would be appreciated.

    Qlik Sense version: November 2025

    Thanks!

    Show Less
  • forum

    Integration, Extension & APIs

    Schema validation issue with Qlik MCP in Gemini Enterprise: qlik_create_measure ...

    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 aff... Show More

    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:

    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

    Show Less
  • forum

    Integration, Extension & APIs

    Mashup - Multi Pge Export functionality via Qlik Embed Technology

    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 export... Show More

    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.

    Show Less
  • forum

    Reporting Service & Alerting

    How to include user-entered commentary in an automatically generated Qlik PixelP...

    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 tha... Show More

    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!

    Show Less
  • forum

    Water Cooler

    High Five - July 2026, Mikael Scorielle

    Mikael is a familiar face in the Qlik Community for those who are on it often, regularly contributing through insightful questions and helpful respon... Show More

    mikael.jpg

    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 

    Show Less
Leaderboard

Qlik community MVPs

Qlik Community MVPs — trusted experts driving collaboration, learning, and innovation.

mvp-banner-side-image

Customer Story

Data Drives the Reconstruction of an Entire State

Data Restores Confidence: How SEFAZ-RS Used Qlik to Support the Rebuilding of a State.

Customer Story

Qlik platform helps structure an analytics ecosystem to support diagnostic medicine and healthcare.

AFIP revolutionizes management, optimizes resource allocation and strengthens data-driven culture

Customer Story

Hapag-Lloyd Enables Smart Decisions With Qlik

Global container shipping giant delivers data transparency to enable confident decision-making and operational efficiency.

Customer Story

Students See Data Come to Life With Qlik Academic Program

Qlik turns raw data into valuable learning experiences, empowering both students and faculty at TTUHSC.

Customer Story

MillerKnoll Unifies Data with Qlik Talend

MillerKnoll partnered with Qlik Talend® data solutions to unify data across its diverse systems, accelerating critical processes and nearly eliminating data integration issues organization-wide.

Customer Story

Radiall Embraces the Cloud and Improves Operational Efficiency

Migration to Qlik Cloud Analytics optimizes analytics applications within months.

Customer Story

French Ministry of Armed Forces Develops a Data-Centric Culture

With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.

Your Place, Your People

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Qlik en México

Qlik en México

Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.

All are welcome

Hello from Japan

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Parlons Données

Parlons Données

Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.

open to all

AI Reality Tour

Zurich

Join data and AI leaders in Zurich on June 10, 2026 to learn how to scale AI and drive real enterprise impact.