topic Re: change colour to expression column in QlikView

change colour to expression column

Thu, 17 Jul 2014 01:33:22 GMT

Does anyone know what I have to do to change the colour of my expression column?

I went to Expressions> my column > Properties > "Background colour" but it's dimmed out.

Thu, 17 Jul 2014 01:50:50 GMT

Hi,

You mean you're not able to double click on the property "Background Color" and add your color expression ?

Thu, 17 Jul 2014 01:56:41 GMT

I double clicked it but it went to the expressions box.

I'm one step closer though. I did find a "Colour" function - so then where is library of colour names or numbers? I used

"=Colour(Yellow)" and got black.

Thu, 17 Jul 2014 02:03:14 GMT

The Color() function needs an index as parameter like: Color(145).

You can use the RGB(x,y,z) function for example, or built-in functions like Red(), Yellow(), etc...

Search in QlikView help for "Color Functions", you'll get a list of what you can use.

jagan — Thu, 17 Jul 2014 02:05:08 GMT

Hi,

Give expression like this

=Red()

=Green()

=Yellow() or some other builtin functions.

=RGB(N, N, N) -- Replace N with a number ranging from 0 to 255.

Hope this helps you.

Regards,

Jagan.

Thu, 17 Jul 2014 02:12:51 GMT

Thanks jp and Jagan! I'll give them a go and search for "color functions".