Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Thilo,
maybe you could try something like I've suggested here:
http://community.qlik.com/message/162179#162179
Regards,
Stefan
Hi Thilo,
maybe you could try something like I've suggested here:
http://community.qlik.com/message/162179#162179
Regards,
Stefan
Hello Stefan,
yes, this would work - and so simple 🙂
I was stuck in calculated dimensions using aggr.
Thanks,
Thilo