Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Showing negative as a positive

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:

Picture12.png

Picture13.png

Picture14.png

8 Replies

Re: Showing negative as a positive

Use fabs() function.

Regards

ASHFAQ

MVP & Luminary
MVP & Luminary

Re: Showing negative as a positive

Hi,

Use Fabs() like below

Fabs(Sum(Sales))

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: Showing negative as a positive

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 "-"

Picture1.png

MVP
MVP

Re: Showing negative as a positive

Fabs(YourExpression)

Re: Showing negative as a positive

Then try something like this

If(Sum(Sales)>0,Sum(Sales)

Regards

ASHFAQ

MVP
MVP

Re: Showing negative as a positive

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..

Not applicable

Re: Showing negative as a positive

The colour of my bars have now disappeared and the scale at the bottom is still showing negative numbers

Not applicable

Re: Showing negative as a positive

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,"-")