Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
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

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

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

Hi Jagan

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

kind regards

Nayan

Highlighted
MVP & Luminary
MVP & Luminary

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

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

Hi All

Thank you for your help.  It worked.

kind regards

Nayan

Highlighted
Partner
Partner

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