Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
we recently moved from QlikSense On-Prem to Qlik Cloud. Checking the data consumption in the Cloud I stumbled upon "Previous App Reload".
Last App Reload in December 25 with 'exit script' right at the start, as this App was intended to be archived without any data. The app gets listed in the consumption report for Jan 26 anyways, with roughly 11GB categorized as "Previous App Reload - Nov 25".
If we would not have reloaded the App with exit script before, I could understand the consumption. As the App still exists and still would have data inside which is stored, but we specifically reloaded it without any data.
Anyone else got more detailed information about the "Previous App reload" ?
Thanks
Hello all
I have a button in my Qlik Cloud app that executes an automation in triggered mode. When I publish the app to a managed space so that end users can trigger it themselves, they click the button, but the automation won't be executed.
It seems like only the owner of the automation is allowed to execute it.
I did everything in this video: https://youtu.be/uwtpmjumejc?si=9kLwfiOoab4Ywhr0 in manual mode and trigger mode, also nothing.
How can I resolve this? Also is this a limitation of the Analyzer License?
Thanks
Hi Everyone,
I need help on below visualization. The graph is not displayed according to month. It should be January, Feb, Mar so on.
In below screenshot, if I already selected a filter in 'Year' the months are in chronological order. But then If I selected another filter in Month then the graph is not in chronological order. I want it to show in chronological order regardless if I filter it. What expression do I need to do?
Hi All,
I am getting issue while using Qlik N-printing on demand service, when i am trying to download report through on demand dashboard bundle, i have attached screen shot for your reference
As a workaround, if we log in to N-Printing in a separate window first, we are then able to download the report successfully. Otherwise, the system displays an error stating that it is unable to connect to the server.
I have tried using the FQDNs, localhost, and IP/domain configurations, and also attempted Windows authentication.
Regards,
Rohit
I do need to create a security rule to give access to user who only they are the owner of the data connection, using QmcSection_DataConnection.
i have created a custom admin role "DataConnection" and assign it to this user, in the condition i did "((user.roles="DataConnection" and resource.owner.name=user.name))" but the user still able to see all data connection.
I have a SQL Server source table that has 5 columns:
The MERGE statement looks like this (the names were changed to protect the innocent):
MERGE INTO "dbo"."my_table_name" T
USING (
SELECT *
FROM "public"."attrep_changes6004D92ED521268C"
WHERE "table_id" = 1
) S
ON (T."ASSIGNMENTID" = IFF("table_id" = 1, TRY_CAST(S."seg1" AS NUMBER(38, 0)), NULL))
AND (T."PERIODID" = IFF("table_id" = 1, TRY_CAST(S."seg2" AS NUMBER(38, 0)), NULL))
WHEN MATCHED AND "replicate_op" = 0 AND "table_id" = 1
THEN DELETE
WHEN MATCHED AND "replicate_op" <> 0 AND "table_id" = 1
THEN UPDATE SET
T."NumericColumn1" = IFF("table_id" = 1, TRY_CAST(S."col1" AS NUMBER(38, 0)), NULL),
T."NumericColumn2" = IFF("table_id" = 1, TRY_CAST(S."col2" AS NUMBER(38, 0)), NULL),
T."NumericColumn2" = IFF("table_id" = 1, TRY_CAST(S."col3" AS NUMBER(38, 0)), NULL),
T."DatabaseInsertDate" = IFF("table_id" = 1, TRY_CAST(S."col4" AS TIMESTAMP(3)), NULL),
T."DatabaseUpdateDate" = IFF("table_id" = 1, TRY_CAST(S."col5" AS TIMESTAMP(3)), NULL)
WHEN NOT MATCHED AND "replicate_op" <> 0 AND "table_id" = 1
THEN INSERT (
"NumericColumn1",
"NumericColumn2",
"NumericColumn3",
"DatabaseInsertDate",
"DatabaseUpdateDate"
)
VALUES (
IFF("table_id" = 1, TRY_CAST(S."col1" AS NUMBER(38, 0)), NULL),
IFF("table_id" = 1, TRY_CAST(S."col2" AS NUMBER(38, 0)), NULL),
IFF("table_id" = 1, TRY_CAST(S."col3" AS NUMBER(38, 0)), NULL),
IFF("table_id" = 1, TRY_CAST(S."col4" AS TIMESTAMP(3)), NULL),
IFF("table_id" = 1, TRY_CAST(S."col5" AS TIMESTAMP(3)), NULL)
);
I figured that the issue is caused by TRY_CAST and that the TRY_CAST is returning a NULL for my DatabaseInsertDate. The FULL load works fine, but from what I can see the full load is doing a COPY INTO and not running a TRY_CAST. I have tried adding a transformation on the Table Settings for this table to
strftime('%Y-%m-%d %H:%M:%f', $DatabaseInsertDate)
...but that has not helped.
The public.attrep_changes6004D92ED521268C table goes away as soon as the error occurs so I cannot see the data behind the issue.
Please help. Thanks
Hello,
I have just installed QlikSense Enterprise November 2025 and when I try to export a graph, table or page to PDF, I get a blank PDF.
Is there a patch or method to fix this?
Thank you in advance.
Romain
Hello,
I'm trying to solve a relatively difficult problem that I've hit a wall on. It's a bit of tricky one and would appreciate any help.
I'm looking to apply ZScore normalisation using the native KMeansND clustering function.
KMeans2D has the ability to pass this as an argument, KMeansND does not.
Let me try to break this down as much as I can.
This is KMeans2D without normalisation. This is achieved by colouring the scatter by dimension and using this expression:
=Aggr(KMeans2D(5, n2_sprd_historical_bps, n2_value_EUR), n2_orderref)
This is KMeans2D with normalisation. You can see significant differences in how datapoints are clustered (more accurate for what I need). The expression for this is:
=Aggr(KMeans2D(5, n2_sprd_historical_bps, n2_value_EUR, 'zscore'), n2_orderref)
So as a starting point I'm trying to replace with KMeansND. I can achieve a similar result as KMeans2D without normalisation by using the expression below. The output is the exact same as no normalisation KMeans2D (as expected):
=Aggr(KMeansND(5, n2_sprd_historical_bps, n2_value_EUR), n2_orderref)
I can successfully generate ZScore calculation on a table by using this expression as a measure
=(n2_value_EUR - avg(total n2_value_EUR)) / stdev(total n2_value_EUR)
The idea is to plug this into KMeansND, as below.
=Aggr(KMeansND(5, (n2_sprd_historical_bps - avg(total n2_sprd_historical_bps)) / stdev(total n2_sprd_historical_bps), (n2_value_EUR - avg(total n2_value_EUR)) / stdev(total n2_value_EUR)), n2_orderref)
The expression throws no errors and scatter plot generates fine, but the output looks the same as the non-normalised version, showing the zscore measure hasn't been applied.
I suspect this may have something to do with the AGGR and TOTAL function in the KMeansND, but I'm unsure.
I've tried nesting the Aggr elsewhere but no luck
=KMeansND(5, (Aggr(n2_sprd_historical_bps, n2_orderref) - avg(total n2_sprd_historical_bps)) / stdev(total n2_sprd_historical_bps), (Aggr(n2_value_EUR, n2_orderref) - avg(total n2_value_EUR)) / stdev(total n2_value_EUR))=KMeansND(5, (n2_sprd_historical_bps - Aggr(avg(total n2_sprd_historical_bps), n2_orderref)) / Aggr(stdev(total n2_sprd_historical_bps), n2_orderref), (n2_value_EUR - Aggr(avg(total n2_value_EUR), n2_orderref)) / Aggr(stdev(total n2_value_EUR), n2_orderref))
Any help or ideas would be much appreciated. Thanks.
Bonjour le communauté,
Je n'arrive pas à trouver une expression qui me permette de bien totaliser mes lignes et que le total de la colonne soit aussi correcte.
J'ai une commande (devis) et plusieurs facturations (situations 001, 008 et 009). Dans mon tableau je dois faire la somme des factures par commande et articles.
Dans mon jeu de données, pour chaque chrono (articles) j'ai le montant global de la commande qui correspond à l'article. Un article pouvant faire l'objet de plusieurs facturations pour la même commande.
Exemple
| Affaires | %LSituat_Cle | %LSituat_Key | LSituat_Acteur | LSituat_Code_Commande | LSituat_Chrono | LSituat_Code_Situation | Sum(Commande_HT) | Facturé |
| toto | 0010|1001|10012409|0000000001|0001|001|00001|008 | 0010|1001|10012409|0000000001|0001|00001|008 | 0000000001 | 0001 | 00001 | 008 | 20021,00 | 20021 |
| toto | 0010|1001|10012409|0000000001|0001|001|00002|008 | 0010|1001|10012409|0000000001|0001|00002|008 | 0000000001 | 0001 | 00002 | 008 | 158936,50 | 15000 |
| toto | 0010|1001|10012409|0000000001|0001|001|00002|009 | 0010|1001|10012409|0000000001|0001|00002|009 | 0000000001 | 0001 | 00002 | 009 | 158936,50 | 8000 |
| toto | 0010|1001|10012409|0000000001|0001|001|00004|008 | 0010|1001|10012409|0000000001|0001|00004|008 | 0000000001 | 0001 | 00004 | 008 | 7267,47 | 7000,00 |
| toto | 0010|1001|10012409|0000000001|0001|001|00004|009 | 0010|1001|10012409|0000000001|0001|00004|009 | 0000000001 | 0001 | 00004 | 009 | 7267,47 | 267,47 |
| toto | 0010|1001|10012409|0000000002|0001|001|00005|008 | 0010|1001|10012409|0000000002|0001|00005|008 | 0000000002 | 0001 | 00005 | 008 | 2741,00 | 2741 |
| toto | 0010|1001|10012409|0000000003|0001|001|00003|001 | 0010|1001|10012409|0000000003|0001|00003|001 | 0000000003 | 0001 | 00003 | 001 | 3843,00 | 3843 |
Il faut que j'arrive à ce résultat :
| Affaires | %LSituat_Cle | %LSituat_Key | LSituat_Acteur | LSituat_Code_Commande | LSituat_Chrono | LSituat_Code_Situation | Sum(Commande_HT) | Facturé |
| toto | 0010|1001|10012409|0000000001|0001|001|00002|008 | 0010|1001|10012409|0000000001|0001|00002|008 | 0000000001 | 0001 | 00002 | 008 | 158936,50 | 158000,00 |
| toto | 0010|1001|10012409|0000000001|0001|001|00004|008 | 0010|1001|10012409|0000000001|0001|00004|008 | 0000000001 | 0001 | 00004 | 008 | 7267,47 | 7267,47 |
| TOTAL | 186224,97 | 185288,47 | ||||||
| toto | 0010|1001|10012409|0000000002|0001|001|00005|008 | 0010|1001|10012409|0000000002|0001|00005|008 | 0000000002 | 0001 | 00005 | 008 | 2741,00 | 2741,00 |
| TOTAL | 2741,00 | 2741,00 | ||||||
| toto | 0010|1001|10012409|0000000003|0001|001|00003|001 | 0010|1001|10012409|0000000003|0001|00003|001 | 0000000003 | 0001 | 00003 | 001 | 3843,00 | 3843,00 |
| TOTAL | 3843,00 | 3843,00 |
Je n'arrive pas à calculer la colonne Commande HT à l'aide d'une expression ! Pourriez vous m'aider ? Est-ce qu'il faut pour un cas comme celui là passer par le script de chargement ?
Merci par avance et bonne année à toutes et à tous 😉
Hi Folks,
We are using Qlik Talend Cloud Enterprise Edition v8 (Build id: 20250521_1150-patch).
I have an Excel file (C:\Source\Source_Data.xlsx) with Sales, Customers, Products info in a single excel sheet.
I need to:
Has anyone done this in Talend 8?
What is the best way to split the data and create the XML structure?
Any sample job design or steps would be helpful.
Source data in excel :
Target data in XML in 3 sheets :
Customers:
CustomerID CustomerName Email Phone City Country 201 Alice Johnson alice.johnson@example.com +1-202-555-0147 New York USA 202 Bob Smith bob.smith@example.com +1-202-555-0178 Los Angeles USA
Products:
ProductID ProductName Category Price StockQty Supplier 101 Laptop Pro 15 Electronics 1200 50 TechWorld Inc. 102 Wireless Mouse Accessories 25.99 200 GadgetSupply Co.
Sales:
SalesID OrderDate CustomerID ProductID Quantity UnitPrice TotalAmount 1001 1/5/2025 201 101 2 1200 2400 1002 1/12/2025 202 109 3 45 135
FREE TRIAL
Data has stories to tell—let Qlik help you hear them. Start your FREE TRIAL today!
Dare to unleash a new professional you in 2026. Join Connect April 13–15 and supercharge your skill sets.
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Data Integration Tool.
Trends 2026 Alert! Plug into this rewired framework for driving ROI from AI.
Learn why legacy data platforms can’t meet today’s AI and analytics demands and how Qlik provides a modern, independent, future-ready alternative.
Solve the real-world need for real-time data with Change Data Capture (CDC). What is CDC and how to master it?
Your journey awaits! Join us by Logging in and let the adventure begin.
Afcons Infrastructure partnered with Qlik to unify its data and build dynamic dashboards, reducing review times from weeks to hours and enabling on-demand reporting across its global operations.
By implementing Qlik Analytics, Atria Convergence Technologies improves insight into churn, revenue, and downtime, driving faster decisions and more proactive customer support.
Hydronorth uses Qlik to replace disconnected data systems with a single source of truth, improving alignment, speeding up decisions, and reducing manual work.
With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.
Join one of our Location and Language groups. Find one that suits you today!
Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.
The Qlik Product Recap showcases the newest features with quick demos and shareable resources to help you stay current?
You can test-drive Qlik for free? Try Qlik Talend Cloud to integrate and clean data without code, or explore Qlik Cloud Analytics to create AI-powered visualizations and uncover insights hands-on.
Salesforce’s acquisition of Informatica could put your flexibility on hold? Qlik makes it easy to keep your data initiatives moving forward.
You can move beyond batch processing and harness real-time data to power AI and faster decisions? Discover how in our new eBook, Mastering Change Data Capture.