I have a process that pulls from a MySQL database, compares to existing entries in a destination database, and then Inserts or Updates depending on existence.

The Updates are extremely slow, along the lines of ~2 rows/sec. This is fairly consistent regardless of batch size or commit size. Destination has an appropriate index for the key. 

When the job is modified to send Updates to a tLogRow component, output jumps to nearly 8k rows/sec.

Any ideas why this tDBOutput component is going so slow?

Join us on LinkedIn Live August 21 for a conversation with #WomenWhoQlik on challenging bias, redesigning systems, and building a more equitable data culture.

Featuring voices from across data, tech, and ethics, we’ll explore how women can lead the charge for transparency, fairness, and inclusion in the systems that shape our world.

Share in the excitement with @Aklidas, @StephanieR, @jeannine_boot and kelly Forbes and let them know you will be attending HERE!

hi All,  

we have Qlik replicate target as Databricks lakehouse Delta on GCP..

we have Primary key and few of them are non Primary key.

Here i check docs as apply changes only for PK's.

How to support for the Non PK's kindly share the suggestion. 

Even if the store changes to __CT tables will truncate and load will work

Kindly share?

Hi,

I’m working on building a time series forecasting model to predict Gross Profit for the next 18 months (Aug 2025 through Dec 2026), and I’m looking for expert guidance on the best approach within Qlik’s ML environment—especially for handling multiple time series (one per customer).

Dataset Details:

• Time Range: Jan 2022 – July 2025 (43 months of historical data)

• Columns: CustomerID, EOM (End of Month), Amount (Gross Profit)

• Scale: 500+ unique CustomerIDs

• Goal: Generate individual forecasts per customer for the next 18 months

Below is a screenshot of the dataset.

I’m specifically exploring the "ML Experiment" feature and wondering:

Is there a tutorial or example that shows how to structure a time series forecast for multiple entities (like CustomerID)? I’ve reviewed the documentation but haven’t found a clear example of this use case.

If you’ve implemented something similar or know of any Qlik-native resources, tutorials, or best practices, I’d love your insights.

Thanks in advance!

Hi,

I have noticed that the QDI interface in browser loads slower after upgrading to May 2024 (2024.5.0.563).

I am using Chrome Version 138.0.7204.158 (Official Build) (64-bit)

Is there a way to check logs to see what's going on or increase the cache size?

Thank you.
Desmond

Hello,

I have an inline table with the following data: Product Code, Period, and Total.

TempData:
LOAD*
INLINE [
Cod_Product, Period, Total
A, 202004, 675
A, 202007, 646
A, 202104, 668
A, 202404, 570
B, 202108, 901
B, 202008, 955
B, 202504, 597
B, 202203, 682
C, 202511, 135
C, 202311, 551
C, 202510, 292
C, 202001, 867
D, 202502, 912
D, 202202, 126
D, 201805, 681
D, 202507, 406
];

I would like to know if you can help me find the formula that calculates the maximum periods per product, regardless of which period I select in the filter. For example:

Example if I choose 202502
202502 D
202311 C
202203 B
202104 A

Example if I choose 202203
202202 D
202001 C
202203 B
202104 A

Example if I choose 202008
201805 D
202001 C
202008 B
202007 A

Example with no period selected

202507 D
202511 C
202504 B
202404 A

And when this is done, I want the total sum of those maximum periods to appear.

I attach an Excel file for better understanding.

Thank you!!!!

Hi,

I am integrating GoHighLevel with Qlik using REST connector.
The method I am using is
Using the URL : 'https://rest.gohighlevel.com/v1/contacts/'
Query Parameters
 Authorization , Bearer API KEY
And Pagination Type : Choosing Next URL and this way
With Next url path : root/nextPageUrl => Connecting but after load very minimum data 106 out of 2000 rows.
With Next url path : root/meta/nextPageUrl => Connecting but while reloading in data load editor showing error 502.
I have tested on postman and I am getting whole data.
Please help how do I proceed here.

Hi,

I am running a Talend Big data job on spark but has failed due to null pointer issue and could not figure out the root cause for it. 

Please refer below log for issue:

org.apache.spark.SparkException: Job aborted due to stage failure: java.lang.RuntimeException: java.lang.NullPointerException
at org.talend.bigdata.dataflow.functions.FlatMapperIterator.hasNext(FlatMapperIterator.java:75)
at scala.collection.convert.Wrappers$JIteratorWrapper.hasNext(Wrappers.scala:41)
at scala.collection.Iterator$$anon$14.hasNext(Iterator.scala:388)
at scala.collection.Iterator$$anon$11.hasNext(Iterator.scala:327)
at scala.collection.Iterator$$anon$11.hasNext(Iterator.scala:327)
at scala.collection.Iterator$$anon$11.hasNext(Iterator.scala:327)
at org.apache.spark.rdd.PairRDDFunctions$$anonfun$saveAsHadoopDataset$1$$anonfun$13$$anonfun$apply$7.apply$mcV$sp(PairRDDFunctions.scala:1195)
at org.apache.spark.rdd.PairRDDFunctions$$anonfun$saveAsHadoopDataset$1$$anonfun$13$$anonfun$apply$7.apply(PairRDDFunctions.scala:1195)
at org.apache.spark.rdd.PairRDDFunctions$$anonfun$saveAsHadoopDataset$1$$anonfun$13$$anonfun$apply$7.apply(PairRDDFunctions.scala:1195)
at org.apache.spark.util.Utils$.tryWithSafeFinallyAndFailureCallbacks(Utils.scala:1277)
at org.apache.spark.rdd.PairRDDFunctions$$anonfun$saveAsHadoopDataset$1$$anonfun$13.apply(PairRDDFunctions.scala:1203)
at org.apache.spark.rdd.PairRDDFunctions$$anonfun$saveAsHadoopDataset$1$$anonfun$13.apply(PairRDDFunctions.scala:1183)
at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:66)
at org.apache.spark.scheduler.Task.run(Task.scala:89)
at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:227)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

I am doing right outer join operation using tSQLROW where I suspect the issue lies but dont know the root cause.

Thanks