topic Re: Product CrossTable in QlikView

Product CrossTable

Wed, 08 Aug 2012 14:27:47 GMT

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 — Wed, 08 Aug 2012 14:30:16 GMT

Hi Thilo,

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

Regards,

Stefan

Wed, 08 Aug 2012 14:37:05 GMT

Hello Stefan,

yes, this would work - and so simple 🙂

I was stuck in calculated dimensions using aggr.

Thanks,

Thilo