topic Re: Brand And Shopping Cart Analysis in QlikView

Brand And Shopping Cart Analysis

Thu, 21 Feb 2013 15:59:49 GMT

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

Re: Brand And Shopping Cart Analysis

Gysbert_Wassenaar — Thu, 21 Feb 2013 18:44:37 GMT

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