Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!