Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
got the following requirement:
the user has to select one fiscal year
Current fiscal year is 2026
if the user selects 2026 or above
then the chart has to display Budget Amount
but is the user selects any fiscal year before 2026 then chart should display Actual Amounts
I wrote the below expression:
sum
(
{
<scenario={actual},fiscal_year*={"<2026"}>
+
<scenario={budget},fiscal_year*={">=2026"}>
}
amount)
but some suggest that I write the following:
sum({<scenario={actual},fiscal_year*={"<2026"}>}amount)
+
sum({<scenario={budget},fiscal_year*={">=2026"}>}amount)
which approach has better performance
Hi Qlik Community,
The new Model Context Protocol (MCP) Server is now available in Qlik Cloud! This is a fantastic new capability that allows us to standardize how we connect AI models to our Qlik data.
To help everyone get started, I've recorded a complete, step-by-step video tutorial on how to enable, configure, and connect the Qlik MCP Server to Claude Desktop.
📺 Watch the video tutorial here: https://youtu.be/eUo0y8j3ITU
The video covers:
Enabling the AI features in the Qlik Cloud Tenant.
Creating a Qlik MCP permission and assign users.
Adding Qlik MCP Connection to Claude Desktop
Authenticating and testing the Claude Connection to Qlik MCP Server
For a written companion to the video, you can also check out the full article on the Data Voyagers blog here:
https://www.datavoyagers.net/post/qlik-mcp-server-is-here-enable-configure-it-with-claude
I'm excited to see what use cases you all come up with for this integration. Let me know your thoughts in the comments!
Regards,
Mark Costa
This tool is being deprecated, updates will be received during 2026, but thenceforth be considered deprecated.
The Qlik Sense Enterprise Scalability Tools (QSEST) are used to create and run load and performance tests towards Qlik Sense Enterprise on Windows (QSEoW).
Included parts are:
Downloadable files can be found here:
📎 Qlik Sense Enterprise Scalability Tools
Qlik Sense documents to help analyze result and log files can be found here :https://community.qlik.com/docs/DOC-15451
Change log
v1.14.1
bugfixes
v1.14.0
v1.13.0
v1.12.0
Your use of Qlik Sense Enterprise Scalability Tools will be subject to the same license agreement between you and Qlik for your Qlik Sense License. Qlik does not provide maintenance and support services for the Qlik Sense Enterprise Scalability Tools, however please check QlikCommunity for additional information on use of these products.
Hi Qlik Community,
¡IMPORTANT!
If you are on QAP and leverage anonymous authentication, do NOT upgrade to May 2026 Initial Release.
We have upgraded one of our TEST environments and noticed this issue:
even if the Virtual Proxy is configured to Allow Anonymous Users, they are being prompted for authentication.
So, please check your virtual proxy configuration before upgrading, or wait for the fix.
The Virtual proxies that are configured as Always anonymous users are working as expected.
@Giuseppe_Novello | @Sonja_Bauernfeind | @Ray_Strother
@Eduardo_Monteiro | @SergioProba | @kauenascimento | @AnaSilva
Ashleigh Chapman (CEO, Engage Together), @GSTAMP (Associate Director, Qlik Center of Excellence, Raymond James), and Ruthann Wry (Chief People Officer, Qlik) get candid and vulnerable at Qlik Connect 2026, sharing the career experiences that shaped who they are today.
Their conversation offers powerful takeaways we can all learn from:
Want to hear more from these inspiring women? Dive deeper into their stories in the blog and share your own career growth tip in the comments!
Hello, community.
Does anyone else have the same issue where, when creating an OLE DB connection via Data Manager to a SQL Server database, after successfully testing the connection, it does not list the databases? When creating the same connection via Data Load Editor, this same behavior does not occur.
Qlik Sense Enterprise Client-Managed May 2025
Data Manager:
Data Load Editor
Regards,
Marco
I'm running using the QlikSenseCLI, but I still get the error
"Get-QSAbout : Cannot convert type 'System.Management.Automation.PSObject' to 'string'
At line:2 char:12
+ $QSAbout = Get-QSAbout
+ ~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Get-QSAbout], RuntimeBinderException
+ FullyQualifiedErrorId : Microsoft.CSharp.RuntimeBinder.RuntimeBinderException,QlikSenseCLI.GetQSAbout"
This work:
Invoke-QSGet "/qrs/about"
SchemaPath : About
BuildVersion : 31.62.0.0
BuildDate : 5/8/2026 18:23:36 PM
DatabaseProvider : Devart.Data.PostgreSql
NodeType : Central
SharedPersistence : True
RequiresBootstrap : False
SingleNodeOnly : False
ExtensionData :
I'm using the QlikSenseCLI from Program Files\Qlik\Sense\Tools\QlikSenseCLI
Look like:
was anyone able to generate the 3 files mentionned in the article https://help.qlik.com/en-US/sense-admin/May2026/Subsystems/DeployAdministerQSE/Content/Sense_DeployA...
at this time i only get the "QlikObjecScanReport.csv"
QlikObjectScanOutput.parquet: Contains information about all visualizations used in all apps of the installation.
QlikObjectScanExtensionStatus.parquet: Contains information about all extensions available in the Qlik Sense installation and their deprecation status.
QlikObjecScanReport.csv: Contains meta data, including time stamp of the scan.
any ideas?
@Eduardo_Monteiro thanks for suggesting
but this gets me an error when running the ImportQlikSenseCLIModule.ps1
similar error when running the AddParquetExtentionWhitelistTable.ps1
In many dashboards, a KPI is simply a large, highlighted number; a subscript, a green or red arrow, etc. When used properly, it allows dashboard users to identify the most relevant data at a glance.
While building a dashboard to monitor facilities, I came up with the idea of giving a KPI a different look by using Qlik extensions, which are basically a package (ZIP) containing a manifest, a CSS file, and the corresponding .js file.
Unfortunately, although the result looked nice, it lost points in terms of readability. It made it harder to understand which KPI was being displayed and, honestly, the colors and shapes attracted more attention than the actual data itself.
So, we ruled this out as a daily-use tool. But... there was no shortage of laughs along the way.
It was a great opportunity to learn a little more about how Qlik works internally. Who knows, maybe someday it will be useful for something else.
For quite some time, I have had an Android application installed on the screen at home called YoWindow, which displays different colorful scenes after a few minutes of inactivity, along with the time, weather, etc. I took inspiration from its city scenery for this extension.
The idea is to have several buildings, facilities, pharmacies, etc., each with their own doors, decorations, and windows.
Define a KPI, set a maximum value for it, and use the illuminated windows as the KPI: the closer the value gets to the defined maximum, the more windows are turned on.
Visually appealing? Yes.
Practical? Not at all.
Pretty clear so far.
I started from the ground up, testing the JavaScript integration and trying to "reach" what Qlik calls the hypercube (layout.qHyperCubeData).
The hypercube provides the following data:
I used the simplest expression I could think of to bring a real piece of data from Qlik into Javascript: ReloadTime().
If I could display ReloadTime() inside my extension, I knew I was on the right track!
Fortunately, there is quite a lot of documentation available to give Claude enough context to produce this:
Here is the hypercube with all its definitions!
Perfect! I could finally see the light at the end of the tunnel. I was now able to connect my JavaScript with Qlik.
From this point on, things became much easier, because without all the complete definitions, the extension simply wouldn't work. Instead of displaying the function's result or calculation, it would show the expression itself.
For the city, I defined SVG vectors directly inside the JavaScript, since this is much easier than importing images. And don't even get me started on loading external images without the appropriate tenant permissions — that's simply impossible for security reasons.
So, our friends "the vectors" were the better option. After all... they're just simple shapes.
Once the script was ready, including the variables I thought would be interesting for users to configure — such as colors, number of buildings, minimum and maximum values — I passed it to Claude and asked it to package everything for me.
It made several suggestions, fixed some issues in the script, and gave me the ZIP file ready to import.
Installation is straightforward: in Qlik Cloud, go to Administration → Extensions → Add. Once uploaded, the extension becomes available as an asset in the object gallery, ready to be dragged and dropped onto a sheet.
I'm leaving the GitHub link here in case anyone is still interested:
https://github.com/Miguelos2/extensiones/blob/main/KPCity/CiudadKPI.zip
Have a great week!
Catch defects and silent data corruption before they reach production with a standardized black-box testing framework for Talend Jobs.
Walk through six new AI capabilities now generally available in Qlik and start applying agentic data engineering to your team’s workflows.
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.