topic Re: Display negative numbers in brackets in script only in QlikView

Display negative numbers in brackets in script only

Mon, 22 Apr 2013 09:35:06 GMT

Hi team,

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

Thanks

Fri, 26 Apr 2013 06:26:22 GMT

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

Fri, 26 Apr 2013 06:40:19 GMT

Can you ellaborate?

swuehl — Fri, 26 Apr 2013 07:53:48 GMT

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

];