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: 
  • 280,078 members
  • 12,699 online
  • 2,052,438 posts
  • 155,140 Solutions
Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work

Welcome to Qlik Community

Recent Discussions

  • forum

    Administering and Monitoring

    How integrate TAC 8 with Azure AD (entra id)

    Hi,I want to integrate for authentication the talend Administration Center with Azure AD (entra id). What steps could be do. thanks.
  • forum

    Mobile

    Need clarity: Qlik sense mobile with Intune without KCD

    Hi @Andrew_Kruger,Hope you are doing well. We are trying to enable Qlik sense mobile is our organization. We tried to enable it via Azure with Kerbero... Show More

    Hi @Andrew_Kruger,

    Hope you are doing well. We are trying to enable Qlik sense mobile is our organization. We tried to enable it via Azure with Kerberos. Since it is not allowed to "Use any authentication method" by our security team, we are unable to use this option.

    So we are trying to connect mobile with Qlik sense enterprise via internet with proper security architecture (Firewall, DMZ, Load balancer, DDOS protection). Qlik sense mobile will have to managed via Microsoft Intune. (Without KCD in AD option)

    Currently I am struck with below questions and couldnot able to find appropriate clarity. If you can please help to throw some light on these, it will be really appreciated and help other in future.

    1. For our browser hub, we are using Azure SAML authentication. Planning to use Azure SAML similarly for mobile authentication with different VP. in this case, how the mobile app authentication works? will the users still be asked to enter username and password? how this works?

    2. Currently our hub url is internal inside organization's network. Internal certificate is configured in the Proxy server. If we enable mobile via internet, we will require a public url and public certificate. since the proxy is already configured with internal certicate, how can we configure the public certificate in the same proxy?

     

    Show Less
  • forum

    Qlik Automate

    Extract data from a Qlik Sense straight table and insert it into an Excel table ...

    Hi everyone,I am working on a Qlik Sense Automation workflow to extract data from a Qlik Sense straight table and insert it into an Excel table using ... Show More

    Hi everyone,

    I am working on a Qlik Sense Automation workflow to extract data from a Qlik Sense straight table and insert it into an Excel table using the Microsoft Excel – Add Rows To Excel Worksheet Table block.

    I am processing the data in batches using nested loops, but I am facing an inconsistent issue with the second batch onward.

    Workflow Structure

    My current workflow is approximately:

    1. Get Straight Table Data

    2. Loop Batch

    3. Loop 2 – Iterate through each row in the batch

    4. Initialize/reset ExcelPayload

    5. Loop 3 – Iterate through the column values of the current row

    6. Append each column value to ExcelPayload

    7. Print ExcelPayload using an Output block

    8. Add Rows To Excel Worksheet Table

    The Excel table contains 26 columns, and the payload is already in a 2D array format, as required by the Excel block.

    Issue

    The first batch is inserted into Excel correctly.

    However, from the second batch onward, I am experiencing the following problems:

    • The first batch is added correctly.

    • In the second batch, the Output block prints data, but the rows that appear in Excel are different from what is printed in the Output.

    • Sometimes, Excel inserts random blank rows.

    • The issue does not occur consistently; it appears intermittent.

    • The Output payload appears to be reset correctly, and the data printed in the Output looks correct.

    • The Rows input of the Excel block is mapped to ExcelPayload.

    • The Excel block is configured with the correct Drive ID, Item ID, Worksheet, and Table ID.

    For example:

    Output block:

    [
    ["4725", "ABD", "TITANIUM", "..."],
    ["3847", "WERE", "BITUMEN", "..."]
    ]

    However, the rows inserted into Excel do not always correspond to the same rows shown in the Output. In some cases, blank records are also inserted.

    What I have already checked

    • ExcelPayload is reset for each row.

    • The payload is already a 2D array.

    • The Output block shows the expected data.

    • The Excel Rows field is mapped to ExcelPayload.

    • The first batch is processed correctly.

    • The issue starts intermittently from the second batch onward.

    I am not sure whether this is related to:

    1. Loop Batch processing or nested loop execution.

    2. The Excel connector's handling of multiple requests.

    3. Concurrent or overlapping Excel API requests.

    4. The Add Rows block processing the payload differently from the Output block.

    5. Excel table insertion or connector retry behavior.

    6. Some issue with the way the payload is passed between batches.

    Questions

    1. Has anyone experienced a situation where the Output block displays the correct payload, but the Excel Add Rows To Excel Worksheet Table block inserts different rows?

    2. Can Qlik Automations execute Excel insertion requests out of order or process overlapping requests when nested loops are used?

    3. Is there any recommended delay, batching approach, or sequential execution method for inserting multiple batches into an Excel table?

    4. What is the best way to debug the exact payload received by the Excel connector for each execution?

    5. Could the Microsoft Excel connector insert blank rows intermittently when multiple Add Rows requests are executed against the same table?

    Any guidance on how to troubleshoot this would be greatly appreciated.

    Thank you.

    Show Less
  • forum

    Qlik Replicate

    Why is the "root_url" configuration made with "Repuictl.exe" not being applied?

    Hello everyone, My Qlik Replicate version is 2024.5.0.563. Earlier, I used Repuictl.exe to configure the root_url parameter and changed the default v... Show More

    Hello everyone,

    My Qlik Replicate version is 2024.5.0.563.

    Earlier, I used Repuictl.exe to configure the root_url parameter and changed the default value from "attunityreplicate" to "abc" (command shown below). However, after restarting the Qlik Replicate service, the URL still contains "attunityreplicate" instead of "abc".

    Could you please help me understand what might be causing this issue? Is there any additional configuration or procedure required for the root_url setting to take effect?

    Thank you.

    Repuictl.exe configuration set --root_url "abc"

    Show Less
  • forum

    Integration, Extension & APIs

    Issue with Slack Event Subscriptions Verification via Triggered Automation (HTTP...

    Hi Qlik Community,I am attempting to integrate Qlik Cloud Automation with Slack Event Subscriptions to handle @mention queries using Qlik Answers.Howe... Show More

    Hi Qlik Community,

    I am attempting to integrate Qlik Cloud Automation with Slack Event Subscriptions to handle @mention queries using Qlik Answers.

    However, I am stuck at the Slack Event Subscriptions url_verification step and unable to achieve Verified status.

    Setup Overview:

    1. Trigger: Triggered Automation (Start block set to Webhook/Triggered).

    2. Verification Logic:

      • Condition block checks if Start > body > challenge is not empty.

      • YES branch: Routes directly to an Output block returning Start > body > challenge, immediately followed by a Stop block.

    3. Authentication:

      • Slack Event Subscriptions does not allow sending custom HTTP headers (such as -H "X-Execution-Token: <TOKEN>").

      • Therefore, I am appending the token as a query parameter in Slack's Request URL: https://<tenant>[.qlikcloud.com/api/v1/automations/](https://.qlikcloud.com/api/v1/automations/)<automation-id>/actions/execute?X-Execution-Token=<TOKEN>

    What Works:

    • Sending a POST request via curl with the token in the HTTP Header works perfectly and returns the challenge string: curl -X POST "<URL>" -H "X-Execution-Token: <TOKEN>" -H "Content-Type: application/json" -d "{\"type\": \"url_verification\", \"challenge\": \"test_123\"}"

    The Problem:

    • When testing with query parameter authentication (which Slack relies on), the request fails with an HTTP 403 Forbidden error: {"errors":[{"code":"HTTP-403","title":"No permission.","detail":"You don't have sufficient permissions to access this resource."}]}

    • We confirmed this 403 Forbidden response using Google Apps Script / UrlFetchApp when sending the token via query parameter (?X-Execution-Token=<TOKEN>).

    Questions:

    1. Does Qlik Cloud Automation support executing Triggered Automations when the X-Execution-Token is passed via URL query parameters (?X-Execution-Token=...) instead of HTTP Headers?

    2. Is there a specific setting or URL format required to allow Slack Event Subscriptions to authenticate successfully without custom HTTP headers?

    Any advice or workarounds would be greatly appreciated. Thank you!

    Show Less
  • forum

    Women Who Qlik

    The Power of Feedback

    Feedback can be one of the most powerful tools for growth when handled effectively. Today, we’ll explore how to professionally respond to negative fe... Show More

    Community Forum Banner_Career_Growth_Series (2).png

    Feedback can be one of the most powerful tools for growth when handled effectively. Today, we’ll explore how to professionally respond to negative feedback, turning challenging moments into opportunities for development. You’ll learn practical strategies for communicating with confidence, and using feedback as a catalyst for stronger leadership, improved performance, and continuous growth.

     

    Related Content: 

    Article: How to Professionally Respond to Negative Feedback at Work: A Comprehensive Guide

    Article: The Power Of Feedback: A Catalyst For Growth In Leadership And Employee Development

    TedTalk: TedTalks: The secret to giving great feedback

     

    Share your thoughts in the comments: What strategies do you use to share feedback with your team?

    Show Less
  • forum

    App Development

    Preventing duplicate records with IntervalMatch in QlikView

    Hi everyone,I'm working on a QlikView 12 application where I need to match sales transactions with promotional periods.For each sale, I need to identi... Show More

    Hi everyone,

    I'm working on a QlikView 12 application where I need to match sales transactions with promotional periods.

    For each sale, I need to identify the promotion that was active for that article on the transaction date.

    The promotion table contains something like:

    ArticleCode | StartDate  | EndDate    | PromotionCode
    ------------|------------|------------|--------------
    A001        | 2026-09-01 | 2026-09-10 | PROMO01
    A001        | 2026-09-05 | 2026-09-15 | PROMO02
    A002        | 2026-09-01 | 2026-09-30 | PROMO03

    And the sales table contains:

    ArticleCode | SaleDate   | Quantity
    ------------|------------|---------
    A001        | 2026-09-07 | 2
    A001        | 2026-09-08 | 1
    A002        | 2026-09-15 | 5

    I am currently using IntervalMatch to associate the sales date with the promotional interval.

    The problem occurs when two promotional intervals for the same article overlap.

    For example:

    A001 | 2026-09-01 | 2026-09-10 | PROMO01
    A001 | 2026-09-05 | 2026-09-15 | PROMO02

    A sale on 2026-09-07 matches both promotions, so the sales record is duplicated.

    This is expected behavior from IntervalMatch, but in my case I need to apply a business rule so that each sale is associated with only one promotion.

    For example, if PROMO02 has priority over PROMO01, I would want:

    A001 | 2026-09-07 | PROMO02

    instead of:

    A001 | 2026-09-07 | PROMO01
    A001 | 2026-09-07 | PROMO02

    The real script is more complex because there are several additional fields involved, but the basic problem is the same.

    What would be the recommended QlikView approach to handle this?

     

    Thank you!

    Show Less
  • forum

    Water Cooler

    Data Voyagers: Qlik Cloud's Visual Task Chain Viewer: A Faster Way to Debug Your...

    Hi everyone!I’m back again to recommend a video by @marksouzacostafrom Data Voyagers about the Visual Task Chain Viewer in Qlik Cloud.For anyone manag... Show More

    Hi everyone!

    I’m back again to recommend a video by @marksouzacostafrom Data Voyagers about the Visual Task Chain Viewer in Qlik Cloud.

    For anyone managing multiple chained reloads, this looks like a huge time-saver when it comes to diagnosing failures within those chains. It turned out to be the perfect solution for a project I’m currently working on that requires this type of management.

    Check out the full step-by-step video from Data Voyagers here: https://www.datavoyagers.com

    Youtube: https://www.youtube.com/watch?v=GvG_wqvMlZ0

    Has anyone else been using this tool? 🙂

    Show Less
  • forum

    Put Agentic AI to Work

    Qlik Community Challenge: Put Agentic AI to Work

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

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

    Badges-Community-Agentic-adopter (1).pngBadges-Community-Agentic-Expert (2).png

     

     

     

     

     

     

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

     

    Show Less
  • forum

    Qlik Replicate

    NCLOB to VARChar

    Hi Sir, We have a replica from MS SQL Server to Snowflake with numerous transform: NCLOB to Varchar.  Datatype in Source db is NVARCHAR (max) hence NC... Show More

    Hi Sir,

    We have a replica from MS SQL Server to Snowflake with numerous transform: NCLOB to Varchar.  Datatype in Source db is NVARCHAR (max) hence NCLOB in Qlik, but client in Snowflake uses different lengths for Varchar, e.g., a target table has one column Varchar(1000) and the other column Varchar(5000).  How can we achieve that in Qlik replication since Qlik doesn't support table Transform for NCLOB?

    Thanks,

    Richard 

    Show Less
Leaderboard

Qlik community MVPs

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

mvp-banner-side-image