Number format help

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

In straight table for value of usage dimension I have some negative values.

these values I have to represent in bracket with red color like below.

Please help me on this.

Thanks in advance.

[jaumecf23]

You can do a Calculated dimension using the Fabs() function. This function converts the negative values to positive.

Fabs(Field_Name)

[mahitham]

Hi,

Thanks for your reply .

Its converting negative to positive but that negative conversion values need to show like (93.27) by highlighting in red font.

[palanimurugan]

Hi..

Use below expression.

For Convert Positive Value:

=Num(fabs(Your_Column Name),'###.0')

For Changing color:  (Please click the expression tab and select the text color add below expression

=if(Your_column_Name<0,RGB(255,0,0))

)

[ali_qlikview · Accepted solution]

Hi,

Can you try something like this

Suppose A is the field or Expression Then

=if(A<0,NUm(Fabs(A),'(#,##0)'),Num(A,'#,##0'))

for the color you can use text color option:

if( A<0,red(),Green())

Thanks,

Mukram.

[kaanerisen]

Hi Mahitha

You can do that by using format pattern on chart measure settings.

[kuczynska]

Yeah, I would follow Kaan's approach rather than using the absolute value function fab().