topic Re: How do I add color through scripting? in QlikView

How do I add color through scripting?

Fri, 14 Nov 2014 20:58:41 GMT

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

Re: How do I add color through scripting?

Fri, 14 Nov 2014 21:25:52 GMT

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.

Re: How do I add color through scripting?

Fri, 14 Nov 2014 21:35:40 GMT

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.

Re: How do I add color through scripting?

Fri, 14 Nov 2014 21:38:21 GMT

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

Re: How do I add color through scripting?

Fri, 14 Nov 2014 21:46:49 GMT

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

Thank you.