Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
Time Range: Jan 2022 – July 2025 (43 months of historical data)
Columns: CustomerID
, EOM
(End of Month), Amount
(Gross Profit)
Scale: 500+ unique CustomerID
s
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 @sarak2025,
Maybe @igoralcantara can help you on this.
Regards,
Mark Costa
Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com
@sarak2025
Qlik Predict at the moment does not support Time Series. This feature is coming soon, maybe late September or early October. If you want to know what's coming, I wrote an article about it.
You can read it here: Beyond the Event Horizon: Multivariate Time Series with Qlik Predict
What you can do in the meantime is to create a regression model with some feature engineering. On top of those features you have, you can add Rolling7DaysAverage, Rolling14DaysAverage, Rolling30DaysAverage, and other features that might make sense.
However, if what you want is just to forecast a trend line, I wrote a couple articles that discuss just that:
How to build Trend Lines and Forecasting in Qlik
Fourier Transform in Qlik: Separating Signal from Noise
Hi all, thank you for your reply!
I spoke to the sales team from Qlik earlier this week and they mentioned
"Qlik currently supports multivariate time series forecasting through Qlik Predict, formerly known as Qlik AutoML. This capability is fully available in Qlik Cloud and allows users to forecast trends across multiple variables, enabling more accurate and context-driven insights using automated machine learning."
I will have a demo with them tomorrow. Hopefully this "new" feature is just added without us knowing. I will update as I have more information 🙂
I am pretty sure it is not yet available. It is still being tested. Maybe they are referring to a line chart forecast line, which is not Time Series.