Discussion Board for collaboration on QlikView Scripting.
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 "-"
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.
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
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