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: 
  • 279,363 members
  • 8,228 online
  • 2,052,140 posts
  • 155,124 Solutions
Announcements
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here

Welcome to Qlik Community

Recent Discussions

  • forum

    Water Cooler

    Data Voyagers: Manage Qlik Automations with Claude and Qlik MCP Server

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

    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

     

    Show Less
  • forum

    Integration, Extension & APIs

    Frequent Extesnions removal from QMC

    Hello, we are using Qliksense Enterprise version 14.254.6. But some extensions like multi kpi, input variable, date picker are getting removed automat... Show More

    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.

     

    Show Less
  • forum

    Qlik Automate

    Send a simple multi-page report by email - Create Report and Add Sheet To Report

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

    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!

    Show Less
  • forum

    Qlik Replicate

    best practice for Drop/Recreate tables source MSSQl

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

    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?

    Show Less
  • forum

    Management & Governance

    On Qlik Sense for Windows release May 2026 - Published apps don't show the optio...

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

    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

    Show Less
  • forum

    Qlik Replicate

    Start task from timestamp in Qlik Replicate for DB2 LUW

    Qlik Replicate: May 2025 (2025.5.0.247)Source: IBM DB2 LUW 11.5.9Target: IBM DB2 (ODBC)Architecture: Log Stream Staging → Downstream CDCBackgroundWe a... Show More

    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.

     

    Show Less
  • forum

    Featured Members

    What makes someone a Featured Member in the Qlik Community?

    What Makes Someone a Featured Member in the Qlik Community? I’ve been exploring the Qlik Community recently and noticed the Featured Members section. ... Show More

    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

    Show Less
  • forum

    Management & Governance

    Security Rule to Compare two custom properties with match (or like)

    Hi,within security rules you can use "like" to evaluate the rule.Exampleuser.group like "*text*"Like works great with a hard coded text.But is it some... Show More

    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?

    Show Less
  • forum

    Talend Studio

    tSalesforceBulkExec: missing salesforce_id / error in output

    Hello, We upgrade this summer our Talend Cloud Studio from 7.3.1 to 8.0.1R2026-06. I'm trying to create a new job to put data in Salesforce using the ... Show More

    Hello,

    We upgrade this summer our Talend Cloud Studio from 7.3.1 to 8.0.1R2026-06.

    I'm trying to create a new job to put data in Salesforce using the tSalesforce bulk components, and specifically the tSalesforceBulkExec.

    I put it on the designer, select the existing connection, choose the module to update and import the schema from my tSalesforceOutputBulk in the "Schema".

    When I use the MAIN and Reject output of the tSalesforceBulkExec (or check the "Schema MAIN" & "Reject Schema" in Basic Settings), I have the input schema, but the following automatic columns are missing : 

    • MAIN : salesforce_id & salesforce_created
    • Reject : error

    Is this a standard behavior or a regression ?

    I try to click on the "Guess schema", but I got compilation error for this specific action (the job compile without error)

     

    Edit Sept 07 :

    It also seems that it does not handle well when one/some fields contains lines returns. When everythings was alright in 7.3.1

    We generate the file with a tFileOutputDelimited (with a specific configuration) and use the API Bulk V2 to avoid this problem, but the global values NB_SUCCESS / NB_REJECT / NB_LINE aren't set in V2.

     

    Edit Sept 08

    The issue with the line return has been handle in the R2026-08 Studio patch, according to the associate release note update.talend.com/Studio/8/updates/R2026-08/PATCH_RELEASE_NOTE.html

    • QTDI-3147 - tSalesforceOutputBulk: double-quote characters in field values not escaped in generated CSV after R2026-06 TCK migration

     

    I have been able to automatically retrieve the technical output columns be clicking on the "Guess schema" bouton. Its more or less indicate in the documentation, section "Limitation" : tSalesforceBulkExec | Talend Components for Jobs Help

     

    It lets us with "only" the global var issue when we are in Bulk V2, which isn't the subject anymore. I close this topic as resolve.

    Show Less
  • forum

    Qlik Replicate

    Change Uni-Directional Tasks to Bi-Directional in Qlik replicate

    Hi ,I have created 100+ uni-directional tasks for data replication requirement. Now there is little change in requirement, I also need to replicate da... Show More

    Hi ,

    I have created 100+ uni-directional tasks for data replication requirement. Now there is little change in requirement, I also need to replicate data back to source in same tables to keep data sync on both sides. I want to change my tasks to bi-directional. Is there any way I could change exported JSON and then import so tasks become bi-directional. Or will need to create tasks again ?

    Please if someone could help me in this.

    Thank you

    Show Less
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image