Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This month, all eyes are on André, whose journey from New Zealand's insurance industry to the heart of London's data community shows exactly the kind of curiosity and drive that makes a great Qlik Community member. A dedicated Qlik customer for years, André brings real, hands-on experience to every thread he touches, and he's not shy about sharing it. We're thrilled to name him our Featured Member for September 2026!
André spent the last decade working in general insurance in New Zealand, starting out in underwriting before moving into BI and data. Most recently, he worked at Ando Insurance, where he worked across Qlik Cloud, Snowflake, and Salesforce, and embedded AI into BI workflows. While there, André had the opportunity to speak at Qlik Connect in 2024, and in 2025, Ando Insurance was recognized with the Qlik Organizational Transformation award at the Qlik Digital Transformation Awards Australia & New Zealand in Sydney.
“Explaining a set analysis expression, a load script pattern, or an automation block to someone else forces me to properly understand it.”
— André
For André, the Community has always been more than a resource, it's where he's worked through some of his toughest Qlik challenges over the years, usually by finding a thread where someone had already hit the same wall. Now, he pays it forward by answering questions himself, and he says he picks up plenty from other people's answers along the way too.
Outside of Qlik, André loves building things just for the fun of it, from a Raspberry Pi dev server to small apps and even a Qlik extension or two. He's also working on learning French (even after two months living in Lyon), and he's an avid tennis fan.
Thank you for bringing your expertise and generosity to the Qlik Community. Please join us in celebrating André as our September 2026 Featured Member, leave a comment below!
Hi All,
I've been trying to upgrade Nprinting Feb 2024 SR1 to SR4, but in most of the after making all the recommended steps, I execute the installer and instead of say "Upgrade" just says "Install".
If I do the install, it creates a new instance of Nprinting along the current install, If I delete the previous version (SR1) and keep SR4, when I restore the repository and start the services, It requires me the licencing again, which I dont have (yet) and I thought it should be automatically.
Please if anyone had the same issue or know what could be I'd really appreciate your help.
Thanks
Hi Experts,
I have dataset looks like below table:
There is another table having columns Region > Zone > Country.
The problem I am facing is that in pivot table I have hierarchy Region > Zone > Country > Shopkeeper. With this hierarchy, my below two codes were working fine
Code1:
Pick(Match(GetObjectDimension(Dimensionality()-1), 'Region', 'Zone', 'Country', 'Shopkeeper'),
Sum(global shop distribution)/sum(Total <region> global shop distribution),
Sum(global shop distribution)/sum(Total <zone> global shop distribution),
Sum(global shop distribution)/sum(Total <country> global shop distribution),
Sum(global shop distribution)/sum(Total <country> global shop distribution),)
code2:
Pick(Match(GetObjectDimension(Dimensionality()-1), 'Region', 'Zone', 'Country', 'Shopkeeper'),
Sum(AGGR(Sum(global shop distribution)/sum(Total <Region> global shop distribution), Region, Zone, Country, Shopkeeper)),
Sum(AGGR(Sum(global shop distribution)/sum(Total <Zone> global shop distribution), Region, Zone, Country, Shopkeeper)),
Sum(AGGR(Sum(global shop distribution)/sum(Total <Country> global shop distribution), Region, Zone, Country, Shopkeeper)),
Sum(AGGR(Sum(global shop distribution)/sum(Total <Country> global shop distribution), Region, Zone, Country, Shopkeeper))
)
As I change the hierarchy to shopkeeper > region > zone > country first code is running properly but second code is showing different answers.
Code1:
Pick(Match(GetObjectDimension(Dimensionality()-1), 'Shopkeeper', 'Region', 'Zone', 'Country'),
Sum(global shop distribution)/sum(Total < Shopkeeper> global shop distribution),
Sum(global shop distribution)/sum(Total <Region> global shop distribution),
Sum(global shop distribution)/sum(Total <Zone> global shop distribution),
Sum(global shop distribution)/sum(Total <Zone> global shop distribution))
code2:
Pick(Match(GetObjectDimension(Dimensionality()-1), 'Shopkeeper', 'Region', 'Zone', 'Country'),
Sum(AGGR(Sum(global shop distribution)/sum(Total <Shopkeeper> global shop distribution), Region, Zone, Country, Shopkeeper)),
Sum(AGGR(Sum(global shop distribution)/sum(Total <Region> global shop distribution), Region, Zone, Country, Shopkeeper)),
Sum(AGGR(Sum(global shop distribution)/sum(Total <Zone> global shop distribution), Region, Zone, Country, Shopkeeper)),
Sum(AGGR(Sum(global shop distribution)/sum(Total <Country> global shop distribution), Region, Zone, Country, Shopkeeper))
)
I need this because I want to get sum of these calculations at above level plus multiplying these with master item of another calculation. I want to fix this AGGR calculating then my problem will get resolve.
If any suggestions of different approaches will be highly appreciated.
Thanks for your attention.
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,
please help me out to find the fields FTD,MTD,YTD.
the date field is FKDAT(taking from sap) and i have linked this with normal Calendar Date as follows
CalendarMaster:
LOAD
Date(FKDAT) AS FKDAT,
Floor(Date(FKDAT)) AS DateNum,
Year(FKDAT) AS Year,
'Q' & Ceil(Month(FKDAT) / 3) AS Quarter,
Month(FKDAT) As Month,
Day(FKDAT) As Day,
Week(FKDAT) As Week
RESIDENT SAP_Data;
how to find FTD,MTD,YTD for (Sum(Sales)) using set expression .
FTD- for the day-1
MTD- for the prevoius month
(if current year is January 2017 the it should be show sum of December 2016).
i have to display FTD,MTD,YTD in Table
Hello Qlik Support Team,
I have a question regarding Qlik Talend Data Integration Data Mart / transformation pipelines.
We have a requirement to execute custom SQL statements before and/or after a Transformation / Data Mart task. One of the use cases is index management — for example, creating an index on a target table after the Transformation / Data Mart step has created the table or populated the table.
For example, we would like to achieve a workflow similar to:
Execute a pre-action SQL statement (if required)
Execute the Qlik Transformation task
Execute a post-action SQL statement, such as:
Create or rebuild indexes
Update statistics
Execute a stored procedure
Perform other target-database maintenance
Is there a supported way in Qlik Talend Data Integration / Qlik Cloud Data Integration to implement such pre- and post-processing SQL hooks for a Data Mart or transformation task?
If there is no direct pre/post hook functionality, what is the recommended Qlik-supported approach for implementing this type of orchestration?
For comparison, I understand that Qlik Compose provides pre- and post-processing functionality that can be used to execute custom SQL around generated ETL/ELT processes. We are looking for an equivalent capability in Qlik Talend Data Integration.
In particular, our use case is to ensure that indexes can be automatically created or maintained on Transformation target tables after the Transformation task creates or refreshes them.
Could you please clarify:
Is there currently a native pre/post SQL hook mechanism in Qlik Talend Data Integration?
what is the recommended approach for executing SQL before or after a Transformation task?
Is there a roadmap item for functionality equivalent to the pre/post processing available in Qlik Compose?
Thank you.
Hi Everyone,
I have 3 tables inside a Tabbed Container in Qlik Sense.
When I export the container to Excel, all 3 tables are exported into separate sheets. However, the table titles are missing in the Excel export.
Is there any way to include the table titles in the Excel export, either at the top of each sheet or as the sheet name?
Any suggestions would be appreciated.
Thanks!
Hello , I have a Button object in Qlik Sense . I want to display a tooltip text when hovering the mouse over the button (for example : display "Mobile" when hovering the Mobile button).
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!
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.