Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Conditional Text Color in an Expression

In a single cell I am trying to include a Conditional Text Color formula so that based on certain criteria returned values will have different colours within the one cell.

The formula being used is Text Color value of the Expression is:

if

([Sales Status Code $(=ACode)]='C', RGB(0,0,0),

  if ([Sales Status Code $(=ACode)]='E', RGB(255,0,0),

    if ([Sales Status Code $(=ACode)]='R', RGB(200,164,31),

     if ([Sales Status Code $(=ACode)]='U', RGB(0,0,255),

      RGB(0,100,0)))))

However the only colour returned is RGB(0,100,0) for all values.

Any ideas

Thanks

9 Replies
mov
Esteemed Contributor III

Re: Conditional Text Color in an Expression

What is the [Sales Status Code $(=ACode)]?

Not applicable

Re: Conditional Text Color in an Expression

Hi Michael

The is just a sales stage of our House

Sales. We are trying to have a visual representation of each plot's

sales status using colour.

Paul

>>> Michael Solomovich <qcwebmaster@qlik.com> 26/02/2013 18:43 >>>

QlikCommunity

( http://community.qlik.com/index.jspa)

Re: Conditional Text Color in an Expression created by Michael

Solomovich

( http://community.qlik.com/people/msolomov) in Development

(QlikView Desktop) - View the full discussion

( http://community.qlik.com/message/315785#315785)

What is the ?

Reply to this message by replying to this email -or- go to the message

on QlikCommunity

( http://community.qlik.com/message/315785#315785)

Start a new discussion in Development (QlikView Desktop) by email

( mailto:discussions-community-development@community.qlik.com) or

at QlikCommunity

(

http://community.qlik.com/choose-container!input.jspa?contentType=1&containerType=14&container=2004)

© 1993-2011 QlikTech International AB Copyright & Trademarks

( http://www.qlik.com/us/info/copyright) | Privacy

( http://www.qlik.com/us/info/privacy) | Terms of Use

( http://www.qlik.com/us/info/terms-of-use) | Software EULA

( http://www.qlik.com/us/info/software-eula)

**********************************************************************

The Miller Group Limited Registered in Scotland - SC018135

Miller Homes Limited Registered in Scotland - SC255429

Miller Construction (UK) Limited Registered in Scotland - SC209666

Miller Developments Limited Registered in Scotland - SC178108

2 Lochside View

Edinburgh Park

Edinburgh

EH12 9DH

Disclaimer:

The Information in this e-mail is confidential and for use by the

addressee(s) only. It may also be privileged. If you are not the

intended recipient please notify us immediately on +44 (0) 870 336 5000

and delete the message from your computer: you may not copy or forward

it, or use or disclose its contents to any other person.

We do not accept any liability or responsibility for: (1) changes made

to this email after it was sent, or (2) viruses transmitted through this

email or any attachment.

Not applicable

Re: Conditional Text Color in an Expression

Paul,

Apparently, QV isn't evaluating the if part of your expression. It could be because of the L.H.S value in your expression:

What is $(=ACode) in your expression?

I am not sure if [Sales Status Code $(=ACode)] is your field name. If your field name  is [Sales Status Code], try using something like this:

=if([Sales Status Code]='C',RGB(0,0,0),

    if([Sales Status Code]='E',RGB(255,0,0),

        if([Sales Status Code]='R',RGB(200,164,31),

            if([Sales Status Code]='U',RGB(0,0,255)))))

Please see the attached sample. Hope that helps.

Regards,

-Khaled.


neetu_singh
Contributor III

Re: Conditional Text Color in an Expression

Hi,

Plz find the attached file. Hope it will help.

Thanks

Neetu

Not applicable

Re: Conditional Text Color in an Expression

Sorry Neetu. I cannot find the file. Paul

>>> Neetu Singh <qcwebmaster@qlik.com> 27/02/2013 10:08 >>>

QlikCommunity

( http://community.qlik.com/index.jspa)

Re: Conditional Text Color in an Expression created by Neetu Singh

( http://community.qlik.com/people/neetu_singh) in Development

(QlikView Desktop) - View the full discussion

( http://community.qlik.com/message/316013#316013)

Hi,

Plz find the attached file. Hope it will help.

Thanks

Neetu

Reply to this message by replying to this email -or- go to the message

on QlikCommunity

( http://community.qlik.com/message/316013#316013)

Start a new discussion in Development (QlikView Desktop) by email

( mailto:discussions-community-development@community.qlik.com) or

at QlikCommunity

(

http://community.qlik.com/choose-container!input.jspa?contentType=1&containerType=14&container=2004)

© 1993-2011 QlikTech International AB Copyright & Trademarks

( http://www.qlik.com/us/info/copyright) | Privacy

( http://www.qlik.com/us/info/privacy) | Terms of Use

( http://www.qlik.com/us/info/terms-of-use) | Software EULA

( http://www.qlik.com/us/info/software-eula)

**********************************************************************

The Miller Group Limited Registered in Scotland - SC018135

Miller Homes Limited Registered in Scotland - SC255429

Miller Construction (UK) Limited Registered in Scotland - SC209666

Miller Developments Limited Registered in Scotland - SC178108

2 Lochside View

Edinburgh Park

Edinburgh

EH12 9DH

Disclaimer:

The Information in this e-mail is confidential and for use by the

addressee(s) only. It may also be privileged. If you are not the

intended recipient please notify us immediately on +44 (0) 870 336 5000

and delete the message from your computer: you may not copy or forward

it, or use or disclose its contents to any other person.

We do not accept any liability or responsibility for: (1) changes made

to this email after it was sent, or (2) viruses transmitted through this

email or any attachment.

neetu_singh
Contributor III

Re: Conditional Text Color in an Expression

Sorry, PFA

Not applicable

Re: Conditional Text Color in an Expression

Thanks

>>> Neetu Singh <qcwebmaster@qlik.com> 27/02/2013 10:24 >>>

QlikCommunity

( http://community.qlik.com/index.jspa)

Re: Conditional Text Color in an Expression created by Neetu Singh

( http://community.qlik.com/people/neetu_singh) in Development

(QlikView Desktop) - View the full discussion

( http://community.qlik.com/message/316050#316050)

Sorry, PFA

Reply to this message by replying to this email -or- go to the message

on QlikCommunity

( http://community.qlik.com/message/316050#316050)

Start a new discussion in Development (QlikView Desktop) by email

( mailto:discussions-community-development@community.qlik.com) or

at QlikCommunity

(

http://community.qlik.com/choose-container!input.jspa?contentType=1&containerType=14&container=2004)

© 1993-2011 QlikTech International AB Copyright & Trademarks

( http://www.qlik.com/us/info/copyright) | Privacy

( http://www.qlik.com/us/info/privacy) | Terms of Use

( http://www.qlik.com/us/info/terms-of-use) | Software EULA

( http://www.qlik.com/us/info/software-eula)

**********************************************************************

The Miller Group Limited Registered in Scotland - SC018135

Miller Homes Limited Registered in Scotland - SC255429

Miller Construction (UK) Limited Registered in Scotland - SC209666

Miller Developments Limited Registered in Scotland - SC178108

2 Lochside View

Edinburgh Park

Edinburgh

EH12 9DH

Disclaimer:

The Information in this e-mail is confidential and for use by the

addressee(s) only. It may also be privileged. If you are not the

intended recipient please notify us immediately on +44 (0) 870 336 5000

and delete the message from your computer: you may not copy or forward

it, or use or disclose its contents to any other person.

We do not accept any liability or responsibility for: (1) changes made

to this email after it was sent, or (2) viruses transmitted through this

email or any attachment.

Not applicable

Re: Conditional Text Color in an Expression

Hi

The $(=ACode) in my expression a selected variable. The full field name

can be either:

, or

In the selections the user can select the ACode which is either Curr or

Prev.

Hope this makes it clearer as removing the ACode would return the wrong

value.

Thanks

Paul

>>> khaledshahbaaz <qcwebmaster@qlik.com> 27/02/2013 09:20 >>>

QlikCommunity

( http://community.qlik.com/index.jspa)

Re: Conditional Text Color in an Expression created by khaledshahbaaz

( http://community.qlik.com/people/khaledshahbaaz) in Development

(QlikView Desktop) - View the full discussion

( http://community.qlik.com/message/315985#315985)

Paul,

Apparently, QV isn't evaluating the if part of your expression. It

could be because of the L.H.S value in your expression:

What is $(=ACode) in your expression?

I am not sure if is your field name. If

your field name is , try using something like this:

=if(='C',RGB(0,0,0),

if(='E',RGB(255,0,0),

if(='R',RGB(200,164,31),

if(='U',RGB(0,0,255)))))

Please see the attached sample. Hope that helps.

Regards,

-Khaled.

Reply to this message by replying to this email -or- go to the message

on QlikCommunity

( http://community.qlik.com/message/315985#315985)

Start a new discussion in Development (QlikView Desktop) by email

( mailto:discussions-community-development@community.qlik.com) or

at QlikCommunity

(

http://community.qlik.com/choose-container!input.jspa?contentType=1&containerType=14&container=2004)

© 1993-2011 QlikTech International AB Copyright & Trademarks

( http://www.qlik.com/us/info/copyright) | Privacy

( http://www.qlik.com/us/info/privacy) | Terms of Use

( http://www.qlik.com/us/info/terms-of-use) | Software EULA

( http://www.qlik.com/us/info/software-eula)

**********************************************************************

The Miller Group Limited Registered in Scotland - SC018135

Miller Homes Limited Registered in Scotland - SC255429

Miller Construction (UK) Limited Registered in Scotland - SC209666

Miller Developments Limited Registered in Scotland - SC178108

2 Lochside View

Edinburgh Park

Edinburgh

EH12 9DH

Disclaimer:

The Information in this e-mail is confidential and for use by the

addressee(s) only. It may also be privileged. If you are not the

intended recipient please notify us immediately on +44 (0) 870 336 5000

and delete the message from your computer: you may not copy or forward

it, or use or disclose its contents to any other person.

We do not accept any liability or responsibility for: (1) changes made

to this email after it was sent, or (2) viruses transmitted through this

email or any attachment.

sunilkumarqv
Valued Contributor II

Re: Conditional Text Color in an Expression

Hi

Use these Exp in Experssion Tab Go to + see backgound   use these  in same manner what ever field you want to  change instead of First_Norm_Cur_Ass

if

([First_Norm_Cur_Ass]='CREE', RGB(0,0,0),

  if ([First_Norm_Cur_Ass]='Philips', RGB(255,0,0),

))

Hope you the solution

Community Browser