topic Re: Stacked Bar Chart in QlikView

Stacked Bar Chart

Thu, 27 Aug 2015 15:47:43 GMT

Hi,

I built a stacked bar chart, that has different colors for multiple currencies. Values displayed on the data points. Y-value sorted descending. However, in the graph it looks like this (-524 is just a value for one currency in that bar, total value there is 209,000,000).

and yes I know that adding up different currencies is not great representation, but it has to be done, and sorted.

is there a way to display the actual 209,000,000 or to display sums of each currency?

Re: Stacked Bar Chart

ChiragPradhan — Thu, 27 Aug 2015 16:09:12 GMT

Can you attach some sample data?

Re: Stacked Bar Chart

Thu, 27 Aug 2015 16:11:24 GMT

the fields I use is customers, amount, and currency

Re: Stacked Bar Chart

Thu, 27 Aug 2015 18:54:11 GMT

These are actually all the values that are summed in the bar showing -524, any ideas why does it only show the sum of two negative numbers.

113219
8000
50000
4580
-500
209000000
2800000
24000
1009050
1000
-24
2344497.71
2000
1500

Re: Stacked Bar Chart

chaper — Thu, 27 Aug 2015 19:09:12 GMT

Attach sample qvw.

Re: Stacked Bar Chart

Thu, 27 Aug 2015 21:27:59 GMT

I also found this question someone asked, but no valid answer there as well

Still showing negative value on the graph in a Sum