topic Re: Stacked Bar chart wrong total in QlikView

Stacked Bar chart wrong total

Fri, 24 Jul 2015 10:56:08 GMT

I'm using the same measure for two charts and it represented in a different way. For example, I see 620 for chart 1

and +677 and -57 for another

People are catching different numbers from that charts.

Please advise how to remove negative and positive values separation

Message was edited by: Yuri

Re: Stacked Bar chart wrong total

MK_QSL — Fri, 24 Jul 2015 10:59:23 GMT

Can you please provide sample data or application?

Re: Stacked Bar chart wrong total

Fri, 24 Jul 2015 12:39:14 GMT

Added to topic

Re: Stacked Bar chart wrong total

Fri, 24 Jul 2015 13:42:22 GMT

from the example you sent, it looks like the negative values in the charts containing the 2 dimensions are what is causing the diffence - If you take the negative numbers into account, the appear to match the bar charts that are only using the date dimesnion.

It appears when you select values on data point, it has 2 values - positive and negative - the 2 added together provide the correct total result

If you use a fast change to a pivot tabe for the object containing the 2 dimension and show subtotals, you will see tghat the numbers match to the bar chart on the bottom

Re: Stacked Bar chart wrong total

Fri, 24 Jul 2015 14:01:06 GMT

I know. So people

will have ready to use number for dates w/o negatives
or must calculate if it is

too complicated for end user

Re: Stacked Bar chart wrong total

Fri, 24 Jul 2015 14:27:06 GMT

You can submit a case to Qlik and let them know that when negative numbers are involved the data points are at both positive and negative and does not reflect the true total.

for the mean time, you can use a fast change to a pivot and they can see that the numbers are the same

or possibly try using the absolute value in the expression - that would possibly remove the negative issue