background color

[AmirKilkr]

Hello,

What do I do wrong?

=if(('%)<1,red())

Thank you

[Digvijay_Singh]

Are you using the same measure expression for color what you have used to calculate % value? 

[Chanty4u]

is your expression says ok?

=if((%)<1,red())

[AmirKilkr]

yes

I tried all options and all red

=if(('%')<0.1,red())
=if(('%')<0.01,red())
=if(('%')<1,red())

[Vegar · Accepted solution]

Try this.

if ([Sum - Total Price Before Vat]<0.01,red())

Assuming you are using a master item measure and a newer version of Qlik Sense, if not then replace the [Sum - Total Price Before Vat] with the actual expression that you want to compare.