2 Replies Latest reply: Apr 10, 2012 8:15 AM by THe_evaco

# Product Cross Sell Pivot Overview?

Hello all,

this must be a very common question, but so far I did not find a solution in the forum.

I have a raw data table showing which customer (1..6) bought which product (A.B.C)

My goal is to achieve an overview, which customer of product A has also purchased product B.
I want to have that in a (pivot) table. I found solutions in the forum where the information is provided based on a product or customer selection, but this is not what I need. I want to show the result based on a “clear” selection.

Raw data:
(Row 1 reads ‘Customer 1 bought products A, B, and C’
Row 2 reads ‘Customer 2 bought only products A’)

 CID A B C 1 x x X 2 x 3 x x 4 x X 5 X 6 x

Desired Result:
(Row 1 reads ‘2 customers bought products A AND B, 1 customer bought products A AND C’)

 A B C A - 2 1 B 2 - 2 C 1 2 -

I worked with the aggr function, e.g. to find out how many customers have bought more than 1 product, but I fail to get the pivot done. I just don’t understand how to combine the calculated dimensions with the set analysis … which must be the way doing it … or not?

Thank for any hints,

Thilo

• ###### Re: Product Cross Sell Pivot Overview?

I think you can use something like the crosstabulation solution I posted here for that, using the same dimension product twice:

http://community.qlik.com/message/162179

Hope this helps,

Stefan

• ###### Re: Product Cross Sell Pivot Overview?

Hello Stefan,

Thanks for the help!
Sometimes the simple solutions are the best … I was so focused on aggr/ set analysis that I didn’t see the obvious.

Great – thanks again,

Thilo