Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

1 Reply

Re: Brand And Shopping Cart Analysis

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
Community Browser