Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is the [Sales Status Code $(=ACode)]?
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)
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.
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.
Hi,
Plz find the attached file. Hope it will help.
Thanks
Neetu
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.
Sorry, PFA
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.
Hi
The $(=ACode) in my expression a selected variable. The full field name
can be either:
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:
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.
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