How to analyze multiple dimensions

[dafnis14]

Hi,

The customer requests to compare suppliers and items sales over years.

An item can be supplied by several suppliers, and a supplier can supply several items.

The attached (scrambled) chart does the job, but it is not friendly, especially when no selections are made.

The question is how to perform an effective analysis in the first place, and then with what objects?

I would appreciate some guidelines.

Thanks in advance!

[rwunderlich]

I would try a calculated dimension of Item & Year (or a new Field). Use that field as the First Dimension and Supplier as the second dim. Style Horizontal, Stacked.

A heat map may also be a nice analysis

Qlikview Cookbook: Heat Table Chart http://qlikviewcookbook.com/recipes/download-info/heat-table-chart/

[dafnis14]

Lovely Rob!

Nice ideas and thanks for the Heat Map model!

[Anonymous]

Hi, you can use Trellis options with secondary dimension.

Regards!

[dafnis14]

Hi Manuel,

This is a good option too. The thing is that everything looks very small.

So I have to think how to use this feature in an effective way.

Thanks!

[Anonymous]

Hi, you can specify number of columns and number of rows to see this greather.

Regards!

[dafnis14]

Great tip!

Thanks!

[Anonymous]

You're wellcome!