Discussion board where members can get started with Qlik Sense.
may I create a formula using the label of a measure?
I would like create a backuground color expression:
if(Target > Percentuale, 'green', 'red')
Have you tried yet?
IF(Target > 0.85,green(),red())
or you can use RGB() values
write that if condition in Backgroup Expression of the Field
I explained bad. The color of the field is not on Target but on new field.
CUSTID TARGET newfield
3 20% background color expression
7 15% background color expression
On new field I would like to insert an expression to color the background of the cell
if CUSID > TARGET, red(), green())
CUSTID AND TARGE
ARE CALCULATED FIELDS WITH NESTED IF STATEMENTS AND THAT'S WHY I WANT TO USE THE TAG
That would work on new field as well in the same way
something like this
I agree with Giriraj. You can define a new dimension in Table with Blank field value and assign a Background color expression as If(<Condition of your choice>, <Color code for pass>, <Color code for fail>) e.g. If(Time > 4, Green(), Yellow())
Hope this will help!