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
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here
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: 
Not applicable
‎2014-12-16 09:09 AM

FORMAT


I would like to convert the number -13,78% to (13,78%)

Thanks

669 Views
0 Likes
1 Solution

Accepted Solutions
nicolett_yuri
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2014-12-16 09:11 AM

Use Num() function

ex:

Num(Field, '#.##0,00%;(#.##0,00%)')

View solution in original post

619 Views
0 Likes
2 Replies
nicolett_yuri
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2014-12-16 09:11 AM

Use Num() function

ex:

Num(Field, '#.##0,00%;(#.##0,00%)')

620 Views
0 Likes
Not applicable
‎2014-12-16 09:14 AM
Author

In response to nicolett_yuri

Thanks a lot Yuri

619 Views
0 Likes