Multiple Conditions for Color in QlikView Text Box

[psk180590]

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!!

[tresesco · Accepted solution]

This?

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

[MarcoWedel]

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