Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Totalizing first dimension in a 2D Pie Chart

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,

IW

4 Replies
Not applicable

Totalizing first dimension in a 2D Pie Chart

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

Not applicable

Re: Totalizing first dimension in a 2D Pie Chart

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.

Not applicable

Re: Totalizing first dimension in a 2D Pie Chart

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.

Not applicable

Re: Totalizing first dimension in a 2D Pie Chart

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.

Community Browser