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:
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.
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