Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Turn Positive into negative

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

1 Solution

Accepted Solutions
4 Replies
sunny_talwar

Multiplying with -1 should do it, right?

-1 * YourField

sunny_talwar

Or

-1 * YourExpression

avinashelite

Try

-1*your-expression  as stalwar1‌ suggested

Anonymous
Not applicable
Author

Worked

Thanks alot Sunny!