Skip to main content
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Next purchased product based on previous purchase


I am trying to find out what the next purchase is based on the category of the first purchase.

Below is an example of the data I have:

category product customer id order id date qty
cutlery fork  1234 987 1/1/21 2
cooking pan 1235 986 2/1/21 1
cleaning brush 1236 986 4/1/21 1


What I am hoping to do is to create a table which will show me the next products purchased that I can sort buy qty. For example I would be able to see in one table all the next purchased products that were purchased by people who bought a 'cooking' product.

Thank you in advance!


Labels (3)
2 Replies

Hi @jokar ,
When you talk about NEXT purchase, do you mean a kind of  "purchase forecast "? 
We have in Qlik Sense a feature called "Time series forecasting"   At the bottom of this page, there is an example of line chart /time series forecasting that you can use to explore your idea /requirements/limitations. 
Be aware that you will need a big amount of data to predict "next purchased products" based on people who bought a 'cooking' product. It requires a complex algorithm.

Contributor II
Contributor II

Hi @Joseph_Musekura ,

No, not a purchase forecast. I want to look at historical data.

I am trying to find out what was the next item purchased for customers that purchased more than 1 item.