colour help

[sagarrahul]

hii community

this is my column in my table

want a help in this

in this there are 2 things in my column

1)  'Outlier' and

2)  'Not Outlier'

when 'Outlier' comes then it should b in  ""Red colour"" and

if 'Not Outlier' comes then ""Green colour"" should be on text .

status

Outlier

Not Outlier

Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Outlier

Not Outlier

Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

Not Outlier

in advance thank you

[agomes1971]

Hi,

try like this

if(status='Outlier',red(),green())

HTH

André Gomes

[marcus_sommer]

Try within the attribute-expressions something like: if(status = 'Outlier', red(), green())

- Marcus

[vinod_nallapaneni]

Hi,

   By using visual ques you can achieve this.

-Vinod

[Anonymous]

Hi Sagar,

If you want to write it in Dimension, Expand the dimension and apply the following expression inside the Background color.

=If ( Status= 'Outlier' , RGB(255,0,0), Green())

If you want to write it in Expression, Expand the Measure and apply the following expression inside the Background color.

=If ( Status= 'Outlier' , RGB(255,0,0), Green())

[MarcoWedel]

Hi,

another solution might be:

hope this helps

regards

Marco

P.S.: You currently have lots of open threads. Please try to close those that received correct answers:

        Qlik Community Tip: Marking Replies as Correct or Helpful

thanks