If condition

[#1]

Hello Everybody,

I am newbie in Qlikview and I am trying to do a condition for a trafic light.

(A) Column(5)/Column(4) should be max(1)

(B) Column(2)/Column(1) should be max(1)

If(Column(5)/Column(4)+column(2)/column(1)<0.8*0.76,'qmem://<bundled>/BuiltIn/led_r.png', if(Column(5)/Column(4)+column(2)/column(1)>=1*0.76,'qmem://<bundled>/BuiltIn/led_g.png', if( Column(5)/Column(4)+column(2)/column(1)>=0.8*0.76 and Column(5)/Column(4)+column(2)/column(1)<1*0.76,'qmem://<bundled>/BuiltIn/led_y.png')))

I do not know how to unify the A and B conditions.

Thanks for your comments.

Regards,

Ignacio

[Gysbert_Wassenaar]

A: Max(1) = 1 so Column(5)/Column(4) =1

B: Max(1) = 1 so Column(1)/Column(1) =1

A + B = (  Column(5)/Column(4) =1 )  OR (  Column(1)/Column(1) =1 )

[#3]

Thanks Gysbert.

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .