Stacked Bar Chart Total does not include negative values

[kgwen100]

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?

[dplr-rn]

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