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: 

1.  3 non-nullable INTEGER columns
2.  1 non-nullable DATETIME column that records the database insert date 
3. 1 nullable DATETIME column that records the update date

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 

Il faut que j'arrive à ce résultat :

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 😉