Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stefania_f
Contributor II
Contributor II

Background color expression

I have a measure called "Total Value".

I want the background to turn red if "Total Value" <0, Green otherwise.

Which expression should I include in the properties of the measure, corresponding to the "Background color expression"?

Thanks

2 Replies
vunguyenq89
Creator III
Creator III

If(Expression <0,Red(),Green())

Replace Expression with your expression

Red() and Green() are standard color functions. You can also use RGB() or ARGB() for customized colors

yoganantha321
Creator II
Creator II

If you showing in chart, Then Try this

Then in properties of the expression or dimension click on + symbol background color you can use

=if(Total Value field <0,Red(),Green())