topic Re: Error in Expression for Text Colour in QlikView

Error in Expression for Text Colour

helen_pip — Wed, 09 Jan 2013 09:37:16 GMT

Hello

I was wondering if you could kindly help me

I have written an expression for text colour in table and am getting a syntex error:

if (Level3_Month='95TH CENTILE',time(Fractile({<Inline_Monthly_DataSource={ 'ED'} >} Inline_Monthly_Data_A,0.95>240), RGB(255, 0,0), Green

())

)

The error is in this part of the expression, where the comma is

RGB(255, 0,0), Green ())

Can anyone suggest changes to the script?

Many Thanks

Helen

Re: Error in Expression for Text Colour

neha_shirsath — Wed, 09 Jan 2013 09:58:36 GMT

Hello helen,

If you want to give color to the expression values then in Chart properties > Expression

(

if (Level3_Month='95TH CENTILE',time(Fractile({<Inline_Monthly_DataSource={ 'ED'} >}Inline_Monthly_Data_A,0.95>240)

)

>click on + sign on your expression there you get the Text color> in Definition give your RGB(255,0,0)

rather than giving color in expresiion.

Re: Error in Expression for Text Colour

helen_pip — Wed, 09 Jan 2013 10:01:39 GMT

Hello

Thank you for your response

I ahve written my expression under text colour as suggested, my problem is the fact that there is an error in my expression and need help rewriting my expression

Are you able to help?

Thanks

Helen

Re: Error in Expression for Text Colour

Wed, 09 Jan 2013 10:04:16 GMT

Hello Helen,

try this:

if (Level3_Month='95TH CENTILE' AND time(Fractile({<Inline_Monthly_DataSource={ 'ED'} >} Inline_Monthly_Data_A,0.95)) >240,

RGB(255, 0,0), Green()

)

This should work but I'm not sure is if it is implementing your logic. If it is not working please try to explain your "if" condition with words.

Regards,

Daniele

Re: Error in Expression for Text Colour

helen_pip — Wed, 09 Jan 2013 10:52:28 GMT

Hello Daniele

Thank you this works

Thanks

Helen

Re: Error in Expression for Text Colour

Wed, 09 Jan 2013 10:55:04 GMT

I am glad! Please mark my answer as correct so we can close this post successfully.

Thank you

Daniele