Discussion board where members can get started with QlikView.
I am trying to show values in my X axis as positive figures - I only want these figures to "appear" positive and not actually be positive.
Please see below:
Use fabs() function.
Use Fabs() like below
Hope this helps you.
using fabs gives me the below graph.... I want the negatives to still be negative, just appear as though they aren't - just need to get rid of the "-"
Then try something like this
Go to Expression Tab
Click + on your expression
Go to Bar Offset
Add whatever is the Min Value of your Expression
in your case it looks like -5... so write 5 in bar offset..
The colour of my bars have now disappeared and the scale at the bottom is still showing negative numbers
this will give me positive numbers - I need the negative numbers to be negative but not show the "-"
In excel I would use custom formatting and say (#,##0;#,##0,"-")