Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jokar
Contributor II
Contributor II

Next purchased product based on previous purchase

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!

 

Labels (3)
2 Replies
Joseph_Musekura
Support
Support

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
Contributor II
Contributor II
Author

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,