topic Re: Display negative numbers in red color with Num() function in QlikView

Display negative numbers in red color with Num() function

gamaplast — Sat, 03 Jan 2015 13:24:23 GMT

Hi,

as the object, I'd like to display negative numbers with red color using the num() function:

NUM(Value,'#.##0,0%;')

Sorry if it is a documented issue...i wasn't able to find it.

Thanks,

Colin-Albert — Sat, 03 Jan 2015 13:26:52 GMT

this should work

NUM(Value,'#.##0,0%; -#,##0,0%')

gamaplast — Sat, 03 Jan 2015 13:37:09 GMT

Sorry, it doesn't work:

=NUM(0.05,'#.##0,0%; -#,##0,0%')

Shows 5,0%

(OK)

NUM(-0.05,'#.##0,0%; -#,##0,0%')

Shows -5,000,0%

(NOT OK)

Thks.

Colin-Albert — Sat, 03 Jan 2015 13:39:15 GMT

My mistake,

this should work

NUM(Value,'#.##0,0%; -#.##0,0%')

The wrong version has two commas, not a point and a comma

gamaplast — Sat, 03 Jan 2015 13:46:05 GMT

Right, now it shows the numbers correctly, but it isn't red for the negative ones, as I wish...

Colin-Albert — Sat, 03 Jan 2015 13:46:14 GMT

You can use Visual Cues on the chart to set the colours.

gamaplast — Sat, 03 Jan 2015 14:03:14 GMT

Sorry, I must use the Num() function 'cause I display the values in a text box...

Colin-Albert — Sat, 03 Jan 2015 14:11:15 GMT

In a text box, you can use a calculated colour on the Font Tab.

Click "Color" on the font tab, then add the expression in the Calculated box and enable the Calculated option

gamaplast — Sat, 03 Jan 2015 14:14:38 GMT

Ok, this time the workaround if fit for me 😉

Thanks a lot.