topic Re: Setting RGB in QlikView

Setting RGB

Tue, 01 Mar 2016 16:32:58 GMT

if(num(LifSafetyScore) >= 8 and (num(LifSafetyScore) <= 12 ,RED(),

if(num(lLifSafetyScore) >= 13 and (num(LifSafetyScore) <= 18 ,GREEN(),

if(num(LifSafetyScore) >= 18 and (num(LifSafetyScore) <= 22 ,Yellow()))))))

Above script is not working.How can write it ?

Re: Setting RGB

Tue, 01 Mar 2016 16:34:49 GMT

can you let us know where you are writing this script and what type of object you have creating?

any sample QVW that you can post would help us to understand the issue..

Re: Setting RGB

sunny_talwar — Tue, 01 Mar 2016 16:41:05 GMT

Can you try this:

If(LifSafetyScore >= 8 and LifSafetyScore <= 12, Red(),

If(LifSafetyScore >= 13 and LifSafetyScore <= 18, Green(),

If(LifSafetyScore >= 18 and LifSafetyScore <= 22, Yellow())))

UPDATE: I think the issue might be related to the parenthesis

Re: Setting RGB

Anonymous — Tue, 01 Mar 2016 16:41:09 GMT

You seem to have too many parentheses. Try removing the ones in bold from below.

if(num(LifSafetyScore) >= 8 and (num(LifSafetyScore) <= 12 ,RED(),

if(num(lLifSafetyScore) >= 13 and (num(LifSafetyScore) <= 18 ,GREEN(),

if(num(LifSafetyScore) >= 18 and (num(LifSafetyScore) <= 22 ,Yellow()))))))

Re: Setting RGB

Anonymous — Tue, 01 Mar 2016 16:47:57 GMT

Hi Pavana,

Maybe parenthesis issues:

if(num(LifSafetyScore) >= 8 and num(LifSafetyScore) <= 12 ,RED(),

if(num(lLifSafetyScore) >= 13 and num(LifSafetyScore) <= 18 ,GREEN(),

if(num(LifSafetyScore) >= 18 and num(LifSafetyScore) <= 22 ,Yellow() )))

Maurice

Re: Setting RGB

Anonymous — Tue, 01 Mar 2016 17:02:37 GMT

I agree with Sunny T , the issue might be to the parenthesis.

if(num(LifSafetyScore) >= 8 and (num(LifSafetyScore) <= 12 ,RED(),

if(num(lLifSafetyScore) >= 13 and (num(LifSafetyScore) <= 18 ,GREEN(),

if(num(LifSafetyScore) >= 18 and (num(LifSafetyScore) <= 22 ,Yellow()

)

Regards.

Re: Setting RGB

engishfaque — Wed, 02 Mar 2016 04:25:21 GMT

Dear Pavana,

Try this one, I hope you are looking for that one:

if(num(LifSafetyScore) >= 8 and (num(LifSafetyScore) <= 12), RED(),

if(num(lLifSafetyScore) >= 13 and (num(LifSafetyScore) <= 18), GREEN(),

if(num(LifSafetyScore) >= 19 and (num(LifSafetyScore) <= 22), Yellow())))

Kind regards,

Ishfaque Ahmed

Re: Setting RGB

jonathandienst — Wed, 02 Mar 2016 05:03:29 GMT

The num()* function does nothing here, so you can remove it. You can also reduce the number of conditionals, so the expression becomes much simpler:

if(LifSafetyScore >= 8,

If(LifSafetyScore <= 12 ,Red(),

if(LifSafetyScore <= 18 ,Green(),

if(LifSafetyScore <= 22 ,Yellow())))

)

* Num() is a formatting function, and it does not affect the underlying value. The comparisons are on the underlying values so they are not affected in any way by the Num().

EDIT - minor correction to the expression

Re: Setting RGB

Anonymous — Wed, 02 Mar 2016 05:05:47 GMT

if(num(LifSafetyScore) >= 8 and (num(LifSafetyScore) <= 12 ,RED(),

if(num(lLifSafetyScore) >= 13 and (num(LifSafetyScore) <= 18 ,GREEN(),

if(num(LifSafetyScore) >= 18 and (num(LifSafetyScore) <= 22 ,Yellow()))))))

Re: Setting RGB

jonathandienst — Wed, 02 Mar 2016 05:07:14 GMT

If the LifSafetyScore is not being recognised as a number, you may need the Num#()

Num#(<a string>) is the number interpretation function takes a string and outputs a dual number

Num(<a number>) is the number format function and takes a number and outputs a dual value formatted as specified