Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Display negative numbers in brackets

Hi

On the front end, I want to show negative numbers is brackets.

for eg, the number   -1,100.65 , I want to display it as (1,100.65)

How do i do that?

Please help

kind regards

Nayan

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Display negative numbers in brackets

On the Number tab of the properties screen select your expression and check Fixed to under Number Format Settings. Set the format pattern to #.##0,00; (#.##0,00)


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
Highlighted
Partner
Partner

Re: Display negative numbers in brackets

Try this

=if(a < 0, '(' & fabs(a ) & ')', a)

where can be a list box or input field.

change  to list box or input field or value you have.

Highlighted
Not applicable

Re: Display negative numbers in brackets

Hi Jagan

Thanks.  I will try it out and let you know.

kind regards

Nayan

Highlighted
MVP & Luminary
MVP & Luminary

Re: Display negative numbers in brackets

On the Number tab of the properties screen select your expression and check Fixed to under Number Format Settings. Set the format pattern to #.##0,00; (#.##0,00)


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Partner
Partner

Re: Display negative numbers in brackets

Hi:

In general, copy the format from Number tab in Object Properties or Document Properties. This time, I typed those brackets and erased the minus sign. It works. If it is not currency, just erase the € sign.Formats.jpg

Highlighted
Not applicable

Re: Display negative numbers in brackets

Hi All

Thank you for your help.  It worked.

kind regards

Nayan

Highlighted
Partner
Partner

Re: Display negative numbers in brackets

I've noticed this post while searching for a solution for my problem (Displaying negetive percentage values as (##%)).

Do you know why the standard aproach that you've suggested does not work for percentage values?

Would appreciate an expert's feedback.

Regards,

Vladimir