Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Crosstabulation solution

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

2 Replies
rrsrini2907
Contributor

Crosstabulation solution

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.

Highlighted
MVP
MVP

Re: Crosstabulation solution

Hi Gareth,

I usually do something like attached.

Hope this helps,

Stefan