topic Negative number format in QlikView

Negative number format

guya — Wed, 20 Jan 2010 16:42:33 GMT

All,

I would like to display negative number in brackets and red if possible in a pivot or straight table.

Is this possible?

With many thanks,

Guy

Negative number format

Wed, 20 Jan 2010 16:58:38 GMT

Use someting like this as expression:


=if(YourValue<0,'(' & YourValue & ')', YourValue)

Replace YourValue with your value... tell me about it

The color can be done in the "Visual Cues".
Beware: Adding brackets changes the Number Format to a Text Format and the Visual Cue "<= 0" wont work for formatting it red!

Greets

AW:Negative number format

Wed, 20 Jan 2010 17:28:03 GMT

Hi,

sorry but no wou won't do that with an if.

Go to the Properties of the chart, then to tab "Number", point to the Formula you would change, choose a format i.e. "fixed to 2 decimals" the format pattern shows #.##0,00. Then you add ";(#.##0,00)" to that pattern. The pattern after the ";" is for negative values.

For the colour, you go to tab "Visual Cues" and point again to the Formula you would change and write a 0 (zero) in the input box after "lower <=". Then choose a colour and say O.K.

Have Fun with QV

Alex:)

AW:Negative number format

guya — Wed, 20 Jan 2010 18:09:48 GMT

Thanks for your prompt reply.

Alex, the final format looks like this #,##0.00;(#,##0.00) and works fine - Thx. I tried the same for percentage result but with no success.

I used this format #,##0.00%;(#,##0.00%) and the result changed. e.g the number -21.86% becomes (0.22%).

Any idea?

Guy

AW:Re: AW:Negative number format

Wed, 20 Jan 2010 18:26:08 GMT

This happens, in my example, when the decimal/Thousand seperator in the pattern differs from the separators in the pattern.But I'm not shure about that.

Alex:)

AW:Re: AW:Negative number format

Wed, 20 Jan 2010 18:29:53 GMT

Oops that was wrong,

try: #.##0,0%;(#.##0,0)%

Have Fun with QV

Alex:)

AW:Re: AW:Negative number format

guya — Wed, 20 Jan 2010 19:28:38 GMT

It works fine!

Thanks a lot.

Guy

Negative number format

Wed, 18 Jan 2012 08:18:16 GMT

Sorry for commenting on an old post.

I am trying to show minus brackets on Gauge chart but it only converts the value to (1.0)% rather than (100)%. I have used the formating: #.##0,0%;(#.##0,0)%.

And the negative formating works fine on straight table but not on Gauges

Can you please help..

regards

Buti

Negative number format

vijay_iitkgp — Wed, 18 Jan 2012 08:43:48 GMT

Hi,

one work around. Go to Chart Properties---> Number. Check Integer and then check show value in %. after that uncheck integer and check money. you will get desired result.

Negative number format

Wed, 18 Jan 2012 09:00:49 GMT

Hi Vijay

Stil not getting the desired results.

regards

Re: Negative number format

vijay_iitkgp — Wed, 18 Jan 2012 09:35:05 GMT

Hi, Please see the image . Hope you wat this result only.

Negative number format

Wed, 18 Jan 2012 09:53:03 GMT

Thanks Vijay

This is exactly what I am looking for. I did miss a few things but got it sorted.

thanks