Pie charts does not support negative values.
Either do sum(fabs(Score)) in your chart, not fabs(sum(Score)) since the total sum does not have to be negative, as for Japan.
I think you want the sum of absolute values, not the absolute sum of values?
However, you could do something similar to this in your script for better UI performance:
LOAD * INLINE [
5 EU, 141.181
,num(PurgeChar(Score, '-')) as ScoreInverted
,money(PurgeChar(Score, '-')) as ScoreInvertedMoney
drop table 1;
See attached solution File.
My solution is to change the dimension, so that the measure in calcluated in the dimension.
I added the repeat function so that the alligned is better (although nog perfect)
Country &Repeat(' ',20-len(Country)-len(AGGR(sum(Score), Country)))&AGGR(sum(Score), Country)
TestQlikView legend with neg.qvw 141.8 K