Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

background color expression

Hi Community,

may I create a formula using the label of a measure?

I would like create a backuground color expression:

if(Target > Percentuale, 'green', 'red')

Immagine.png

7 Replies
Highlighted
Champion II
Champion II

Have you tried yet?

IF(Target > 0.85,green(),red())

or you can use RGB() values

Highlighted
Creator III
Creator III

yes

write that if condition in Backgroup Expression of the Field

e.g.

Highlighted
Partner
Partner

Hi,

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())

Highlighted
Partner
Partner

Hi,

Hi,

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())

Highlighted
Partner
Partner

ops,

CUSTID AND TARGE

ARE CALCULATED FIELDS WITH NESTED IF STATEMENTS AND THAT'S WHY I WANT TO USE THE TAG

Highlighted
Creator III
Creator III

That would work on new field as well in the same way

something like this

Highlighted
Specialist III
Specialist III

Hello Fabio,

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!

Thank you!

Rahul