Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
LP27
Creator II
Creator II

Conditional color formatting on percentage

Hi Folks,

I have straight tabel,

I am creating If condition as -

 if([Defect Code - Desc] = 'N/A', 'No', (1-(sum(DefectValue)/Sum([Measures.1.1 Scrap QAP(s900)])*100)))

This condition works well and it produces  a percentage in column as  shown below-

Percentage
100%
95%
85%

 

Now i need to color  format the percentages in the column as - 

If percentage is below 80% = Red

if percentage is higher than 95% = Green

If percentage is between 80% - 95% = Yellow

 

Not sure how to code this in Straight table, under Background color Expression in Percentage field.

Thanks in advance.

 

Regards,

LP27

 

 

1 Reply
Diter
Contributor III
Contributor III

Hi
May be you can use all formula as:
if(...….*100)))<80, rgb(255,0,0),
if(...….*100)))<95, rgb(255,215,0),
if(...….*100))) >95, rgb(0,128,0))))

hope this help

regards,