topic Re: Showing negative as a positive in QlikView

Showing negative as a positive

Mon, 15 Sep 2014 08:45:10 GMT

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:

Re: Showing negative as a positive

ashfaq_haseeb — Mon, 15 Sep 2014 08:48:20 GMT

Use fabs() function.

Regards

ASHFAQ

Re: Showing negative as a positive

jagan — Mon, 15 Sep 2014 08:51:08 GMT

Hi,

Use Fabs() like below

Fabs(Sum(Sales))

Hope this helps you.

Regards,

Jagan.

Re: Showing negative as a positive

Mon, 15 Sep 2014 08:54:56 GMT

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

Re: Showing negative as a positive

MK_QSL — Mon, 15 Sep 2014 08:55:03 GMT

Fabs(YourExpression)

Re: Showing negative as a positive

ashfaq_haseeb — Mon, 15 Sep 2014 08:57:43 GMT

Then try something like this

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

Regards

ASHFAQ

Re: Showing negative as a positive

MK_QSL — Mon, 15 Sep 2014 08:58:10 GMT

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

Re: Showing negative as a positive

Mon, 15 Sep 2014 09:02:22 GMT

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

Re: Showing negative as a positive

Mon, 15 Sep 2014 09:03:24 GMT

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