Next purchased product based on previous purchase

[jokar]

Hello,

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!

[Joseph_Musekura]

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.
/joseph

[jokar]

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.

Thanks,