I'm hoping someone can help. I'm fairly new to QlikView but am trying to replicate the following SQL statement into a QV script. Is anyone able to help at all?
case when FIELD1/(1+((FIELD1-1)*16)/(50*50*2.69)) <= FIELD2 then 1 else 0 end
May be this? I assume, FIELD1 and FIELD2 are numbers?
If(FIELD1/(1+((FIELD1-1)*16)/(50*50*2.69)) <= FIELD2, 1, 0) as Flag
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
May be this? I assume, FIELD1 and FIELD2 are numbers?
If(FIELD1/(1+((FIELD1-1)*16)/(50*50*2.69)) <= FIELD2, 1, 0) as Flag
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
