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

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
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

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

Or

-1 * YourExpression

View solution in original post

4 Replies
sunny_talwar
MVP
MVP

Multiplying with -1 should do it, right?

-1 * YourField

sunny_talwar
MVP
MVP

Or

-1 * YourExpression

avinashelite
MVP
MVP

Try

-1*your-expression  as stalwar1‌ suggested

Anonymous
Not applicable
Author

Worked

Thanks alot Sunny!