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: 
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

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.