topic Re: If condition in QlikView

If condition

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: If condition

Gysbert_Wassenaar — Mon, 25 Jul 2016 07:57:21 GMT

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 )

Re: If condition

Sun, 07 Aug 2016 21:36:35 GMT

Thanks Gysbert.

Re: If condition

oknotsen — Mon, 08 Aug 2016 09:42:22 GMT

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 .