topic Re: Change negative to () help.!!! in QlikView

Change negative to () help.!!!

amit_saini — Mon, 27 Jan 2014 10:10:24 GMT

Hi Folks ,

I need to covert all negative numbers in my pivot table to () for example -8.3 should appear as ()8.3. Any idea how to do it.

At present my number format is #.##0,0

Thanks in Advance.!!!

Re: Change negative to () help.!!!

rustyfishbones — Mon, 27 Jan 2014 10:12:42 GMT

you could use FABS Function around the Expression.

or change the number format to

'#.##0,0;(#.##0,0)'

Re: Change negative to () help.!!!

Mon, 27 Jan 2014 10:20:33 GMT

hi,

Try using

if(Sum(exp)<0, '()'&fabs(sum(exp)), sum(exp))

HTH

-Shruti

Re: Change negative to () help.!!!

AbhijitBansode — Mon, 27 Jan 2014 10:20:52 GMT

use below:

Replace(FieldName,'-','()')

for simple presentation change. It won't affect total sums.

Re: Change negative to () help.!!!

Mon, 27 Jan 2014 10:22:33 GMT

As Alan said, modify your number format.

expression for >0 number ; (semi colon) expression for < 0 numbers

so you will have:

num(your exp, '#,##0.0;(#,##0)', '.', ',')

Fabrice

Re: Change negative to () help.!!!

Mon, 27 Jan 2014 10:25:34 GMT

try to use fabs() function

example-

='()' & fabs(-8.3)

then output is

()8.3

hope this helps you.

Re: Change negative to () help.!!!

sudeepkm — Mon, 27 Jan 2014 10:32:22 GMT

Type the number format like below

Re: Change negative to () help.!!!

NareshGuntur — Mon, 27 Jan 2014 10:35:31 GMT

Hi Amit,

Why don't you use

=if(Sum(Sales)<0,'('&Sum(Sales)&')',Sum(Sales)).

Cheers,

Naresh

Re: Change negative to () help.!!!

amit_saini — Mon, 27 Jan 2014 10:36:42 GMT

Thanks Alan it worked fine .

Re: Change negative to () help.!!!

rustyfishbones — Mon, 27 Jan 2014 10:41:36 GMT

Hi Amit,

Please mark the answer as Correct and also any other helpful answers, it will help other users find the answers they are looking for too

Thanks

Alan