topic Text color for a dimension in QlikView

Text color for a dimension

Thu, 04 Aug 2011 14:35:54 GMT

Hi,

I have a straight table chart where I am trying to change the text color for one of the dimensions using this:

=if(project_health_code='Green', green (), 'Yellow', yellow (), 'Red', red(), Black ())

Does anyone have any idea what's wrong with my syntax? If the dimension value is green, I want the text display in green, yellow, yellow, etc.

This works:

=if(project_health_code = 'Green', green(), Black()) but only for one color/value.

Anonymous — Thu, 04 Aug 2011 14:53:18 GMT

Hi guy,

you can use multiple if like this :

if(Sum (val1)='Green', green (), if(Sum (val1)='Yellow', yellow (), if(Sum (val1)='Red', red(), Black ())))

I think that there is a smarter way to do this. I have a look and let you know.

Anyway you could use this for the moment. It might be working.

Regards.

Thu, 04 Aug 2011 15:03:42 GMT

Hi,

It said that teh expression was ok but it did not change the color of my text.

Anonymous — Thu, 04 Aug 2011 15:50:12 GMT

you have to change the expression :

don't use my expression, it was just an example.

but use :

if( project_health_code='green' , green(), if(project_health_code='Yellow', Yellow(), if (project_health_code='Red',Red() ,Black())))

regards

Thu, 04 Aug 2011 16:28:28 GMT

Thanks, this works.