Display negative numbers in brackets in script only

[#1]

    Hi team,

I want to show  negative numbers in brackets in qlikview script not in desgin part

Thanks

[#2]

Hi,

In the Properties Tab of the chart,

Goto Number Tab,sleect the expression

goto Fixed to and paste the below format in the format pattern.

#.##0,00; (#.##0,00)

Regards,

Snehal Nabar

[#3]

Can you ellaborate?

[swuehl]

You can use num() function to format your numbers, and you can use this function in the script as well as in the frontend:

SET ThousandSep=',';

SET DecimalSep='.';

LOAD Number,

                  num(Number,'##0.00;(##0.00)') as NumberFormatted

INLINE [

Number

-12.3454

323.43

];