Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
try like this
if(status='Outlier',red(),green())
HTH
André Gomes
Try within the attribute-expressions something like: if(status = 'Outlier', red(), green())
- Marcus
Hi,
By using visual ques you can achieve this.
-Vinod
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())
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