Help with special Stacked chart

[#1]

Can any one advice if I can do something similar in QV?

The dimension are Strings of Value segment and tariff plans and the expression are averages on population size and revenue.

Thanks,

Boris

[Clever_Anjos]

Try to convert one of your expression to a dimension using something like

aggr(sum(value),dimension1,dimension2)

[#3]

No, Didn't help.

[pgrenier · Accepted solution]

Good day Boris,

To the best of my knowlegde, this would be the closest graphical representation to what you are trying to achieve. I have implemented a color density scheme to represent the high/low variation for both Revenue and Population Sizes, with three different Tarif plans (X, Y and Z) over four Value Segments (A, B, C and D):

Please find attached the QlikView file where you can see this example.

Regards,

Philippe

[#5]

I did exactly what you demonstrated in the example and this is what I got.

Any Idea Why?

Thanks

[pgrenier]

Hello Boris,

I think you still need to activate the Trellis Chart:

Regards,

Philippe

[#7]

Thanks!

but somehow I got only black color on all circles.

any Idea?

[pgrenier]

Good morning Boris,

Did you precalculate the value of v_MaxRevenue and v_MaxPopulationSize in your LOAD script?

data:

LOAD * Inline [

Value Segment, Tarif Plan, Population Size, Revenue

A, X, 4000000, 65000

B, X, 2500000, 55000

C, X, 1520000, 47500

D, X, 895000, 57500

A, Y, 3200000, 25000

B, Y, 1750000, 85000

C, Y, 950000, 23500

D, Y, 45000, 250000

A, Z, 1150000, 68500

B, Z, 750000, 37500

C, Z, 900000, 125000

D, Z, 320000, 15500

];

_tmp:

LOAD Max([Population Size]) as MaxPopulationSize

   , Max(Revenue) as MaxRevenue

Resident data;

LET v_MaxRevenue = Peek('MaxRevenue', 0, '_tmp');

LET v_MaxPopulationSize = Peek('MaxPopulationSize', 0, '_tmp');

DROP Table _tmp;

Then, with those values, you can use the ColorMix1 function to alter the background color of the slices:

Cheers,

Philippe