topic Turn Positive into negative in QlikView

Turn Positive into negative

Anonymous — Tue, 27 Sep 2016 13:54:28 GMT

Hi All

I know this would convert negative to positive

Fabs(Num(ArrearsAmount,'-000000')) as ArrearsTest,

Is there a way to convert from Positive to negative

I am trying to show example

09/2016 arrears was £10 i want this to show -£10

so my barchart can go below 0

Thanks

sunny_talwar — Tue, 27 Sep 2016 13:55:57 GMT

Multiplying with -1 should do it, right?

-1 * YourField

sunny_talwar — Tue, 27 Sep 2016 13:56:45 GMT

-1 * YourExpression

avinashelite — Tue, 27 Sep 2016 14:02:12 GMT

Try

-1*your-expression as stalwar1‌ suggested

Anonymous — Tue, 27 Sep 2016 14:02:31 GMT

Worked

Thanks alot Sunny!