topic Re: Crosstabulation solution in QlikView

Crosstabulation solution

Tue, 01 Nov 2011 14:04:54 GMT

Hi Everyone,

I have some data that is in the form of 1 row = 1 transaction. Each transaction has a 'category' associated with it.

I want to quickly display the cross-over (2-way) between categories based on a count of people who are active in both categories.

normally this would be a cross-tab of the same variable - has anyone come up with a clever solution to show this type of crossover in QV?

Any advice would be greatly appreciated.

Thanks

Gareth

rrsrini2907 — Tue, 01 Nov 2011 17:32:18 GMT

Hi Gareth,

We have acheived a kind of cross tabulation.

In our case we have created a chart like product and how many male and female bought the product.

We had two dimensions i.e., product and sex and one metric count of product.

Regards,

Srini.

swuehl — Wed, 02 Nov 2011 17:50:03 GMT

Hi Gareth,

I usually do something like attached.

Hope this helps,

Stefan