topic Re: Stacked Bar Chart Total does not include negative values in App Development

Stacked Bar Chart Total does not include negative values

kgwen100 — Tue, 01 Oct 2019 19:07:27 GMT

Hi all,

This seems to be a recurring issue amongst other posters. I have created a stacked bar chart, however the totals at the top do not include negative values in the sum. I have my sales region as the stack, solution suite as the bar, and sum(revenue) as my measure.

Does anyone know a workaround? Or why Qlik would not include negative values in the sum?

Re: Stacked Bar Chart Total does not include negative values

dplr-rn — Tue, 01 Oct 2019 19:51:20 GMT

unfortunately its behavior as designed i think. ref below support article for qlikview (relevant because its same behavior in sense)

https://support.qlik.com/articles/000003248

I would changing the visualization

e.g. suggest using a drill down group as the dimension and show in that was instead of a stacked