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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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