Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
StacyCui
Creator
Creator

Crosstabulation Solution

Hi, Recently, I have a topic on cross selling.  I have a order table. 

Product OR Client ID
A 100 1
A 200 2
A 500 5
A 10 4
B 7 1
B 8

3

C 90 2
C 40 4

 

what I'm trying to achieve is:

Store A B C
A - 1 2
B 1 - 1
C 2 0 -

 

It can be show how many clients choose the product combination. How to create a data model?

Labels (3)
0 Replies