How do I add color through scripting?

[#1]

I have a column that I what the values to be RED if they are greater than zero. How do I do this?

[#2]

If you want very simple option use the "Visual Cues" tab.

For more complicated scenarios If you click the + sign to the left of your expression QlikView will give you a drop down of options. Click on "Text Format" and you can then add expression you want:

=If (FieldValue > 10 and FieldValue<17, RED(), IF ( FieldValue >= 17 and FieldValue <=100, RGB(128,28,105)))

Notice there are some colors that you can just call like RED() or you can use RGB function and utilize any color you want.

[#3]

Hello.

I am using a Table Box so I do not have these options nor do I have an expression. That is why I requested a way to do this thru scripting.

Are you stating that I need to change the output display?

Thank you.

[#4]

Yes. If you use a Chart you have a ton more options and control of your look and feel (color, format like bold, background color etc.)

[#5]

I did not set up the data so I will now change it to a Chart.

Thank you.