Text Color Expression Error

[AO1]

Hello!

I have a pivot table in Qlik that includes a Percentage column. The percentage column is calculated based on other columns in the table. 

I want this column to color code based on the returned result (above 70% should be GREEN and below should be RED). 

Below is my expression, but I am receiving an error.

if([Column('Productivity Percentage')] > 70, green(), red())

What is the proper way to write this expression? 

Thank you!

[Dana_Baldwin · Accepted solution]

Hi @AO1 

Please note the forum you have posted to is for the Data Integration product Enterprise Manager, used for managing multiple Replicate/Compose/Catalog servers. To reach your target audience, please consider posting your question here: https://community.qlik.com/t5/Qlik-Sense/ct-p/qlik-sense

Thanks,

Dana

[AO1]

Oh, that was my oversight. I will repost, thank you!!