Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Brand And Shopping Cart Analysis

Hello!

I'm having a challange solving a problem for an end-user. What the user wants is more or less an analysis of what brands their customers purchase, if they purchase XX and also purchase brand YY.

Trying to put it simple; Customer purchase brand A, B and C - selecting brand A would get possible selections on brand B and C. and so on.

The result would be something like this;

BRAND1      BRAND2

A                 B

A                 C

B                 A

B                 C

C                 A

C                 B

If another customer buy items of brand C and D then the tables should be something like this

BRAND1      BRAND2

A                 B

A                 C

B                 A

B                 C

C                 A

C                 B

C                 D

D                 C

and so on.

Have tried to search for something in these lines without any success unfortunately.

Is there someone out here that has a clue on how to achieve this or has any input at all I would love to hear your ideas.

Thanks in advance!

//Niklas

2 Replies
Gysbert_Wassenaar

See attached qvw. Is that close to what you're looking for? If not try searching for basket analysis on the forums too.


talk is cheap, supply exceeds demand
johnsmith001
Contributor II
Contributor II

Incorporating retail tech services like predictive analytics and machine learning algorithms can greatly assist in solving your challenge. By leveraging data on customer purchase behavior, these tools can provide insightful brand and shopping cart analysis. This analysis can reveal patterns and correlations, helping to identify brand affinities and suggesting complementary products, ultimately providing a seamless shopping experience and driving sales.