topic Re: How to analyze multiple dimensions in QlikView

How to analyze multiple dimensions

dafnis14 — Wed, 17 Aug 2016 04:10:47 GMT

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!

Re: How to analyze multiple dimensions

rwunderlich — Wed, 17 Aug 2016 05:09:18 GMT

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/

Re: How to analyze multiple dimensions

dafnis14 — Wed, 17 Aug 2016 05:48:21 GMT

Lovely Rob!

Nice ideas and thanks for the Heat Map model!

Re: How to analyze multiple dimensions

Anonymous — Wed, 17 Aug 2016 06:30:28 GMT

Hi, you can use Trellis options with secondary dimension.

Regards!

Re: How to analyze multiple dimensions

dafnis14 — Wed, 17 Aug 2016 10:49:38 GMT

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!

Re: How to analyze multiple dimensions

Anonymous — Wed, 17 Aug 2016 11:48:55 GMT

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

Regards!

Re: How to analyze multiple dimensions

dafnis14 — Thu, 18 Aug 2016 06:40:57 GMT

Great tip!

Thanks!

Re: How to analyze multiple dimensions

Anonymous — Thu, 18 Aug 2016 06:45:09 GMT

You're wellcome!