topic Re: Totalizing first dimension in a 2D Pie Chart in QlikView

Totalizing first dimension in a 2D Pie Chart

Mon, 26 Mar 2012 17:27:14 GMT

Hi!

I am trying to configure a 2D Pie Chart to show some data (see attach). Main problem is the first dimension is not totalized. It shows the individual numbers of the second dimensions which correspond to the first one but I find it impossible to show them summed.

For instance: at the left side of the chart, I don't want the first dimension to show "53 36 37" but the aggregation of those figures. How to do it?

Thanks in advance,

Totalizing first dimension in a 2D Pie Chart

Mon, 26 Mar 2012 17:48:11 GMT

I believe you do it by, =sum(field) in the expression;

Re: Totalizing first dimension in a 2D Pie Chart

Mon, 26 Mar 2012 18:20:23 GMT

Those numbers are the result of a "count" function. I've tried to sum the result of the count, but It doesn´t seem to work. Thanks anyway.

Edit: I add an example in which I found the problem. This is not with a "count" function, but it happens anyway.

Re: Totalizing first dimension in a 2D Pie Chart

Mon, 26 Mar 2012 18:38:05 GMT

I would say to add a column with 1 as flag. With this you can work with the sum(flag). I can help you better with the qvw which has the same problem.

Re: Totalizing first dimension in a 2D Pie Chart

Mon, 26 Mar 2012 18:40:58 GMT

If you can do it in the qvw I uploaded, I'm sure I can take the same idea to the one in which I'm working.

Thanks a lot.