How to get negative data point values to show on top for a bar chart?

[#1]

Qlikview 11

1. How to get negatve data point values to show on top for a bar chart?

When I select 'Values on Data Points', the positive values show up on top, but not the negative values.

My scale is showing only 0 to 100%.  So the negative value data points do not display.  I wouldn't mind showing the negative values however I don't know how to make the scale different for negative values (<0) and positive values (>0).  The negative values in my data set are as low as -3,000%, however my highest positive value is 100%.  So the scale

Help please!

[#2]

BTW, I get 0.0% just for the negative numbers.

What is that last part of the expression supposed to do 0.000010?

I don't understand why I am not able to get to work?

[#3]

I figured out why I was getting 0.0% instead of a negative value %.  I had the number formatted, so I changed it to expression default.

I have added the hidden field but now my sort order is all wrong?

[#4]

I think this would be a great solution if there was a way to sort all the values (see example)?

The sample I provided worked out because the dates increased with the value amounts.

Unfortunately, my real data set is not going to work out that way.  Any help would be greatly appreciated.

[swuehl]

Just try a sort by expression in sort tab using

=Value

[#6]

No luck, I have already tried that.

[swuehl · Accepted solution]

Seems to work at my side, see attached. I am using QV11.

It should also be possible to sort by y-value, using this as hidden expression:

=num(Value,'#0.0%')

and set static min for axis scale to 0

[#8]

Awesome thank you!