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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Godtooro
Contributor II
Contributor II

Values negative to positive and viceversa

Dear al!!

I have a table with positive and negative values. Do you know how I can convert negatives in positives and viceversa?

Thank you for your support.

Labels (1)
3 Replies
kalyanamharish
Contributor III
Contributor III

Hi,

Load * Inline
[
Numbers
100,
-222,
111,
-22,
10,
11,
-20,
22
]
Use =Fabs(Numbers) for converting everything into positive
Use =Fabs(Numbers) *-1 for converting everything into negative.
Kushal_Chawda
MVP
MVP

Just simply multiply your column or expression with -1 (Column/expression *-1)

 

Godtooro
Contributor II
Contributor II
Author

Thank you very much for your support!

Appreciate.