topic Re: Help with special Stacked chart in QlikView

Help with special Stacked chart

Tue, 10 Dec 2013 10:00:15 GMT

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

Re: Help with special Stacked chart

Anonymous — Tue, 10 Dec 2013 10:05:00 GMT

Hi Boris

I think Scatter Chart would do some help in achieving your requirement.

Regards

Nitin

Re: Help with special Stacked chart

Tue, 10 Dec 2013 10:08:26 GMT

Hi Boris

I think a bubble chart looks good too

Chris

Re: Help with special Stacked chart

Tue, 10 Dec 2013 11:10:48 GMT

tried this one:

Not what I wanted, its not stacked (and can't be)

Re: Help with special Stacked chart

Tue, 10 Dec 2013 12:46:31 GMT

Boris

a bar chart can be stacked

Chris

Re: Help with special Stacked chart

Anonymous — Tue, 10 Dec 2013 14:04:24 GMT

Try Scatter Chart,

Bubble chart will not show data as per your req

Re: Help with special Stacked chart

Clever_Anjos — Tue, 10 Dec 2013 14:07:13 GMT

Maybe a Grid Chart?

Re: Help with special Stacked chart

Tue, 10 Dec 2013 14:25:22 GMT

Can you please send me an example?

thanks,

Boris

Re: Help with special Stacked chart

Clever_Anjos — Tue, 10 Dec 2013 14:40:26 GMT

Check for "Data Visualization.qvw" into your C:\Program Files\QlikView\Examples\Documents its in "Relationship" tab.

Look for this and change the Style

Re: Help with special Stacked chart

Tue, 10 Dec 2013 14:49:42 GMT

This has 3 dimensions and 1 expression.

I need 2 dimensions and 2 expressions per dimension that will be stacked in the bubble.

Re: Help with special Stacked chart

Clever_Anjos — Tue, 10 Dec 2013 14:52:54 GMT

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

aggr(sum(value),dimension1,dimension2)

Re: Help with special Stacked chart

Tue, 10 Dec 2013 15:03:16 GMT

No, Didn't help.

Re: Help with special Stacked chart

pgrenier — Tue, 10 Dec 2013 16:47:34 GMT

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

Re: Help with special Stacked chart

Sun, 15 Dec 2013 13:03:49 GMT

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

Any Idea Why?

Thanks

Re: Help with special Stacked chart

pgrenier — Sun, 15 Dec 2013 21:11:45 GMT

Hello Boris,

I think you still need to activate the Trellis Chart:

Regards,

Philippe

Re: Help with special Stacked chart

Mon, 16 Dec 2013 07:24:10 GMT

Thanks!

but somehow I got only black color on all circles.

any Idea?

Re: Re: Help with special Stacked chart

pgrenier — Mon, 16 Dec 2013 14:17:51 GMT

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