topic Re: Conditional Text Color in an Expression in QlikView

Conditional Text Color in an Expression

Tue, 26 Feb 2013 16:43:25 GMT

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:

([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

Re: Conditional Text Color in an Expression

Anonymous — Tue, 26 Feb 2013 18:43:30 GMT

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

Re: Conditional Text Color in an Expression

Wed, 27 Feb 2013 08:58:27 GMT

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)

( 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.

Re: Conditional Text Color in an Expression

Wed, 27 Feb 2013 09:20:52 GMT

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.

Re: Conditional Text Color in an Expression

neetu_singh — Wed, 27 Feb 2013 10:08:26 GMT

Hi,

Plz find the attached file. Hope it will help.

Thanks

Neetu

Re: Conditional Text Color in an Expression

Wed, 27 Feb 2013 10:11:39 GMT

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)

( 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.

Re: Conditional Text Color in an Expression

neetu_singh — Wed, 27 Feb 2013 10:24:10 GMT

Sorry, PFA

Re: Conditional Text Color in an Expression

Wed, 27 Feb 2013 10:36:52 GMT

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)

( 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.

Re: Conditional Text Color in an Expression

Wed, 27 Feb 2013 11:13:28 GMT

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)

( 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.

Re: Conditional Text Color in an Expression

sunilkumarqv — Fri, 28 Feb 2014 07:43:43 GMT

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

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

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

))

Hope you the solution