Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 "-"
can u eloberate clearly with sample?
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
On Chart Properties->Presentation Tab ->replace the hyphen in null symbol and missing symbol by space
add to ur exp
If(len(trim(urexp)>0))
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
My one works as well, but I never saw this option. Think I am rather going to use yours. Thanks
Works for Dimensions but not for Expressions, but a great answer, and it will be very helpful in future
Hmmm coooooool No issues
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