topic Comparing two pie charts in QlikView

Comparing two pie charts

georgina_spary — Mon, 06 Jun 2011 17:53:57 GMT

I would like to display two pie charts next to each other (Programme 1 vs Benchmark). The trouble is that Benchmark has more dimensions than Programme 1 so the automatically assigned colours are different for the same dimension, between the two pie charts. This makes the comparison very hard to read.

It's an automated report covering 80 Programmes against 24 Benchmarks, so I can't hard code a colour against each dimension. I want to build one chart which consists of two pie circles. If I put both expressions in 1 chart I get a mess of inner/outer rings, again very hard to read, I just want two charts next to each other.

Any ideas anyone? I've never used Trellis before, would that be the way to go? if so where do I find that?

Thanks in advance

George

Comparing two pie charts

Mon, 06 Jun 2011 18:30:19 GMT

Hi georgina_spary,

Assuming you have the following kind of data:

Program:
load * inline
[
ProgramName, SomeValue
Monday Sports, 100
Tuesday Rest, 300
Wednesday Work, 10
];
Benchmark:
load * inline
[
ProgramName, AnotherValue
Monday Sports, 1000
Wednesday Work, 100
];

You could create two pie charts with dimension ProgramName. One pie chart can have Expression of avg(SomeValue). Clone the pie chart and change the Expression to avg(AnotherValue).

Right click one pie chart -- Properties -- Colors tab -- click Persistent Colors -- OK. Repeat the process for the next pie chart. The result will look like this and might be easier to read.

HTH

Comparing two pie charts

georgina_spary — Wed, 08 Jun 2011 09:13:13 GMT

That's just what I need, thanks, I'll give it a go.