Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
Partner

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

View solution in original post

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_g
Partner
Partner

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

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