change minus sign

[#1]

hi, how to remove minus sign from minus values in a chart column.

as an example: -42980482 ---> (42980482)

[bgerchikov]

Hi,

you can use fabs() function.

fabs(-42980482) =42980482

Hope it will help.

[#3 · Accepted solution]

Hi,

You can use this #,##0;(#,##0) in the Number tab for the required column in your chart.

-ve values will be shown in brackets instead of showing "-" symbol

Regards

Swetha

[#4]

can i give brackets to minus values?

[bgerchikov]

Hi,

You can try something like that:

=num((Amt),'######;(####)')

Regards!

[jagan]

Hi Dushan,

Try like this

=Num( -42980482, '###0;(###0)')

Qlikview takes First ###0 if Number is Positive

Qlikview takes Second (###0) if Number is Negative.

Regards,

jagan.

[amit_saini]

Hi Dushan,

Go to the chart properties ---> Number Tab and mentioned this in Format pattern :  #.##0,0;(#.##0,0)

Thanks,

AS

[er_mohit]

Try this

='(' & fabs(Fieldname)&')'