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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2012-09-20 02:57 AM

Change Positive Number to Negative and Vice Versa

Hi,
I need to change positive number to negative, and positive number to negative in the same column.
Any suggestion?
Amount
923.54
-455.60
835.65
to
Amount
-923.54
455.60
-835.65
Regards
Benjamin Marcus
Labels (2)
Labels
291 Views
0 Likes
2 Replies
Anonymous
Not applicable
‎2012-09-20 03:14 AM
Author

you can use the function "Mathematical.NEG()" in tmap
291 Views
0 Likes
alevy
Specialist
Specialist
‎2012-09-21 03:48 AM

Just have expression -<column name> e.g. -row1.myNum.
For BigDecimals, use row1.myNum.negate().
291 Views
0 Likes