topic Stacked dots in combo chart in QlikView

Stacked dots in combo chart

pauldamen — Wed, 24 Oct 2012 09:11:56 GMT

Hi all,

I have a combo charts which has 2 dimensions; cities and years. So for every city I want to see the multiple years.

Furthermore I have 3 expression, 2 which are a stacked bar and the 3rd should be a dot which represents an other percentage.

But because off the 2 dimensions it also stacks the dots for the 3rd expression. Could anyone help how to fix this?

Regards,

Paul

Mon, 21 Jan 2013 17:41:56 GMT

Hello Paul,

I am having almost exactly the same problem. Did you ever find a solution?

Mon, 21 Jan 2013 20:44:41 GMT

Have you tried using a trellis chart? This way one dimension is used to draw different charts and the visual effect could be similar.

sebastiandperei — Mon, 21 Jan 2013 21:35:49 GMT

Hi Paul.

I don´t know if it's possible to select only "stacking" for some expressions and not for others (I think isn't possible)

You could use arithmetic operations for get the result you want. For example:

Expr1: Sum(Cost)/sum(Total Cost)

Expr2: Sum(Rent)/sum(Total Rent) (this will stack these two expressions)

Expr3: Sum(Obj)/Sum(Total Obj)-Expr1-Expr2 (this will stack Expr3 with Expr1 and Expr2, but then you will get only the value for the Expr3)

Try it