Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

text color

Hello All,

i got about 20 values in a field called que ,which i am displaying in a straight table , among those 20 values i want two values colored  green.so i wrote below expression in Text Color  ,which is not working

=if(que='Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?' ,if(que='Has the sampling processes found to be satisfactory ?', green() ))

i known something wrong with my expression ,can any one suggest me

thanks

naveen

1 Solution

Accepted Solutions
effinty2112
Master
Master

Hi Naveen,

Try:

=if(

que='Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?'

or

que='Has the sampling processes found to be satisfactory ?', green())


Your original expression would only return Green() if que equaled both of the two strings which since the strings aren't equal will never the true.


Cheers


Andrew

View solution in original post

7 Replies
chrisg
Partner - Creator III
Partner - Creator III

Try this

=if(que='Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?',red(),

,if(que='Has the sampling processes found to be satisfactory ?', green(),black() ))

Do or Do Not. There is no try!
effinty2112
Master
Master

Hi Naveen,

Try:

=if(

que='Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?'

or

que='Has the sampling processes found to be satisfactory ?', green())


Your original expression would only return Green() if que equaled both of the two strings which since the strings aren't equal will never the true.


Cheers


Andrew

kunkumnaveen
Specialist
Specialist
Author

HI

only the red colored values is displayed with above exp,the other one not is displaying in black color

kunkumnaveen
Specialist
Specialist
Author

only the red colored values is displayed with above exp,the other one is displaying in black color

kunkumnaveen
Specialist
Specialist
Author

Untitled.png

the other value  in BLACK color

susovan
Partner - Specialist
Partner - Specialist

Hi naveen,

Tit should be work,

if(que='Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?'

or que='Has the sampling processes found to be satisfactory ?',green() )

Warm Regards,
Susovan
jyothish8807
Master II
Master II

Hi Naveen,

Try like this:

=pick(Match(que,'Has the adherence of the plant to the prescribed sampling processes (& feedbacks were provided by the auditor) found to be satisfactory ?' ,'Has the sampling processes found to be satisfactory ?'),green(),green())


Regards

KC

Best Regards,
KC