Displaying color only in field

[#1]

Hi

I have an expression field which I am only using for a color code, green for ok, orange for warning, red for problem fo example.

I have added the color, but there is a "-" displaying as well. I have tried adding a space as value.

How can I get rid of the "-"

[Chanty4u]

can u eloberate  clearly  with sample?

[marcus_sommer]

I think the "-" means that there is NULL and unfortunately you couldn't to color it. This meant you need to replace the NULL with real values like 'NULL' or 'MISSING' - here you will find an excellent guide for these topic: NULL handling in QlikView.

- Marcus

[Kushal_Chawda]

On Chart Properties->Presentation Tab ->replace the hyphen in null symbol and missing symbol by space

[Chanty4u]

add to ur exp

If(len(trim(urexp)>0))

[#6]

I think my question was a bit stupid, I was not bring through a value in the field, I just wanted a colour in the field, I just added =' ' as the expression value. Seems to work Sorry guys

[#7]

My one works as well, but I never saw this option. Think I am rather going to use yours. Thanks

[#8]

Works for Dimensions but not for Expressions, but a great answer, and it will be very helpful in future

[Chanty4u]

Hmmm coooooool  No issues

[#10]

This was just a field which I wanted to have no value in the field but just have a backbround color, in the backbround color I used an expression. So I just added a value on the Expressions itselfof = ' ' and then had my background color expression