topic set rgb colour in script in QlikView

set rgb colour in script

charlotte_qvw — Tue, 10 May 2011 06:46:39 GMT

Does anyone know if it's possible to set a colour in the qv script e.g., if a field='xyz', rgb (255,255,255)? Many thanks, Charlotte

set rgb colour in script

Tue, 10 May 2011 06:53:51 GMT

Yes this is possible

RGB(255,255.0) for example

Greetz,

Dirk

set rgb colour in script

charlotte_qvw — Tue, 10 May 2011 06:58:25 GMT

Ok, but how can i put that round a field I'm loading in the script, eg

Load

if(Fieldx = 'Blank', rgb(255,255,255), rgb(0,0,0))

what i would like is if Fieldx = Blank to load it in white colour, otherwise to load the field in balck colour. I know that I can do this in the chart properties, text format for my dimension, but it doesn't work when there are no values for fieldx when it's = Blank. So I would like to do it in the script.

thanks

set rgb colour in script

Tue, 10 May 2011 07:03:19 GMT

Why should you load a color in a script.

Maybe just put the value in the field. for example

fieldvalue1 = "255"

fieldvalue 2 = "255"

fieldvalue3 = "0"

and when you want to use them, RGB(Fieldvalue1,Fieldvalue2,Fieldvalue3)

Is that a sollution for you?

Greetz,

Dirk

set rgb colour in script

Thu, 22 Sep 2011 07:13:51 GMT

Hi,

Did you ever find a way to define color in the script?

Re: set rgb colour in script

nathanfurby — Thu, 22 Sep 2011 09:30:01 GMT

I'm not sure why you'd want to do this in the script when you can do it in the chart but see the attachment for a couple of examples.

Suppose it makes sense to create a variable that stores colour - would save you having to type out e.g. RGB(255,255,0) and remember the numbers all the time.

Re: set rgb colour in script

Thu, 22 Sep 2011 09:56:14 GMT

thanks for your reply

the reason I want to define a color in the script is because I need to use it in many charts.

In your way- everytime you add the Item as a Dim into a chart you must go and set its background settings

I want, for example, all positive values to show in font color green in all charts all over the gui.

Re: set rgb colour in script

nathanfurby — Thu, 22 Sep 2011 10:07:18 GMT

I don't think that is possible