Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all
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
Thanks
Dan
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
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
Thank you Anil. This works perfect.
Kind regards
Dan