Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
What do I do wrong?
=if(('%)<1,red())
Thank you
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.
Are you using the same measure expression for color what you have used to calculate % value?
is your expression says ok?
=if((%)<1,red())
yes
I tried all options and all red
=if(('%')<0.1,red())
=if(('%')<0.01,red())
=if(('%')<1,red())
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.