topic create a cross tab chart. in QlikView

create a cross tab chart.

Thu, 05 Jan 2012 23:46:21 GMT

I want to create a table/pivot chart that looks something like this. Where two categories (Adult Allergy Decile, Topical Anti-Infective decile) are compared based on their counts. For example, when Adult Allergy Decile = 0 and Topical Anti-Infective decile = 0, the count is '1'. And when Adult Allergy Decile = 0 and Topical Anti-Infective decile = 1 the count is '8' and so on so forth. How can this be acheived in QV 9 SR5. Thanks.

create a cross tab chart.

swuehl — Fri, 06 Jan 2012 00:21:16 GMT

You can try creating a pivot table chart with the two categories as dimension and your count as expression.

Then pivot the second dimension to the top by clicking and dragging the dimension in the chart to the top (there should be a blue line when clicking that you can move around).

Depending on your data model, the result should be pretty close to what you attached above.

Hope this helps,

Stefan

create a cross tab chart.

Fri, 06 Jan 2012 21:34:00 GMT

There is a category dimension called CATEGORY_NAME which has roughly 25 categories/values in there. When you say use 'two categories as dimension and count as expression', do you mean I've to rename CATEGORY_NAME as CATEGORY_NAME_1 and then bring the other category? In our example above, Allergy Decile & Topical Anti-Infective decile are one of those 25 CATEGORY_NAME. Is it almost like a self join to itself? I don't know how to design this in a datamodel. Thanks for your help.

create a cross tab chart.

swuehl — Fri, 06 Jan 2012 23:56:22 GMT

It seems indeed that we first need to think how we can create an appropriate data model / how we can calculate the values we want to see, before we can start with a special visualization.

Could you describe your data model a bit more? Or at best, upload a small sample app (could be mock up data, of course)?

How do you calculate your deciles? I understand that they are not part of your data model yet, right?