Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

helen_pip
Not applicable

Error in Expression for Text Colour

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

1 Solution

Accepted Solutions
Not applicable

Re: Error in Expression for Text Colour

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

5 Replies
neha_shirsath
Not applicable

Re: Error in Expression for Text Colour

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.

helen_pip
Not applicable

Re: Error in Expression for Text Colour

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

Not applicable

Re: Error in Expression for Text Colour

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

helen_pip
Not applicable

Re: Error in Expression for Text Colour

Hello Daniele

Thank you this works

Thanks

Helen

Not applicable

Re: Error in Expression for Text Colour

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

Thank you

Daniele