Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

psk180590
Contributor III

Multiple Conditions for Color in QlikView Text Box

Hello All,

I have a very simple condition to fill the color of a Text Box.

I have 4 fileds say A,B,C,D

I have to use them and fill the color of a TextBox using the condition if  A< (B or C or D) then Red else Green.

Seems pretty simple but i'm struggling to put it into QV fromat.

Thanks!!

 

Labels (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Multiple Conditions for Color in QlikView Text Box

This?

If( A <B or A<C or A< D, red(), green())

2 Replies
MVP
MVP

Re: Multiple Conditions for Color in QlikView Text Box

This?

If( A <B or A<C or A< D, red(), green())

Highlighted

Re: Multiple Conditions for Color in QlikView Text Box

If( A < RangeMin(B,C,D), Red(), Green())