Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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:
Get Straight Table Data
Loop Batch
Loop 2 – Iterate through each row in the batch
Initialize/reset ExcelPayload
Loop 3 – Iterate through the column values of the current row
Append each column value to ExcelPayload
Print ExcelPayload using an Output block
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:
Loop Batch processing or nested loop execution.
The Excel connector's handling of multiple requests.
Concurrent or overlapping Excel API requests.
The Add Rows block processing the payload differently from the Output block.
Excel table insertion or connector retry behavior.
Some issue with the way the payload is passed between batches.
Questions
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?
Can Qlik Automations execute Excel insertion requests out of order or process overlapping requests when nested loops are used?
Is there any recommended delay, batching approach, or sequential execution method for inserting multiple batches into an Excel table?
What is the best way to debug the exact payload received by the Excel connector for each execution?
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.
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"
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:
Trigger: Triggered Automation (Start block set to Webhook/Triggered).
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.
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:
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?
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!
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?
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 | PROMO03And the sales table contains:
ArticleCode | SaleDate | Quantity
------------|------------|---------
A001 | 2026-09-07 | 2
A001 | 2026-09-08 | 1
A002 | 2026-09-15 | 5I 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 | PROMO02A 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 | PROMO02instead of:
A001 | 2026-09-07 | PROMO01
A001 | 2026-09-07 | PROMO02The 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!
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? 🙂
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:
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.
Plus, we’ll be awarding some fun surprises and new Qlik swag along the way!
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
Qlik is a Leader in the IDC Events/Global Events MarketScape: Worldwide Data Intelligence Platform Software 2026 Vendor Assessment
Here’s your agentic AI readiness check. (Got Qlik? You're closer than you think.)
Set your course for six weeks of expert-led sessions on data, analytics, and AI — available on demand.
Built for the builders: Modern data engineering is AI powered — and engineer led.
The pilot-to-production gap is real. From fragmented data to governance gaps Qlik and AWS break down what’s holding your enterprise AI back — and how to solve them.
Your journey awaits! Join us by Logging in and let the adventure begin.