Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Product CrossTable

Hello all,

any idea how to solve this:

I have a simple table with 3 columns: Customer, Product, Units.

It basically says which customer bought which product, and how many of them.

Now I want to create a pivot table:

X-axes: Product

Y-axes: Product

Expression: count of customers who bought product (x-axes) AND product (y-axes).

Must be simple ... I just don't see it ...

Thanks for any hints,

Thilo

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Hi Thilo,

maybe you could try something like I've suggested here:

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

Regards,

Stefan

View solution in original post

2 Replies
swuehl
MVP
MVP

Hi Thilo,

maybe you could try something like I've suggested here:

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

Regards,

Stefan

Not applicable
Author

Hello Stefan,

yes, this would work - and so simple 🙂

I was stuck in calculated dimensions using aggr.

Thanks,

Thilo