topic colour help in QlikView

colour help

sagarrahul — Wed, 25 Nov 2020 16:16:04 GMT

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

Outlier

Not Outlier

Outlier

Not Outlier

Not Outlier

Not Outlier

Outlier

Not Outlier

Not Outlier

in advance thank you

Re: colour help

agomes1971 — Thu, 25 Aug 2016 10:28:59 GMT

Hi,

try like this

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

HTH

André Gomes

Re: colour help

marcus_sommer — Thu, 25 Aug 2016 10:31:19 GMT

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

- Marcus

Re: colour help

vinod_nallapaneni — Thu, 25 Aug 2016 10:33:01 GMT

Hi,

By using visual ques you can achieve this.

-Vinod

Re: colour help

Anonymous — Thu, 25 Aug 2016 10:50:10 GMT

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

Re: colour help

MarcoWedel — Fri, 26 Aug 2016 01:11:33 GMT

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