Product CrossTable

[#1]

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

[swuehl · Accepted solution]

Hi Thilo,

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

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

Regards,

Stefan

[#3]

Hello Stefan,

yes, this would work - and so simple 🙂

I was stuck in calculated dimensions using aggr.

Thanks,

Thilo