coloring of total depending of numbers (Background... - Qlik Community

lessassy · ‎2020-03-13

Hello everyone,

I have a straight table

the column circled in red contains percentages. The cells are green when the objective is reached. The last line shows the total for the column (number is 35%). I want the column to be green when the taotal is greater than 50%. And I want it to be red when the percentage is less than 50%.

Anyone can help me. Thanks

ee

Brett_Bleess · ‎2020-04-08

What is really needed in these cases is the actual QVW file, there are some other posts in Community regarding this very setup though, so if you have not searched for prior posts, I would recommend doing that on this one, as I know there are some out there.

Try the following post:

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Text-Color-Expression-not-working-in-to...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

usamabinsadiq · ‎2020-04-08

Hi,

I think this might help,

if([Column Name] <= 0.5, RGB(255,0,0), green())

if my replay helped you then please press like button and do not forget to press the "Accept as Solution" button.

coloring of total depending of numbers (Background color)