Stacked Bars issue

[#1]

Hi,

I'm trying to create a very simply Stacked Bar, but it doesn't work like I want it to.

What do I want to achieve?

In 1 bar (by period) giving me the overview of all my metals (total = 120 Qty), subdivided in the 2 metals (Gold = 30 qty, Silver = 90 qty).

Silver + Gold = all metals

90 + 30 = 120

As you can see in the example, QV is stacking the totals up each other in stead of over each other.

So if you look at the Bar, total will give 240 as total (90 + 30 + 120!!) But this is wrong.

Total should be 120.

Any ideas?

Thanks

KR

[#2]

HI,

You've added Metals (which is your total column) into the table. You could either use set analysis to exclude metals, or remove this from your data and then calculate your total using the sum function within the qvw. The second is what I'd do.

- Ronnie

[#3]

Hi,

I took a look at your app and I think QV is calculating as expected. You coded a sum(Qty) without any filter. Then the sum is 240. Yes!

I discoverd the field "group" and it seems to me to be a flag to decide which rows of the field "metal" belong together. With this in mind I used it in the expressions of the bar charts. See my version of your app, this should point into the right direction.

Regards, Roland

[#4]

Hi,

thanks for your reply.

I used this dataset as a small example.

In real, if get this total keyfigure as an Actual / Forecast Qty.

So in Januari I got 12 'Month Totals' as a Forecast Qty, and every month the past 'Fcst total Month' will change into an 'Actual total Month'. So I can't drop this Keyfigure.

Any other ideas?

Thanks

KR