topic Re: text color in QlikView

text color

kunkumnaveen — Thu, 21 Jul 2016 09:18:41 GMT

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

Re: text color

chrisg — Thu, 21 Jul 2016 09:22:47 GMT

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

Re: text color

effinty2112 — Thu, 21 Jul 2016 09:24:07 GMT

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 ?'

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

Re: text color

kunkumnaveen — Thu, 21 Jul 2016 09:26:31 GMT

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

Re: text color

kunkumnaveen — Thu, 21 Jul 2016 09:27:13 GMT

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

Re: text color

kunkumnaveen — Thu, 21 Jul 2016 09:29:38 GMT

the other value in BLACK color

Re: text color

susovan — Thu, 21 Jul 2016 09:34:37 GMT

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

Re: text color

jyothish8807 — Thu, 21 Jul 2016 09:40:19 GMT

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