Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
I want to show negative numbers in brackets in qlikview script not in desgin part
Thanks
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
Can you ellaborate?
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
];