Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Valued Contributor

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
Honored Contributor

Re: text color

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

7 Replies
Highlighted
Partner
Partner

Re: text color

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

effinty2112
Honored Contributor

Re: text color

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
Valued Contributor

Re: text color

HI

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

kunkumnaveen
Valued Contributor

Re: text color

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

kunkumnaveen
Valued Contributor

Re: text color

Untitled.png

the other value  in BLACK color

Partner
Partner

Re: text color

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
Honored Contributor II

Re: text color

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