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: 
Anonymous
Not applicable

Change colors on rows

I have made a pivot table to show a list of employees and whether or not they are approved. The value in the data model  is actually an integer. If the sum of this value is grater than 0 for a certain employee then he or she is approved. This value is named "Result".

The dimension for the  pivot table is the name of the employee.

The expression I have written is: IF(SUM(Result)>0, 'Approved', 'Not approved')

The pivot table show the values as "Approved" or "Not Approved" just as i intended. I would however also like to add colors to the rows. I would like for it to be green if it is approved, and red if it is not approved. Does anyone know how to do this?

I tried getting colors by using the "Visual Cues", but as I have changed the value shown to text messages I did not get it to work. It is however working if I just output the original integer values, by using the expression SUM(RESULT). 

Untitled.png

1 Solution

Accepted Solutions
aveeeeeee7en
Specialist III
Specialist III

Hi Dagrun

Try using Backgroung Color.

Use Condition:

IF(SUM(Result)>0, RGB(255,0,0),RGB(0,255,0))

g.png

Regards

Aviral Nag

View solution in original post

3 Replies
aveeeeeee7en
Specialist III
Specialist III

Hi Dagrun

Try using Backgroung Color.

Use Condition:

IF(SUM(Result)>0, RGB(255,0,0),RGB(0,255,0))

g.png

Regards

Aviral Nag

Not applicable
Author

Dear Dagrun,

Go into the expression tab, click on + sign for Results and in text add the following syntax:

if(Column(1) = 'Approved', Green(), Red())

For more info please see screen print.

R

avinashelite

Hi Dagurn,

Please try as told by Aveeeeeee7enits the concept you need to follow.


If you face any issues please let us know.



Regards,

@vi