Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I add color through scripting?


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

4 Replies
Not applicable
Author

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.

Not applicable
Author

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.

Not applicable
Author

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.)

Not applicable
Author

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

Thank you.