Formatting Negative Numbers

[da_pagnott]

Hello!

I need to set a red format to negative numbers in one table inside my dashboard.

I tried to set the format but without success. Could you please help me?

Actually this is my format:

#.##0 €;-(#.##0 €)

I'd like to set in red negative values.

Thank you!

[OmarBenSalem]

Your aim is not clear.

Can you elaborate what u have and want to have with a screen shot maybe?

[Gysbert_Wassenaar · Accepted solution]

It's not possible to set the color with the format string. If you're using a KPI object you can enable the Conditional colors option of the measure(s) and specify which values should get which colors. In a table object you can use the Text Color expression option of the measure(s) for that purpose.

[da_pagnott]

Great I made it!

One more question about it please. I made the formula to mark in red negative numbers and it works.

This is my expression (to fill the table column):

=sum({<DocDta = {"$(=yesterday)"}>} TotalBalance)

And this is the expression to mark in red negative values:

If(sum({<DocDta = {"$(=yesterday)"}>} TotalBalance)<0,red())

Do I have any way to make the second expression shorter instead of writing again the expression of the column?

I mean something like that:

If(FORMULA RESULT<0,red())

Thank you for your help!

[thannila]

Hi,

Use the text color option while writing the measure in qlik sense straight table object.

if(sum(amount)<0,red())

[OmarBenSalem · Accepted solution]

Put the expression in a variable and call the variable

if($(vForumla)<0,red())

[da_pagnott · Accepted solution]

Ok, thanks!!

Just to close this post, I find this video to know how to set a variable.

https://www.youtube.com/watch?v=uFT-PNf_z9g