Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
edit: adapted your file
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
edit: adapted your file
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
Hi Swuehl,
I have the same problem, trying to replicate it in Qliksense
May I know how can I get the same output in qliksense?
Or if there is any Qliksense community members knows the solution will be great!