Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
MVP
MVP

Re: Product CrossTable

Hi Thilo,

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

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

Regards,

Stefan

2 Replies
MVP
MVP

Re: Product CrossTable

Hi Thilo,

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

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

Regards,

Stefan

Not applicable

Re: Product CrossTable

Hello Stefan,

yes, this would work - and so simple :-)

I was stuck in calculated dimensions using aggr.

Thanks,

Thilo

Community Browser