topic Text Color Expression Error in Archived Discussions

Text Color Expression Error

AO1 — Tue, 31 Dec 2024 21:09:35 GMT

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!

Re: Text Color Expression Error

Dana_Baldwin — Tue, 31 Dec 2024 22:10:41 GMT

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

Re: Text Color Expression Error

AO1 — Thu, 02 Jan 2025 13:31:24 GMT

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